Skip to main content

M3 Framework Introduction M3 Framework Overview M3 Phase 0 - Assessment M3 Phase 1 - Readiness M3 Phase 2 - Selection M3 Phase 3 - Engagement M3 Phase 4 - Migration M3 Phase 5 - Operations M3 Resources
M3 Playbook > Phase 4: Migration
4.16 Design and Develop Data Warehouse
4.15 Design and Develop Reports
4.17 Conduct Mock Conversion
Image Map Phase 0: Assessment Phase 1: Readiness Phase 2: Selection Phase 3: Engagement Phase 4: Migration Phase 5: Operations
Objective: Design and develop data warehouses to meet the needs of the customer.

Phase 3 GuidanceResponsible Party - Customer, Provider, Shared
1. Design target state master and transactional data and data marts, considering existing Data Warehouse structure and historical reporting needs (P)
2. Design Master Data Management Approach (P)
3. Document Warehouse design and obtain approval of the customer (P)
4. Develop and test Extract, Transform and Load programs with source systems (S)
5. Build and test data marts (P)
6. Build and develop Business Intelligence reports (P)
7. Obtain approval of the customer (S)

• Target State Concept of Operations
• Integrated Technical Strategy
• Gap Analysis Report
• Existing Data Warehouse Documentation

• Data Warehouse and BI Reports
Stakeholders Update
• Program Manager (C, P) • Technical Lead/Solution Architect (C, P) • Development Team (C, P) • Functional Lead (C, P) • Network SME (C, P) • Functional SMEs (C, P)

Best Practice
• Consider system scalability for future reporting needs