Microsoft Power BI Bootcamp: Transforming Data to Dashboards

Date: 4th August 2026 10:00 am to 1pm PDT &
5th August 2026 10:00 am to 1pm PDT

### 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