Loading
Shape tables so questions are easy to answer and numbers agree everywhere.
Starting with Facts and dimensions (star schema), Slowly changing dimensions, Choosing the grain, and more
Made for you now: slide lessons from basics to production, usually with code and a quiz. See a finished one
Shape tables so questions are easy to answer and numbers agree everywhere.
Data EngineeringStage 3 of 12: Data modelling
Start with these 3. 1 more are one tap away.
The model most warehouses and BI tools expect.
Keep history when a customer moves or a price changes.
Decide what one row means before you build the table.