Skip to content
Get in touch

A data warehouse is the central store where data from a company's separate systems is gathered in a shape built to be queried and compared.

It is worth building once the business knows which joins it actually asks for, and waiting for one before starting is the most common way to lose a year: a single promotion traced end to end on a defined perimeter produces a usable answer in weeks. That first trace tells you which data belongs in the warehouse, so it designs the warehouse better than any preliminary workshop.

An example

A sales director wants to know whether the discount on the flagship product moved channel revenue or merely pulled forward orders that were coming anyway. One promotion traced across twenty stores answers in three weeks, and that measurement names the tables from the management system that are genuinely needed.

Entry map

broader entriesthis entry and narrowertwo levels down← up · → down

cc$BY-NCEnrico Giubertoni. Licensed under CC BY-NC 4.0: you may quote, translate and adapt this entry with the author’s name and a link, stating any changes. For commercial use, write to info@enricogiubertoni.com

Spotted an inaccuracy or something that needs updating? Write to info@enricogiubertoni.com and help make this glossary a better place.

What are your business challenges?

Tell us about your priorities and the objectives you want to reach.
You will receive a free, targeted answer within one working day.