star schema
Star Schema
A way of organizing analytical data into one central "fact" table surrounded by "dimension" tables — laid out so the relationships look like a star.
When you'd see it: Every warehouse built for BI. The fact table at the center holds the events — orders, sessions, payments. The dimension tables around it describe the people, products, dates, and places the events refer to. BI tools like Looker and Power BI assume this shape.
Why it matters: The star schema is the dominant pattern for analytical data because it makes the trade-off most businesses want: a little redundancy in storage in exchange for fast, intuitive queries. A well-built star schema is the difference between an analyst answering a question in two minutes or two hours.
Common mistakes: Treating the star schema as a one-size-fits-all template. Some questions — graph problems, deep hierarchies, real-time event streams — don't fit cleanly. Forcing them into a star schema produces queries that work but read like a maze.
Study this in BizTech Primer →