Skip to content
  1. Home
  2. Insights
  3. The revenue lexicon
  4. Data warehouse

Glossary

Data warehouse

Data 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.

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.