A data warehouse is what you build when you stop asking the operational database to answer business questions. It is denormalized, columnar, and tuned for scans rather than transactions.
In plain language
In data work, this term tends to appear once an organisation outgrows ad-hoc spreadsheets and starts thinking in pipelines and warehouses. A data warehouse is what you build when you stop asking the operational database to answer business questions. It is denormalized, columnar, and tuned for scans rather than transactions. If you are new to the field, the simplest mental model is this: a central store optimized for analytic questions. Read it once with that frame in mind, then come back and read it again — that is usually enough for the rest of the entry to make sense.
An everyday picture
Think of Data Warehouse as the basement of a building: large, quiet, and where almost everything ends up being kept. The room upstairs is what people use; the basement is what makes the room possible.
Where it shows up
Data Warehouse lives behind dashboards, analytics tools, recommendation engines, and back-office reports. Most users never see it directly. The team that uses it is usually the one looking at numbers all day.
A small example
Imagine the scene above. The role Data Warehouse plays is the one its blurb describes — A central store optimized for analytic questions. When last night's sales numbers arrive in a dashboard this morning, ideas like this are part of the pipework that moved them.
Common misunderstanding
One line to take with you
Data Warehouse is leverage on what you already have. Shape the data well and the rest gets easier on its own.