Power BI — Analytics & Business Reporting
Prepare, model and analyse data with Power Query and Power BI, then design reports with figures you can explain.
The right level. A practical goal.
Start at the level matching your experience. Every stage has prerequisites, workshops and a validation project.
Intermediate
Build an end-to-end Power BI report with explainable, validated metrics.
Prerequisites: Basic Excel, table and aggregation skills; familiarity with simple data preparation.
01Scoping a BI project
- Business question and users
- KPI definitions
- Source and expected quality
02Transforming with Power Query
- Connectors, types and profiling
- Merging and appending queries
- Documented transformation steps
03Creating a star schema
- Facts and dimensions
- Cardinality and filter direction
- Calendar table and keys
04Writing DAX measures
- Measures versus calculated columns
- SUM, DIVIDE and CALCULATE
- Filter context and validation
05Designing an interactive report
- Choosing visuals
- Slicers and interactions
- Navigation, tooltips and accessibility
06Publishing and maintaining
- Model and report in the service
- Refresh and gateway principles
- Workspace and licence checks
Prove it through practice.
Deliver a sales report: cleaned sources, a star schema, a calendar, DAX measures and interactive pages.
Success criteria- Relationships and granularity are justified
- Measures reconcile to a reference calculation
- Interactions are tested and reading guidance is provided
Advanced
Design a performant model, secure distribution and organise long-term operation.
Prerequisites: Solid star-schema, Power Query, DAX measure and publishing skills, or completion of the intermediate level.
01Advanced semantic modelling
- Role-playing dimensions
- Active and inactive relationships
- Import/DirectQuery choices under constraints
02Mastering DAX contexts
- Row context and context transition
- Iterators and variables
- Time calculations with a validated calendar
03Optimising through measurement
- Performance Analyzer
- Cardinality and unnecessary columns
- Comparing query times and results
04Securing data
- Static and dynamic RLS
- Filter propagation
- Testing Viewer and editor roles separately
05Making refresh reliable
- Parameters and dependencies
- Gateway and connection identity
- Incremental refresh depending on context and licensing
06Organising delivery
- Environments and acceptance testing
- Deployment with available tools and licences
- Monitoring, incidents and documentation
Prove it through practice.
Productionise a multi-team report: a documented model, validated DAX, an RLS plan, Viewer-role tests and an operations procedure.
Success criteria- Measures tested across several filter contexts
- RLS verified using appropriate accounts and roles
- Performance measured before and after optimisation
Power BI Desktop on compatible Windows. Power BI account, publishing permissions, gateway and sharing licence must be checked for the workshops; Microsoft subscriptions are not included.
Start with a real lesson.
Before the chart, define what the figure measures.
An explained concept, a diagram or example, then an exercise to work through yourself.
Read the free lessonWhat you will learn to do
- Prepare consistent, validated sources
- Build a simple star schema
- Create measures and understand filter context
- Design a report that serves its audience
Skills across the programme
01Business questions and metric definitions
02Data collection and transformation with Power Query
03Star schemas and relationships
04DAX measures and filter context
05Visualisation and report navigation
06Publishing, access and refresh
Start with the right foundations
Prerequisites
Basic Excel and data table knowledge. Power BI Desktop on a compatible environment.
Language and format
Discovery resources are available in French and English. Contact us to confirm the teaching language, format, materials and support for your chosen programme.
Connect knowledge to a project
Build a sales report with a documented model, validated measures and views suited to decision-makers.
Before you enrol
| Preview lesson | Free · no account |
| Full programme and materials | As confirmed for the session |
| Official exam | Separate registration |
| Cloud environment costs | Check for each lab |
The best way to find out?
Start learning.
One lesson, a real concept and an exercise. Discover our approach, without an account and at your own pace.