All lessons
Data modelling and warehousing: star schemas, facts, dimensions and history
Design the tables behind every dashboard. Normal forms, Kimball star schemas, facts and dimensions, slowly changing dimensions, Data Vault and the lakehouse, and how a warehouse is loaded and tested, with live SQL to build each piece yourself.
What you will be able to do
- Design a star schema from a business process: choose the grain, the facts and the dimensions, and plan a whole warehouse with a bus matrix.
- Handle history with slowly changing dimensions, and answer "as it was then" questions correctly.
- Know the other approaches: normal forms, Inmon, Data Vault, one big table and the lakehouse, and when each fits.
- Load and test a warehouse: staging layers, MERGE, audit columns and tests for keys and orphans.
- Leave with a portfolio project: the Northbay warehouse, designed, built and tested by you, then moved to a cloud warehouse.
Every lesson has diagrams, live SQL boxes where you build each piece in your browser, and a 3-question quiz. Know basic SQL first: SQL for analysts, Modules 1-4. For the tools that run warehouses in production (dbt, Dagster, Azure SQL), go on to Pipeline to Dashboard.
0 of 38 lessons done
Without the tick, your progress lasts until you close this tab. Either way it stays in this browser: there is no sign-up and nothing is sent to us.