SELF-GUIDED BA PRACTICE Packages available · Access after confirmed paymentSee packages ↗

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.

CHECK BEFORE CONTINUING

Keep your work safe