Skip to content Skip to site navigation Skip to service navigation

Microsoft Power BI Bootcamp: Transforming Data to Dashboards

New session times will be displayed below upon confirmation.

Most Technology Training classes will be delivered online until further notice.

Before each sesson, Tech Training will provide a Zoom link for live online classes, along with any required class materials.


This course covers everything from the basics to practical projects. Our hands-on labs ensure you gain real-world experience, and you will leave with the ability to connect to organizational data and create impactful dashboards.

Prerequisites:

- Basic understanding of Databases

Learning Objectives:

- Understand the Power BI ecosystem, including its tools and workflow.
- Extract data from diverse sources such as Excel, CSV, SQL, and the web.
- Master data cleaning and transformation using the Power Query Editor.
- Create reports and visualizations in Power BI Desktop.
- Develop data models with relationships and calculated measures.
- Explore advanced visualizations like maps and custom visuals.
- Utilize filters, slicers, and drill-through options for data exploration.
- Build and format dashboards for effective data storytelling.
- Participate in hands-on project labs to apply your skills.
- Learn about security, app creation, and data connections in Power BI.

Course Outline:
Day-1
Introduction
- What is Power BI?
- What are the Key Tools?
- Typical Workflow
- Power BI Terminology

Extracting Data
- Extracting the data (Excel, .csv, SQL, web)
- Transforming the Data
- Exploring the Power Query Editor
- Applied Steps
- Working With Queries
- Applying Transformations
- Loading Queries

Power BI Desktop Interface
- Report
- Visualizations
- Fields and Filtering
- Formatting and Analytics

Exploring the Data View
- Categorizing Geographical Data
- Formatting Dates
- Controlling Summarization Behavior

Reviewing the Data Model
- What is a Data Model?
- Examine Existing and Creating New Relationships

Measures and Calculated Columns
- Creating Calculated Columns
- Creating simple DAX measures
- Creating a Date Table
- Creating a Dates Table

Day-2
Explore the Visualization Menu

Review a Sample Report
Develop a Report Storyboard
Create and Format Visuals and Pages
- Column and Bar
- Pie
- Adding Pages
- Line
- Matrix
- Formatting Pages
- Maps
- Other Available Visuals

Drill Through Relationships
Using Filters and Slicers
Using Custom Visuals & the Marketplace

- Organizational Visuals
- Additional Page Elements

Create Other Objects in Reports
- Buttons
- Shapes
- Images
- Bookmarks

Publishing the Report
- Establishing a Workspace
- Personal and App Workspaces

Introducing Power BI Service
- App Workspaces
- Create and Format Dashboards
- Get Data
- Update Dashboard

Create and Maintain Apps
- Setting Security
- Finding other Apps
- Connect to organizational data
- Project Labs

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training


University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.