A star is a serving model. Central fact, descriptive edges The star schema works because one measurable process sits in the middle and the dimensions around it answer the natural slicing questions. Who bought it? What was sold? When? Through which channel? Those are analysis questions, so the model exposes them directly. Simpler joins produce more consistent answers Every extra operational join is another opportunity for analysts to pick the wrong table, join at the wrong level, or miss a filter. A star reduces those choices. Fewer paths mean fewer accidental definitions of the same metric. Denormalization is a trade…
Read the full lesson
Sign up free: one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in