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

Product Information

  • Title: The Data Warehouse Lifecycle Toolkit
  • Author(s): Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker
  • Release date: January 2008
  • Publisher(s): Wiley
  • ISBN: 9780470149775