What is a dimension table conceptually?

< 1 min read

A dimension table stores descriptive attributes that provide context to business data.
It includes fields like customer name, city, product category, and calendar details.
These attributes are used for filtering, grouping, and drill-down in reports.
In one project, Product_Dim helped analyze revenue by brand and category.
Each record has a primary key that links to the fact table.
Dimension tables are relatively small and change slowly over time.
They support slicers and hierarchies like Year → Month → Day.
They don’t contain measurable values, only descriptive information.
They make dashboard insights meaningful instead of just totals.

Power BI Essentials