Advanced Power BI training
Modelling, advanced DAX, engine performance and governance, for people who already build reports.
| Duration | 5 jours (35 h) |
|---|---|
| Format | On-site |
| Level | Advanced |
| Participants | — |
| Price | Sur devis |
| Certificate | Yes |
Who is this course for ?
Analysts, management controllers and engineers who already produce Power BI reports and hit limits on performance, measure correctness or large-scale sharing.
What will you be able to do by the end ?
- Design a star schema that stays readable and fast across millions of rows.
- Write correct DAX measures under a modified filter context, and debug them.
- Diagnose a slow report and fix the cause rather than the symptom.
- Restrict data access row by row, according to the signed-in user.
- Organise publishing, refresh and versioning of a team's reports.
Programme
-
Day 1 — Rebuilding data preparation
The M language beyond the interface: parameterised queries, custom functions, error handling and unstable sources. Query folding, and why breaking it slows the whole report.
-
Day 2 — Modelling to last
Star schema, granularity, multiple fact tables, many-to-many relationships and bridge tables. A complete date table, hierarchies, and what you should refuse to model.
-
Day 3 — Advanced DAX
Row context and filter context, context transition, CALCULATE and its modifiers, variables, time intelligence. Debugging a wrong measure with the performance analyser and DAX Studio.
-
Day 4 — Performance and security
The VertiPaq engine: compression, cardinality, expensive columns. Diagnosing a slow report, measuring, fixing. Row-level security, roles and per-user testing.
-
Day 5 — Publishing, sharing, governing
Workspaces, apps, lifecycle and deployment. Scheduled refresh, data gateway, failure monitoring. Naming conventions and documenting a model someone else will inherit.
Prerequisites
Regular Power BI practice: you already build reports and write simple measures. Power BI Desktop installed on each participant's machine.
How is the course run ?
Five days built around a single thread: an imperfect model, reworked day after day until it becomes fast, correct and shareable. Every notion is applied to your own data as soon as it is introduced.
Further reading
-
Power BI in business: the 7 mistakes that kill your reports
Most Power BI reports abandoned after three months fail for the same reasons. The seven most frequent mistakes, and how to correct them.
-
Power BI: where do you start when you are coming from spreadsheets?
The first dashboard almost always fails for the same reason: people start with the charts instead of starting with the data. Here is the order that works.
Frequently asked questions
Are courses delivered at our offices?
Yes, and that is the format we recommend: your teams work in their own environment on their own data. Remote and hybrid delivery are possible depending on your constraints.
How many participants per session?
We deliberately cap group sizes to keep time for individual support during exercises. The exact number is set in the quote, according to the course and the level of the group.
Do we work on our own real data?
Yes wherever possible, and this is the main difference from generic training. Exercises use your real datasets, which means participants leave with dashboards and automations they can put straight to use.
Is a certificate issued?
Yes, a named certificate is given to each participant at the end of the course, together with the detailed programme covered.
What happens after the course?
The materials, exercise workbooks and working files stay with you. Follow-up support can be included in the quote, to answer the questions that surface once the learning is put into practice.
How much does a training course cost?
The price depends on four things: the course chosen, its length, the number of participants and the location. An in-house session run on your own data is not priced like a short refresher. We send a quote within 48 hours, free and with no commitment, after a thirty-minute conversation to frame the need and the level of the group.
Updated Oct. 7, 2026