# Data Warehouse

> A big store of data built for reports. Clean data from many apps lives there.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** DWH, Enterprise Data Warehouse, EDW

## Think of it like

It is like a big, tidy library. Every book is checked and put on the right shelf.

## Definition

A data warehouse is a database built for reports, not for running an app. Data from many systems is cleaned and loaded into it. It stores the data in tables with a fixed shape. It is tuned to scan millions of rows fast. Analysts use SQL on it to answer questions about the whole business.

## Example

A chain of 300 shops loads each night's sales into its warehouse. At 8am, the boss can see sales for every shop in one chart.

## Why it matters

It gives the whole company one place to ask questions. Everyone counts from the same numbers.

## Common mistake

Running reports on the app's own database. Big queries slow the app down for customers.

## Three principles

- **Built for reading.** Tuned for big scans and sums.
- **Clean on the way in.** Data has a set shape.
- **One place for all.** Data from many systems sits together.

## Related terms

- [Data Lake](https://learn.benibix.com/term/data/data-lake)
- [Data Lakehouse](https://learn.benibix.com/term/data/data-lakehouse)
- [Data Mart](https://learn.benibix.com/term/data/data-mart)
- [Online Analytical Processing (OLAP)](https://learn.benibix.com/term/data/olap)
- [Extract, Transform, Load (ETL)](https://learn.benibix.com/term/data/etl)
- [Massively Parallel Processing (MPP)](https://learn.benibix.com/term/data/massively-parallel-processing)
- [Data Vault](https://learn.benibix.com/term/data/data-vault)

## Told apart from

- [Data Warehouse vs Data Mart](https://learn.benibix.com/compare/data-warehouse-vs-data-mart): People think a data mart is just a small data warehouse, and it is not quite. A warehouse holds every source in the firm, cleaned and kept for years. A mart is one team's slice, cut from the warehouse for its own questions. Build marts from the warehouse, or each one will clean the data its own way.
- [Data Warehouse vs Data Lake](https://learn.benibix.com/compare/data-warehouse-vs-data-lake): People think a data lake is just a cheaper data warehouse. A warehouse only takes clean tables with a set shape. A lake takes raw files of any kind and shapes them when they are read. The warehouse is easier to trust. The lake is cheaper and keeps everything.
- [Query Engine vs Data Warehouse](https://learn.benibix.com/compare/query-engine-vs-data-warehouse): People think a query engine is a data warehouse. A warehouse keeps the data and runs the queries, all in one product. A query engine only runs the queries. The data stays in files or other databases, and the engine reads it where it is. Both speak SQL, so from the outside they can look the same.

![Three stores side by side. A warehouse holds only clean tables. A lake holds raw files of every kind. A lakehouse keeps raw files in a lake and adds a table layer on top so they can be queried like a warehouse.](https://learn.benibix.com/diagrams/warehouse-lake-lakehouse.svg)

---

Source: https://learn.benibix.com/term/data/data-warehouse
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.
