Skip to content
BENIBIX Learn

Dimensional Modeling

Data🗄️ Storage & WarehousingDimensional 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

Dimensional modeling is a way to lay out warehouse tables for easy reports. It splits data into facts and dimensions. Facts are events you count, such as sales. Dimensions describe those events, such as the date, the shop and the product. Reports then join facts to dimensions to slice the numbers any way they like.

Common mistake

Copying the app's tables straight into the warehouse. They are built for writes, not for reports.

Key takeaways

  1. 1
    Facts. Events you count and add up.
  2. 2
    Dimensions. The who, what, where and when.
  3. 3
    Built for slicing. Any fact can be split by any dimension.

Compare