🗄️Dimension Table
Also known as Dimension, Dim Table
A table that names the things in the facts, such as shops and dates.
Think of it like
It is like a phone book. It turns a code into a name, a place and other details.
Example
dim_product has one row per product, with its name, brand, size and colour. A report groups sales by brand using it.
Why it matters
Dimensions are what make numbers readable. Without them, a report shows codes instead of names.
Definition
Common mistake
Key takeaways
- 1One row per thing. A product, a shop, a day.
- 2Words to filter by. Names, places and groups.
- 3Changes slowly. Far fewer updates than facts.