A dimensional model is a data structure optimised for analytical queries and reporting, organising data into fact tables containing measurable business events and dimension tables containing descriptive attributes used to filter and group those facts. The dimensional modelling approach — commonly implemented as a star schema or snowflake schema — is the standard technique for structuring data warehouses and analytical databases because it enables intuitive reporting by non-technical users and delivers efficient query performance on large datasets.
Why This Matters
The dimensional model is the dominant data architecture for management reporting and business intelligence because it maps naturally to how business users think about data: facts are the things you measure (revenue, cost, units sold), and dimensions are the ways you want to slice that data (by product, by region, by time period). This alignment between data structure and analytical intent makes dimensional models intuitive to query, easy to extend with new dimensions, and performant even on large volumes of data.
Where This Fits
This term sits within the Reporting area of Performance & Control.
Related Terms
- Data Model
- ETL (Extract, Transform, Load)
- Data Pipeline
- Reporting Granularity
- Business Intelligence (BI)
Related Knowledge
To be added when relevant Knowledge Hub articles are published