You are previewing The Data Warehouse Lifecycle Toolkit.
O'Reilly logo
The Data Warehouse Lifecycle Toolkit

Book Description

The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. With this new edition, Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. They walk you through the detailed steps of designing, developing, and deploying a data warehousing/business intelligence system. With substantial new and updated content, this second edition again sets the standard in data warehousing for the next decade.

Table of Contents

  1. The Data Warehouse Lifecycle Toolkit Second Edition
    1. Copyright
    2. About the Authors
    3. Credits
    4. Acknowledgments
    5. Contents at a Glance
    6. Contents
    7. Introduction
      1. How this Book is Organized
      2. Who Should Read this Book
      3. How this Book Differs from the First Edition
    8. Chapter 1: Introducing the Kimball Lifecycle
      1. Lifecycle History Lesson
      2. Lifecycle Milestones
      3. Using the Lifecycle Roadmap
      4. Lifecycle Navigation Aids
      5. Lifecycle Vocabulary Primer
      6. Conclusion
    9. Chapter 2: Launching and Managing the Project/Program
      1. Define the Project
      2. Plan the Project
      3. Manage the Project
      4. Manage the Program
      5. Conclusion
      6. Managing the Effort and Reducing Risk
      7. Assuring Quality
      8. Key Roles
      9. Key Deliverables
      10. Estimating Considerations
      11. Website Resources
      12. Task List
    10. Chapter 3: Collecting the Requirements
      1. Overall Approach to Requirements Definition
      2. Prepare for the Interview
      3. Conduct the Interview
      4. Program Compliance/Security Interviews
      5. Review the Interview Results
      6. Prepare and Publish Requirements Deliverables
      7. Prioritize and Agree on Next Steps
      8. Adjustments for Project Level Requirements
      9. Deal with Challenging Interviewees
      10. Conclusion
      11. Managing the Effort and Reducing Risk
      12. Assuring Quality
      13. Key Roles
      14. Key Deliverables
      15. Estimating Considerations
      16. Website Resources
      17. Task List
    11. Chapter 4: Introducing the Technical Architecture
      1. The Value of Architecture
      2. Technical Architecture Overview
      3. Back Room Architecture
      4. Presentation Server Architecture
      5. Front Room Architecture
      6. Infrastructure
      7. Metadata
      8. Security
      9. Conclusion
    12. Chapter 5: Creating the Architecture Plan and Selecting Products
      1. Create the Architecture
      2. Select Products
      3. Manage the Metadata
      4. Secure the System
      5. Create the Infrastructure Map
      6. Install the Hardware and Software
      7. Conclusion
      8. Managing the Effort and Reducing Risk
      9. Assuring Quality
      10. Key Roles
      11. Key Deliverables
      12. Estimating Considerations
      13. Website Resources
      14. Task List
    13. Chapter 6: Introducing Dimensional Modeling
      1. Making the Case for Dimensional Modeling
      2. Dimensional Modeling Primer
      3. Enterprise Data Warehouse Bus Architecture
      4. More on Dimensions
      5. More on Facts
      6. Fables and Falsehoods About Dimensional Modeling
      7. Conclusion
    14. Chapter 7: Designing the Dimensional Model
      1. Modeling Process Overview
      2. Get Organized
      3. Recall the Four-Step Modeling Process
      4. Design the Dimensional Model
      5. Develop the Detailed Dimensional Model
      6. Embrace Data Stewardship
      7. Conclusion
      8. Managing the Effort and Reducing Risk
      9. Assuring Quality
      10. Key Roles
      11. Key Deliverables
      12. Estimating Considerations
      13. Website Resources
      14. Task List
    15. Chapter 8: Designing the Physical Database and Planning for Performance
      1. Develop Standards
      2. Develop the Physical Data Model
      3. Build the Development Database
      4. Design Processing Data Stores
      5. Develop the Initial Index Plan
      6. Design the OLAP Database
      7. Build the Test Database
      8. Design Aggregations
      9. Design and Build the Database Instance
      10. Develop the Physical Storage Structure
      11. Conclusion
      12. Managing the Effort and Reducing Risk
      13. Assuring Quality
      14. Key Roles
      15. Key Deliverables
      16. Estimating Considerations
      17. Website Resources
      18. Task List
    16. Chapter 9: Introducing Extract, Transformation, and Load
      1. Round Up the Requirements
      2. The 34 Subsystems of ETL
      3. Extracting Data
      4. Cleaning and Conforming Data
      5. Delivering Data for Presentation
      6. Managing the ETL Environment
      7. Real Time Implications
      8. Conclusion
    17. Chapter 10: Designing and Developing the ETL System
      1. ETL Process Overview
      2. Getting Started
      3. Develop the ETL Plan
      4. Develop One-Time Historic Load Processing
      5. Develop Incremental ETL Processing
      6. Conclusion
      7. Managing the Effort and Reducing Risk
      8. Assuring Quality
      9. Key Roles
      10. Key Deliverables
      11. Estimating Considerations
      12. Website Resources
      13. Task List
    18. Chapter 11: Introducing Business Intelligence Applications
      1. Importance of Business Intelligence Applications
      2. Analytic Cycle for Business Intelligence
      3. Types of Business Intelligence Applications
      4. Navigating Applications via the BI Portal
      5. Conclusion
    19. Chapter 12: Designing and DevelopingBusiness Intelligence Applications
      1. Business Intelligence Application Resource Planning
      2. Business Intelligence Application Specification
      3. Business Intelligence Application Development
      4. Business Intelligence Application Maintenance
      5. Conclusion
      6. Managing the Effort and Reducing Risk
      7. Assuring Quality
      8. Key Roles
      9. Key Deliverables
      10. Estimating Considerations
      11. Website Resources
      12. Task List
    20. Chapter 13: Deploying and Supporting the DW/BI System
      1. System Deployment
      2. Documentation and Training
      3. Maintenance and Support
      4. Conclusion
      5. Managing the Effort and Reducing Risk
      6. Assuring Quality
      7. Key Roles
      8. Key Deliverables
      9. Estimating Considerations
      10. Task List
    21. Chapter 14: Expanding the DW/BI System
      1. Manage the Existing Environment
      2. Prepare for Growth and Evolution
      3. Prioritize Opportunities for Growth
      4. Conclusion
      5. Managing the Effort and Reducing Risk
      6. Assuring Quality
      7. Key Roles
      8. Key Deliverables
      9. Estimating Considerations
    22. Glossary
    23. Index