← Training
AdultsALL LEVELSONLINE LIVE
Data Analysis with Power BI
8 weeks • 2 sessions/week • 60 min/session
Free
Turn the spreadsheets your business already produces into dashboards people act on. Covers connecting and cleaning data, modelling it so the numbers reconcile, writing DAX measures, and designing a report that answers a question rather than showing everything at once. Learners work on a realistic dataset throughout.
What you'll learn
- Connect Power BI to Excel, CSV and database sources
- Clean and reshape data in Power Query
- Build a data model with correct relationships
- Write DAX measures for totals, comparisons and period on period change
- Design a dashboard that answers a specific business question
- Publish and share a report, and keep it refreshed
Curriculum
Module 1: Getting data in
Sources, connections, and cleaning in Power Query so the refresh keeps working.
- 1.1 Power BI Desktop tour and your first reportLIVE SESSION · 60 min · Free preview
- 1.2 Connecting Excel, CSV and database sourcesPRACTICAL · 60 min
- 1.3 Cleaning and reshaping in Power QueryPRACTICAL · 60 min
- 1.4 Refresh that keeps workingTEXT · 25 min
- 1.5 Sample sales and stock datasetsDOWNLOAD
- 1.6 Assignment: clean the dataASSIGNMENT
Module 2: Modelling
Tables, relationships, star schema, and why the wrong model gives the wrong total.
- 2.1 Tables, keys and relationshipsLIVE SESSION · 60 min
- 2.2 Star schema: facts and dimensionsPRACTICAL · 60 min
Tracks
Getting data in
2 weeks
Sources, connections, and cleaning in Power Query so the refresh keeps working.
Modelling
2 weeks
Tables, relationships, star schema, and why the wrong model gives the wrong total.
DAX measures
2 weeks
Calculated measures, filter context, and time intelligence.
Report design and publishing
2 weeks
Choosing the right visual, laying out a dashboard, and sharing with a refresh schedule.