Note: Academy classes require a separate registration - Click
here to register today!
This is a hands-on course so please ensure you have the latest version of Power BI Desktop installed on your machine. If you don't have a laptop it will not be a problem as you will still easily be able to follow along. Click
here to download Power BI Desktop.
Hands-on files (1 x PBIX and 3 x XLSX files) and the PowerPoint file are available to download (see the bottom of this page). Please download the Hands-On files before the session.Introduction - Why do we need BI?
- Traditional BI vs Agile BI
- Overview of BI Tools
- Components of BI (data prep, data modelling, data visualisation)
Data Prep - How and Why?
- Power Query Editor
- Hands On – Connecting to Data (SQL DB, Web, Excel, CSV)
- Hands On – Cleaning Data
- Hands On – Combining Data
- Hands On – Creating a Date / Calendar Table using underlying data date range
- Hands On – Working with Nulls
- Hands On – Working with Date Locales
- Power Query Common Pitfalls
Data Modelling - Understanding Data / FACT tables and Lookup / DIM tables
- Understanding Relationships
- Understanding Evaluation Context
- What is DAX?
- Hands On – Working with Columns
- Hands On – Basic and Intermediate Measures
- Hands On – Quick Measures
Data Visualisation - Drilling Up / Down
- Filtering and Cross Filtering
- Visual, Page, Report Filters
- Working with Dates incl. Relative Date filter
- Formatting tables and graphs
- Bookmarking / Storytelling / Spotlight / Buttons
- Working with Maps
- Custom Visuals
Sharing / Publishing - Reports vs Dashboards
- Apps and Workspaces
- PBI Service, PBI Embedded, PBI Report Server
- Email Subscriptions
- Data Alerts