Business analysis glossary
Data Warehouse
What it is
A data warehouse is a central database designed for reporting and analysis. It collects data from many operational systems, cleans and integrates it, and keeps history, so that people can analyse trends across the business without slowing down the systems that run daily operations.
Why it matters
Reports run directly on operational systems are slow, inconsistent and can harm performance. A warehouse provides one consistent, historical view. Analysts write the requirements for what goes into it, how measures are defined and which reports and dashboards it must support, and often query it with SQL.
Example
Nilgiri Health's appointment, billing and laboratory systems each report patient visits differently. A data warehouse brings them together with one definition of a visit and five years of history. The analyst then builds a dashboard of no show rates by department that management can trust.