Data Warehouse, DSS, and BI Frameworks: Key Concepts

Data Warehouse Development Approaches

Kimball ApproachInmon Approach
EffortData Mart Approach

EDW Approach

ScopeOne Subject AreaSeveral Subject Areas
Development TimeMonthsYears
SourcesOnly Some Operational and External SystemsMany Operational and External Systems
Data TransformationsLow to MediumHigh
Update FrequencyHourly, Daily, WeeklyWeekly, Monthly
Development Cost$10,000 to $100,000+$1,000,000+
Development DifficultyLow to MediumHigh
Data Prerequisite for SharingCommon with Business AreaCommon Across
Read More