Setup Time
Size
Decision Types
Focus
Normalization
Cost
Data Held
Data Sources
Enterprise-wide repository of disparate data sources
100 GB minimum but often in the range of terabytes for large organizations
Varies but often greater than $100,000; for cloud solutions costs can be dramatically lower as organizations pay per use
At least a year for on-premise warehouses; cloud data warehouses are much quicker to set up
Modern warehouses are mostly denormalized for quicker data querying and read performance
Many external and internal sources from different areas of an organization
Strategic decisions that affect the entire enterprise
Raw data, metadata, and summary data