Skip to content
BENIBIX Learn

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.

Data🗄️ Storage & Warehousing

Data Vault

A way to build a warehouse. It uses hubs, links and satellites.

Data vault is a way to build a data warehouse from three kinds of table. Hubs hold only the business keys, like a customer number. Links record how keys are tied, like which customer placed which order. Satellites hold the details and add a new row each time they change. New sources slot in without changing what is already there.

Example
Emma moves from Leeds to York. The customer satellite gets a new row with the new city, and the old row stays.
Why it matters
It keeps the full history and copes well with many changing sources. That suits large firms with strict audit rules.
Full entry
Data🗄️ Storage & Warehousing

Dimensional Modeling

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

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.
Full entry

In one line

Data Vault
A way to build a warehouse. It uses hubs, links and satellites.
Dimensional Modeling
Warehouse tables split in two kinds. Facts count things. Dimensions say who, what and where.