Intermediate · Data
Data warehouse (DW or DWH)
Visual diagram · (in preparation) · Math · (in preparation) · Worked example · 3 difficulty levels.
TL;DR. A central system for reporting and analysis that integrates historical and current data from various sources into one repository.
Technical Definition
A central system for reporting and analysis that integrates historical and current data from various sources into one repository.
How it works
A data warehouse (DW) is a large, centralized repository designed for reporting and data analysis. It consolidates integrated data from multiple, often disparate, sources, storing both current and historical information for business intelligence purposes.
Related Concepts
- Data integration — Combining data from different sources to provide a unified view, crucial for handling large and diverse datasets.