A data warehouse is a centralised analytical repository that integrates cleansed, structured data from multiple operational sources into a subject-oriented, historical model optimised for querying and reporting. It supports business intelligence through schemas such as star and snowflake and columnar storage for fast aggregation. It is a core data-engineering asset enabling consistent enterprise analytics.
Content
- Data is loaded through ETL or ELT into dimensional models that separate facts from descriptive dimensions, then served to BI tools. Modern cloud warehouses decouple storage from compute and use columnar formats to scale analytical queries elastically.