Level 2 of 2
Intermediate Level
Prerequisites
Business Data Analytics Beginner level, or equivalent: clean Excel data, PivotTables and a first Power BI report.
Duration
8 weeks · 90 guided hours · 6 modules. Taught live by an instructor — online or in person.
By the end of this level you can
- Connect, clean and combine data from several sources with Power Query
- Design star-schema data models in Power BI
- Write DAX measures for business KPIs, including time comparisons
- Design clear, interactive and accessible Power BI reports
- Operate reports reliably with refresh, governance and security
Modules
- 1Module 1 · 15 h · 3 lessonsPower Query for Analysts
- 2Module 2 · 16 h · 3 lessonsData Modelling in Power BI
- 3Module 3 · 16 h · 3 lessonsDAX for Business Measures
- 4Module 4 · 15 h · 3 lessonsDesigning Power BI Reports
- 5Module 5 · 13 h · 3 lessonsReport Operations and Governance
- 6Module 6 · 15 h · 3 lessonsBusiness Reporting Project
Intermediate level project
Organisation-Wide Reporting Solution in Power BI
Build a Power BI reporting solution for a realistic organisation — such as a distributor with several branches or an NGO with several programmes — combining sales or activity, budget and reference data, with KPIs, drill-down and a refresh and governance plan.
Deliverables
- Power Query queries combining at least three sources
- A documented star-schema model with a date table
- At least ten DAX measures for agreed KPIs, with checks
- A multi-page report and a governance note (owner, refresh, access)
Assessed on
- KPIs are correct, checked independently and defined in a glossary
- The model follows star-schema principles and is tidy
- Reports are clear, interactive and accessible
- Refresh, ownership and access are planned realistically
All levels are taught live by an instructor — online or in person — see registration options.