DataTerminology.comNEW
Architectures and practices for integrating, modeling, and storing historical data to support analytics and reporting at scale.
DESCRIPTION
Data warehousing encompasses the processes and architectures to consolidate data from multiple sources into a structured analytical store. It supports consistent metrics, historical analysis, and business intelligence. Common design patterns include star and snowflake schemas, with ETL or ELT pipelines feeding curated layers. Modern cloud warehouses separate storage and compute for elasticity. Warehousing underpins governance, quality, and performance for enterprise analytics. Lakehouse approaches integrate warehousing with data lake flexibility.
ALTERNATIVE DEFINITIONS
Microsoft Learn
A data warehouse is a centralized repository that stores data from multiple sources for reporting and analysis.
Emphasizes centralized repository and analytical use.
Google Cloud
A data warehouse, also called an enterprise data warehouse (EDW), is an enterprise data platform used for the analysis and reporting of structured and semi-structured data from multiple data sources.
Highlights support for both structured and semi-structured data in enterprise analytics.
SAP
A data warehouse (DW) is a digital storage system that connects and harmonizes large amounts of data from many different sources. Its purpose is to feed business intelligence (BI), reporting, and analytics.
Emphasizes harmonization and BI/reporting as primary purpose.
IBM
A data warehouse, or enterprise data warehouse (EDW), is a system that aggregates data from different sources into a single, central, consistent data store to support data analysis, data mining, artificial intelligence (AI), and machine learning.
Notes support for AI/ML and large-scale historical data.
RELATED TERMS
Data Warehouse Extract-Transform-Load ELT Kimball Methodology Star Schema OLAP Data Mart Data Integration
COMPETING TERMS
KNOWLEDGE AREAS
Data Warehousing & BI Data Architecture Data Management Data Engineering
TARGET AUDIENCE
Data Architect Data Engineer Analytics Engineer BI Specialist Data Modeler Data Analyst Chief Data Officer
EXTERNAL SOURCES
- Wikipedia - Data warehouse
- Google Cloud - Vendor guide to warehousing concepts
- Microsoft - Architecture guidance for warehouses
- IBM - Concepts and benefits overview
TOP QUESTIONS
Why is Data Warehousing still relevant today?
It provides governed, performant, historical data models for BI and analytics. Cloud warehouses add elasticity and separation of storage and compute, keeping warehousing central to enterprise data strategies.
Category: Relevancy
How does Data Warehousing differ from a Data Lake?
Warehouses enforce schema-on-write for curated analytics; lakes store raw, diverse data with schema-on-read. Lakehouses blend both approaches.
Category: Misunderstanding
What are the core layers in Data Warehousing?
Typical layers include staging, raw, cleansed, and presentation (dimensional models and marts). Each serves ingestion, standardization, and consumption.
Category: Overview
What are common mistakes in Data Warehousing projects?
Skipping governance, over-modeling early, ignoring performance partitioning, and neglecting cost management often derail success. Lack of clear business metrics also harms adoption.
Category: Mistakes
What risks accompany Data Warehousing?
High initial modeling effort, data drift, and schema changes can cause rework. Poor access controls and lineage lead to compliance and trust issues.
Category: Risk
Which methodologies support Data Warehousing design?
Dimensional modeling (Kimball), Data Vault for agility, and Inmon’s Corporate Information Factory are common approaches aligned to different needs.
Category: Framework
How does ELT change Data Warehousing practice?
ELT leverages warehouse compute to transform after loading, simplifying pipelines and improving scalability versus traditional ETL appliances.
Category: Opinion
What KPIs indicate a healthy Data Warehousing environment?
Query latency, concurrency success rate, freshness SLA adherence, cost per query, and model test pass rates reflect health.
Category: Measurement
Where should I start with Data Warehousing?
Start with clear business questions, define conformed dimensions and metrics, and implement a thin slice with automated tests and lineage.
Category: Getting Started