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
- 01What a Star Schema Actually IsFree
- 02Grain: The One Decision That Defines a Fact Table🔒
- 03Facts vs Dimensions: The Real Test🔒
- 04Additive, Semi-Additive, Non-Additive Measures🔒
- 05Surrogate vs Natural Keys🔒
- 06Snowflake Schemas and Why They Underperform🔒
- 07Junk, Degenerate, and Mini-Dimensions🔒
- 08Factless Fact Tables🔒
- 09Role-Playing Dimensions🔒
- 10Modeling 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.