The Data Warehouse Lifecycle Toolkit, Second Edition -- About the Authors -- Contents at a Glance -- Contents -- Introduction -- How this Book is Organized -- Who Should Read this Book -- How this Book Differs from the First Edition -- Chapter 1: Introducing the Kimball Lifecycle -- Lifecycle History Lesson -- Lifecycle Milestones -- Using the Lifecycle Roadmap -- Lifecycle Navigation Aids -- Lifecycle Vocabulary Primer -- Conclusion -- Chapter 2: Launching and Managing the Project/Program -- Define the Project -- Plan the Project -- Manage the Project -- Manage the Program -- Conclusion -- Managing the Effort and Reducing Risk -- Assuring Quality -- Key Roles -- Key Deliverables -- Estimating Considerations -- Website Resources -- Task List -- Chapter 3: Collecting the Requirements -- Overall Approach to Requirements Definition -- Prepare for the Interview -- Conduct the Interview -- Wrap Up the Interview -- Review the Interview Results -- Prepare and Publish Requirements Deliverables -- Prioritize and Agree on Next Steps -- Adjustments for Project Level Requirements -- Deal with Challenging Interviewees -- Conclusion -- Managing the Effort and Reducing Risk -- Assuring Quality -- Key Roles -- Key Deliverables -- Estimating Considerations -- Website Resources -- Task List -- Chapter 4: Introducing the Technical Architecture -- The Value of Architecture -- Technical Architecture Overview -- Back Room Architecture -- Presentation Server Architecture -- Front Room Architecture -- Infrastructure -- Metadata -- Security -- Conclusion -- Chapter 5: Creating the Architecture Plan and Selecting Products -- Create the Architecture -- Select Products -- Manage the Metadata -- Secure the System -- Create the Infrastructure Map -- Install the Hardware and Software -- Conclusion -- Managing the Effort and Reducing Risk -- Assuring Quality -- Key Roles.

Key Deliverables -- Estimating Considerations -- Website Resources -- Task List -- Chapter 6: Introducing Dimensional Modeling -- Making the Case for Dimensional Modeling -- Dimensional Modeling Primer -- Enterprise Data Warehouse Bus Architecture -- More on Dimensions -- More on Facts -- Fables and Falsehoods About Dimensional Modeling -- Conclusion -- Chapter 7: Designing the Dimensional Model -- Modeling Process Overview -- Get Organized -- Recall the Four-Step Modeling Process -- Design the Dimensional Model -- Embrace Data Stewardship -- Conclusion -- Managing the Effort and Reducing Risk -- Assuring Quality -- Key Roles -- Key Deliverables -- Estimating Considerations -- Website Resources -- Task List -- Chapter 8: Designing the Physical Database and Planning for Performance -- Develop Standards -- Develop the Physical Data Model -- Build the Development Database -- Design Processing Data Stores -- Develop the Initial Index Plan -- Design the OLAP Database -- Build the Test Database -- Design Aggregations -- Design and Build the Database Instance -- Develop the Physical Storage Structure -- Conclusion -- Managing the Effort and Reducing Risk -- Assuring Quality -- Key Roles -- Key Deliverables -- Estimating Considerations -- Website Resources -- Task List -- Chapter 9: Introducing Extract, Transformation, and Load -- Round Up the Requirements -- The 34 Subsystems of ETL -- Extracting Data -- Cleaning and Conforming Data -- Delivering Data for Presentation -- Managing the ETL Environment -- Real Time Implications -- Conclusion -- Chapter 10: Designing and Developing the ETL System -- ETL Process Overview -- Getting Started -- Develop the ETL Plan -- Develop One-Time Historic Load Processing -- Develop Incremental ETL Processing -- Conclusion -- Managing the Effort and Reducing Risk -- Assuring Quality -- Key Roles -- Key Deliverables.

Estimating Considerations -- Website Resources -- Task List -- Chapter 11: Introducing Business Intelligence Applications -- Importance of Business Intelligence Applications -- Analytic Cycle for Business Intelligence -- Types of Business Intelligence Applications -- Navigating Applications via the BI Portal -- Conclusion -- Chapter 12: Designing and Developing Business Intelligence Applications -- Business Intelligence Application Resource Planning -- Business Intelligence Application Specification -- Business Intelligence Application Development -- Business Intelligence Application Maintenance -- Conclusion -- Managing the Effort and Reducing Risk -- Assuring Quality -- Key Roles -- Key Deliverables -- Estimating Considerations -- Website Resources -- Task List -- Chapter 13: Deploying and Supporting the DW/BI System -- System Deployment -- Documentation and Training -- Maintenance and Support -- Conclusion -- Managing the Effort and Reducing Risk -- Assuring Quality -- Key Roles -- Key Deliverables -- Estimating Considerations -- Task List -- Chapter 14: Expanding the DW/BI System -- Manage the Existing Environment -- Prepare for Growth and Evolution -- Conclusion -- Managing the Effort and Reducing Risk -- Assuring Quality -- Key Roles -- Key Deliverables -- Estimating Considerations -- Glossary -- Index.