# Dimensional Modeling

> Warehouse tables split in two kinds. Facts count things. Dimensions say who, what and where.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Dimensional Model, Kimball Modeling, Dimensional Data Model

## 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.

## 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.

## 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.

## Common mistake

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

## Three principles

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

## Related terms

- [Fact Table](https://learn.benibix.com/term/data/fact-table)
- [Dimension Table](https://learn.benibix.com/term/data/dimension-table)
- [Star Schema](https://learn.benibix.com/term/data/star-schema)
- [Data Warehouse](https://learn.benibix.com/term/data/data-warehouse)
- [Data Model](https://learn.benibix.com/term/data/data-model)

## Told apart from

- [Data Vault vs Dimensional Modeling](https://learn.benibix.com/compare/data-vault-vs-dimensional-modeling): People think data vault and dimensional modeling compete, so a team must pick one. They do different jobs in the same warehouse. A data vault takes in data from many sources. It keeps every change. A dimensional model lays data out as facts and details for reports. Many teams build the vault first, then star schemas on top.

---

Source: https://learn.benibix.com/term/data/dimensional-modeling
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
