A star schema is a common way to organise data for reporting. It splits data into one central fact table, which records events such as sales, and surrounding dimension tables, which describe them, such as products, customers and dates.
Fact tables
A fact table holds the numbers you measure, such as quantity and amount, along with keys that link to each dimension. It usually has one row per event.
Dimension tables
A dimension table holds descriptive details, such as a product name, category or city. Each row has one key that the fact table points to.
Why analysts use it
- Reports load faster, because the joins are simple.
- Measures are defined once and reused across pages.
- The model is easier for a new team member to understand.
A simple example
A sales fact table links to a product table, a customer table and a date table. A question such as “revenue by product category by month” becomes one join from the fact table to each dimension.
Next step: see our data analytics course, which covers Power BI data modelling at ScholarLogic, or book a free demo class. A counsellor will share the fee and the next batch dates.
