Dimensional Modeling Fundamentals
Grain, facts, dimensions, measures, keys — the engine-agnostic vocabulary every metrics layer assumes. Build the words you'll use for the rest of Strata 7.
Grain, facts, dimensions, measures, keys — the engine-agnostic vocabulary every metrics layer assumes. Build the words you'll use for the rest of Strata 7.
Course content
- 01Lab SetupFree
- 02What a Star Schema Actually IsFree
- 03Grain — The One Decision That Defines a Fact Table🔒
- 04Facts vs Dimensions — The Real Test🔒
- 05Additive, Semi-Additive, Non-Additive Measures🔒
- 06Surrogate vs Natural Keys🔒
- 07Snowflake Schemas and Why They Underperform🔒
- 08Junk, Degenerate, and Mini-Dimensions🔒
- 09Factless Fact Tables🔒
- 10Role-Playing Dimensions🔒
- 11Modeling for Change — Why Your Schema is Wrong in 6 Months🔒
What to learn next
Read the first chapter free
Start reading now — no account required for the free chapters.