Glossary
Data warehouse
Subject areaData and infrastructure
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.
Related entries
broader entriesthis entry and narrowertwo levels down← up · → down
Enrico 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.