🗄️Dimensional Modeling
Also known as Dimensional Model, Kimball Modeling, Dimensional Data Model
Warehouse tables split in two kinds. Facts count things. Dimensions say who, what and where.
Think of it like
It is like a receipt and a list of names. The receipt says what was sold. The list says who, what and where.
Example
A coffee chain models each sale as a fact. Date, shop and drink are dimensions, so the boss can see sales by shop and by drink.
Why it matters
It is the most common way to design warehouse tables. Analysts and BI tools expect it.
Definition
Common mistake
Key takeaways
- 1Facts. Events you count and add up.
- 2Dimensions. The who, what, where and when.
- 3Built for slicing. Any fact can be split by any dimension.