| |
| |
| |
| Introduction | |
| |
| |
| |
| The Enterprise IT Architecture | |
| |
| |
| The Past: Evolution of Enterprise Architectures | |
| |
| |
| The Present: The IT Professional's Responsibility | |
| |
| |
| Business Perspective | |
| |
| |
| Technology Perspective | |
| |
| |
| Architecture Migration Scenarios | |
| |
| |
| Migration Stratege: How Do We Move Forward? 2 | |
| |
| |
| Data Warehouse Concepts | |
| |
| |
| Gradual Changes in Computing Focus | |
| |
| |
| The Data Warehouse Defined | |
| |
| |
| The Dynamic, Ad Hoc Report | |
| |
| |
| The Purposes of a Data Warehouse | |
| |
| |
| A Word about Data Marts | |
| |
| |
| A Word about Operational Data Stores | |
| |
| |
| Data Warehouse Cost-Benefit Analysis / Return On Investment | |
| |
| |
| |
| People | |
| |
| |
| |
| The Project Sponsor | |
| |
| |
| How Will a Data Warehouse Affect our Decision-Making Processes? | |
| |
| |
| How Does a Data Warehouse Improve My Financial Processes? | |
| |
| |
| Marketing? | |
| |
| |
| Operations? | |
| |
| |
| When Is a Data Warehouse Project Justified? | |
| |
| |
| What Expenses Are Involved? | |
| |
| |
| What Are the Risks? | |
| |
| |
| Risk-Mitigating Approaches | |
| |
| |
| Is My Organization Ready for a Data Warehouse? | |
| |
| |
| How Do I Measure the Results? 4 | |
| |
| |
| The CIO | |
| |
| |
| How Do I Support the Data Warehouse? | |
| |
| |
| How Will My Data Warehouse Evolve? | |
| |
| |
| Who Should Be Involved in a Data Warehouse Project? | |
| |
| |
| What Is the Team Structure Like? | |
| |
| |
| What New Skills Will My People Need? | |
| |
| |
| How Does Data Warehousing Fit into My IT Architecture? | |
| |
| |
| How Many Vendors Do I Need to Talk To? | |
| |
| |
| What Should I Look for in a Data Warehouse Vendor? | |
| |
| |
| How Does Data Warehousing Affect My Existing Systems? | |
| |
| |
| Data Warehousing and its Impact on Other Enterprise Initiatives | |
| |
| |
| When Is a Data Warehouse Not Appropriate? | |
| |
| |
| How Do I Manage or Control a Data Warehouse Initiative? 5 | |
| |
| |
| The Project Manager | |
| |
| |
| How Do I Roll Out a Data Warehouse Initiative? | |
| |
| |
| How Important Is the Hardware Platform? | |
| |
| |
| What Technologies Are Involved? | |
| |
| |
| Do I Still Use Relational Databases for Data Warehousing? | |
| |
| |
| How Long Does a Data Warehousing Project Last? | |
| |
| |
| How Is a Data Warehouse Different from Other IT Projects? | |
| |
| |
| What Are the Critical Success Factors of a Data Warehousing Project? | |
| |
| |
| |
| Process | |
| |
| |
| |
| Warehousing Strategy | |
| |
| |
| Strategy Components | |
| |
| |
| Determine Organizational Context | |
| |
| |
| Conduct Preliminary Survey of Requirements | |
| |
| |
| Conduct Preliminary Source System Audit | |
| |
| |
| Identify External Data Sources (If Applicable) | |
| |
| |
| Define Warehouse Rollouts (Phased Implementation) | |
| |
| |
| Define Preliminary Data Warehouse Architecture | |
| |
| |
| Evaluate Development and Production Environments and Tools | |
| |
| |
| |
| Warehouse Management and Support Processes | |
| |
| |
| Define Issue Tracking and Resolution Process | |
| |
| |
| Perform Capacity Planning | |
| |
| |
| Define Warehouse Purging Rules | |
| |
| |
| Define Security Measures | |
| |
| |
| Define Backup and Recovery Strategy | |
| |
| |
| Set Up Collection of Warehouse Usage Statistics | |
| |
| |
| |
| Data Warehouse Planning | |
| |
| |
| Assemble and Orient Team | |
| |
| |
| Conduct Decisional Requirements Analysis | |
| |
| |
| Conduct Decisional Source System Audit | |
| |
| |
| Design Logical and Physical Warehouse Schema | |
| |
| |
| Produce Source-to-Target Field Mapping | |
| |
| |
| Select Development and Production Environment and Tools | |
| |
| |
| Create Prototype for This Rollout | |
| |
| |
| Create Implementation Plan for this Rollout | |
| |
| |
| Warehouse Planning Tips and Caveats | |
| |
| |
| |
| Data Warehouse Implementation | |
| |
| |
| Acquire and Set Up Development Environment | |
| |
| |
| Obtain Copies of Operational Tables | |
| |
| |
| Finalize Physical Warehouse Schema Design | |
| |
| |
| Build or Configure Extraction and Transformation Subsystems | |
| |
| |
| Build or Configure Data Quality Subsystem | |
| |
| |
| Build Warehouse Load Subsystem | |
| |
| |
| Set-up Data Warehouse Schema | |
| |
| |
| Set Up Data Warehouse Metadata | |
| |
| |
| Set Up Data Access and Retrieval Tools | |
| |
| |
| Perform the Production Warehouse Load | |
| |
| |
| Conduct User Training | |
| |
| |
| Conduct User Testing and Acceptance | |
| |
| |
| |
| Technology | |
| |
| |
| |
| Hardware and Operating Systems | |
| |
| |
| Parallel Hardware Technology | |
| |
| |
| Hardware Selection Criteria | |
| |
| |
| |
| Warehousing Software | |
| |
| |
| Overview | |
| |
| |
| Middleware and Connectivity Tools | |
| |
| |
| Extraction Tools | |
| |
| |
| Transformation Tools | |
| |
| |
| Data Quality Tools | |
| |
| |
| Data Loaders | |
| |
| |
| Database Manag | |