Track · 2:33 · Liner note
Star Schema
A star schema is a data model with a central fact table of measurements surrounded by dimension tables of descriptive context, designed for fast and simple analytical queries.
Put the measurements in the middle and the context around them. That is the star schema, and its longevity comes from how well it matches the way people ask questions: how many, by which customer, in which month, for which product.
It is the dependable classic of analytics. Queries become short joins from one fact table to a handful of dimensions, BI tools understand the shape on sight and new analysts can read it in an afternoon. Tooling trends come and go, and the star keeps turning out to be the answer.