Course › Week 5

Week 5. Model it in SQL

Star schemas, SCD2, advanced SQL, dbt, semantic layer. Multi-brand restaurants.

Tables are not a model. This week you design star schemas at the right grain, handle history with SCD Type 2, write the SQL that senior analysts write (windows, gaps-and-islands, cohorts), and manage it all with dbt wired into Dagster.

Sector: the multi-brand restaurant group again, now joined with menu, store and calendar dimensions.

Proof project 5: restaurant-dbt: a tested, documented dbt star schema (sales fact, menu/store/date dimensions, SCD2 on menu price) orchestrated by Dagster.

Days

1. Day 29 Dimensional modelling and grain 4h · learn 90m · lab 115m · ship 20m · review 15m
2. Day 30 Dimensions done right (keys, dates, SCD2) 4h · learn 70m · lab 135m · ship 20m · review 15m
3. Day 31 SQL the way senior analysts write it 4h · learn 60m · lab 150m · ship 15m · review 15m
4. Day 32 dbt, SQL models with software discipline 4h · learn 70m · lab 140m · ship 15m · review 15m
5. Day 33 dbt inside Dagster, and the alternatives 4h · learn 60m · lab 145m · ship 20m · review 15m
6. Day 34 Metrics, additivity and the semantic layer 4h · learn 75m · lab 130m · ship 20m · review 15m
7. Day 35 Proof 5: restaurant-dbt, a tested star schema 4h · build 150m · README 60m · review 30m