Skip to main content

Dimensional Modelling for BI Analysts

Dimensional modelling is a way of structuring analytical data into fact tables holding measurable events and dimension tables describing who, what, where and when. Arranged as a star schema, it makes reports simple to write and fast to run, and it is the standard model behind Power BI and warehouse reporting.

Stage: Data Modelling · Part of the BI Analyst roadmap · Last reviewed 19 November 2026

What to learn in Dimensional Modelling

Dimensional Modelling interview questions

What does the grain of a fact table mean?

Grain is the level of detail one row represents, for example one line item on one invoice. Declaring it first keeps measures consistent and prevents double counting. Every dimension and measure added later must be valid at that exact grain.

Why prefer a star schema over a fully normalised model for reporting?

A star schema needs fewer joins, so queries are simpler and faster, and business users can understand it. Normalised models reduce redundancy for transactional writes but make analytical queries long and slow. Reporting tools also optimise for star-shaped relationships.

Where Dimensional Modelling fits in the BI Analyst roadmap

Dimensional Modelling belongs to the Data Modelling stage (beginner level). Make reports fast and right.

Back to the full BI Analyst roadmap