🏢Enterprise Data Warehouse

NEW

Also known as: EDW, DWH

Central analytical repository integrating enterprise data into consistent models for reporting, BI, and advanced analytics.

DESCRIPTION

An enterprise data warehouse consolidates data from multiple operational systems into a governed, consistent analytical store. It supports standardized metrics, historical analysis, and cross-domain reporting. Commonly modeled using dimensional or data vault approaches, EDWs power BI dashboards, self-service analytics, and data science. Cloud-native EDWs deliver elasticity, separation of storage and compute, and semi-structured support. Governance, data quality, and master data are core to EDW success. Modern architectures blend EDWs with lakes and lakehouses.

ALTERNATIVE DEFINITIONS

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.

Explicitly equates EDW with an enterprise analytics platform supporting multiple data types.

Source

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.

Stresses centralization and AI/ML workloads.

Source

RELATED TERMS

Data Warehouse Data Mart Extract-Transform-Load ELT Kimball Methodology OLAP Master Data Management Semantic Layer

COMPETING TERMS

Data Lakehouse Data Lake

RELATIONS

• Broader: Data Warehouse

KNOWLEDGE AREAS

Data Warehousing & BI Data Architecture Data Management Data Services

TARGET AUDIENCE

Chief Data Officer Data Architect BI Specialist Data Engineer Data Modeler Data Governance Manager Data Analyst

EXTERNAL SOURCES

• Wikipedia - Data warehouse
• Microsoft - Azure guidance on data warehouses
• Google Cloud - Vendor overview of EDW concepts
• Snowflake - Cloud EDW concepts and architecture

TOP QUESTIONS

What business value does an Enterprise Data Warehouse provide?

It delivers a consistent, governed source of truth for enterprise analytics, enabling reliable KPIs, cross-domain insights, and regulatory reporting.

Category: Value

How does an Enterprise Data Warehouse differ from a Data Lake?

An EDW prioritizes curated, structured data for analytics; a lake stores raw, multi-format data with schema-on-read.

Category: Comparison

Which modeling approaches are common in an Enterprise Data Warehouse?

Kimball dimensional modeling and Data Vault are prevalent, often combined for agility, auditability, and business alignment.

Category: Modeling

What are key success factors for an Enterprise Data Warehouse?

Strong governance, data quality management, clear data ownership, and scalable ELT/ETL with robust documentation are essential.

Category: Best practices

What are common mistakes when building an Enterprise Data Warehouse?

Over-engineering early, neglecting data quality, weak metadata, and misaligned business requirements can derail adoption.

Category: Mistakes

How do cloud-native EDWs change the architecture?

They offer elastic compute, decoupled storage, and managed services, enabling ELT and rapid iteration.

Category: Architecture

Is an Enterprise Data Warehouse still relevant in a Lakehouse era?

Yes, standardized, governed analytics remain critical; lakehouses often embed EDW-like semantics.

Category: Relevancy

How is data integrated into an Enterprise Data Warehouse?

Through batch or streaming ELT/ETL pipelines, with CDC for freshness and staging for quality checks.

Category: Integration

What governance belongs around an Enterprise Data Warehouse?

Data stewardship, access controls, lineage, data catalogs, and policy enforcement ensure trust and compliance.

Category: Governance