A lot of reporting is still done by hand: export, paste, format, email, repeat. Power BI replaces that with a report that refreshes itself and lives in one place.
In two days your team works through the full workflow on guided exercises. They connect to data, clean it in Power Query, build a model with proper relationships, write their first DAX measures and design interactive reports with slicers, trends and maps. Then they publish to the Power BI Service, set up workspaces, schedule refresh, and check how the report looks on a phone.
By the end, participants can
- Navigate Power BI Desktop and discover data from multiple sources
- Clean and transform data using Power Query, and read the underlying M language
- Build robust data models with proper relationships
- Create calculated measures using DAX (Data Analysis Expressions)
- Design interactive reports using slicers, tables, charts, trends and maps
- Publish, share and manage reports and dashboards in the Power BI Service
- Schedule data refresh and use Q&A to explore data in plain language
- Design reports and dashboards that work well on mobile devices
Course outline
Day 1 · Prepare and Model Your Data
01Introduction to Power BI
- Getting started and BI basics
- Power BI Desktop overview
- Data discovery: connecting to and exploring data sources
02Transforming Data
- Basic transforms: clean, shape and prepare data in Power Query
- Reading and understanding M, the language behind every transformation
03Data Modelling
- Principles of data modelling
- Creating relationships between tables
04Introduction to DAX
- Creating calculated measures
Day 2 · Visualise, Share and Go Mobile
05Creating Interactive Reports
- Introduction to visualising data and building basic reports
- Adding slicers for filters
- Visualising tabular data
- Visualising categorical data
- Visualising data trends
- Combining categorical and trend data
- Visualising geographic data with maps
06Using the Power BI Service
- Deploying reports
- Setting up workspaces
- Creating and sharing dashboards
- Interacting with Q&A
- Scheduling data refresh
07Power BI Mobile
- Designing reports and dashboards for Power BI Mobile
- Power BI Mobile overview