•Identify and conform primary dimensions for the entire business (Figure 14.4).
Core Operational Concepts.
•Identify key transaction grain fact tables for the
entire business (Figure 14.5)
•Create a high-level dimensional EDW design expressing all relationships (Figure 14.6)
•Prioritize subject areas for development (business need)
•Identify source system changes (risk management)
•Select data storage, movement, and analysis
sofotware
•Document objectives, assumptions and business requirements
•See also “A Practical Guide
to Building Data Marts” on the text CD.