Data Warehouse

Definition

A centralised repository of structured, processed data optimised for analytical querying and business intelligence reporting. Data warehouses use a schema-on-write approach, meaning data is cleaned, transformed, and organised into predefined structures before loading. They are designed for fast query performance on historical and aggregated data, making them ideal for dashboarding, trend analysis, and regulatory reporting. Leading platforms include Snowflake, Google BigQuery, and Amazon Redshift.