The business problem
A BI model imports duplicates, mixes grains and repeats calculations already stable in the database.
What you will be able to do
Produce a documented source query suited to a Power BI model.
- Define the grain
- Prepare dimensions and facts
- Divide work between SQL and Power Query
- Control refresh
What this micro-course does not promise yet
The content, exercises and laboratory are not accessible yet. This page describes a production goal, not a skill you can already practise on SQL.tn.
Prerequisites
- JOIN and aggregations
- Basic Power BI modelling
Project and practice
The planned structure contains 8 exercises and a mini-project. They will remain unavailable until they have been run and validated.