Business analysis glossary
Star Schema
What it is
A star schema is a way of organising data for reporting with one central fact table holding measurements, such as sales amounts or counts, surrounded by dimension tables holding descriptive details, such as date, product, customer and region. Drawn on paper, it looks like a star.
Why it matters
Star schemas make reports fast and easy to build, and they are the recommended model in Power BI. Understanding them helps analysts design dashboards, write correct measures and explain why some reports give wrong totals when relationships are set up badly.
Example
For a sales dashboard, the analyst designs a star schema: a fact table of order lines with quantity and amount, and dimensions for date, product, customer and store. Every slicer and chart filters through the dimensions, and total sales by region match the finance figures exactly.