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
-
The Data Warehouse Lifecycle Toolkit Second Edition
- Copyright
- About the Authors
- Credits
- Acknowledgments
- Contents at a Glance
- Contents (1/4)
- Contents (2/4)
- Contents (3/4)
- Contents (4/4)
- Introduction
- Chapter 1: Introducing the Kimball Lifecycle
-
Chapter 2: Launching and Managing the Project/Program
- Define the Project (1/3)
- Define the Project (2/3)
- Define the Project (3/3)
- Plan the Project (1/3)
- Plan the Project (2/3)
- Plan the Project (3/3)
- Manage the Project (1/2)
- Manage the Project (2/2)
- 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 (1/3)
- Prepare for the Interview (2/3)
- Prepare for the Interview (3/3)
- Conduct the Interview
- Program Compliance/Security Interviews
- Review the Interview Results
- Prepare and Publish Requirements Deliverables
- Prioritize and Agree on Next Steps
- Adjustments for Project Level Requirements (1/2)
- Adjustments for Project Level Requirements (2/2)
- 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 (1/2)
- Technical Architecture Overview (2/2)
- Back Room Architecture (1/3)
- Back Room Architecture (2/3)
- Back Room Architecture (3/3)
- Presentation Server Architecture (1/2)
- Presentation Server Architecture (2/2)
- Front Room Architecture (1/3)
- Front Room Architecture (2/3)
- Front Room Architecture (3/3)
- Infrastructure (1/3)
- Infrastructure (2/3)
- Infrastructure (3/3)
- Metadata
- Security
- Conclusion
-
Chapter 5: Creating the Architecture Plan and Selecting Products
- Create the Architecture (1/3)
- Create the Architecture (2/3)
- Create the Architecture (3/3)
- Select Products (1/4)
- Select Products (2/4)
- Select Products (3/4)
- Select Products (4/4)
- Manage the Metadata
- Secure the System (1/3)
- Secure the System (2/3)
- Secure the System (3/3)
- 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 (1/2)
- Dimensional Modeling Primer (2/2)
- Enterprise Data Warehouse Bus Architecture
- More on Dimensions (1/4)
- More on Dimensions (2/4)
- More on Dimensions (3/4)
- More on Dimensions (4/4)
- More on Facts (1/2)
- More on Facts (2/2)
- Fables and Falsehoods About Dimensional Modeling
- Conclusion
-
Chapter 7: Designing the Dimensional Model
- Modeling Process Overview
- Get Organized (1/2)
- Get Organized (2/2)
- Recall the Four-Step Modeling Process
- Design the Dimensional Model
- Develop the Detailed Dimensional Model (1/4)
- Develop the Detailed Dimensional Model (2/4)
- Develop the Detailed Dimensional Model (3/4)
- Develop the Detailed Dimensional Model (4/4)
- 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 (1/2)
- Develop Standards (2/2)
- Develop the Physical Data Model (1/2)
- Develop the Physical Data Model (2/2)
- Build the Development Database
- Design Processing Data Stores
- Develop the Initial Index Plan (1/2)
- Develop the Initial Index Plan (2/2)
- 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 (1/2)
- Cleaning and Conforming Data (2/2)
- Delivering Data for Presentation (1/4)
- Delivering Data for Presentation (2/4)
- Delivering Data for Presentation (3/4)
- Delivering Data for Presentation (4/4)
- Managing the ETL Environment (1/3)
- Managing the ETL Environment (2/3)
- Managing the ETL Environment (3/3)
- Real Time Implications (1/2)
- Real Time Implications (2/2)
- Conclusion
-
Chapter 10: Designing and Developing the ETL System
- ETL Process Overview
- Getting Started
- Develop the ETL Plan (1/2)
- Develop the ETL Plan (2/2)
- Develop One-Time Historic Load Processing (1/4)
- Develop One-Time Historic Load Processing (2/4)
- Develop One-Time Historic Load Processing (3/4)
- Develop One-Time Historic Load Processing (4/4)
- Develop Incremental ETL Processing (1/3)
- Develop Incremental ETL Processing (2/3)
- Develop Incremental ETL Processing (3/3)
- 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 (1/4)
- Types of Business Intelligence Applications (2/4)
- Types of Business Intelligence Applications (3/4)
- Types of Business Intelligence Applications (4/4)
- Navigating Applications via the BI Portal
- Conclusion
-
Chapter 12: Designing and DevelopingBusiness Intelligence Applications
- Business Intelligence Application Resource Planning
- Business Intelligence Application Specification (1/3)
- Business Intelligence Application Specification (2/3)
- Business Intelligence Application Specification (3/3)
- Business Intelligence Application Development (1/3)
- Business Intelligence Application Development (2/3)
- Business Intelligence Application Development (3/3)
- 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 (1/4)
- System Deployment (2/4)
- System Deployment (3/4)
- System Deployment (4/4)
- Documentation and Training
- Maintenance and Support (1/2)
- Maintenance and Support (2/2)
- Conclusion
- Managing the Effort and Reducing Risk
- Assuring Quality
- Key Roles
- Key Deliverables
- Estimating Considerations
- Task List
- Chapter 14: Expanding the DW/BI System
- Glossary (1/5)
- Glossary (2/5)
- Glossary (3/5)
- Glossary (4/5)
- Glossary (5/5)
- Index (1/5)
- Index (2/5)
- Index (3/5)
- Index (4/5)
- Index (5/5)
Product information
- Title: The Data Warehouse Lifecycle Toolkit
- Author(s):
- Release date: January 2008
- Publisher(s): Wiley
- ISBN: 9780470149775
You might also like
book
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Single most authoritative guide from the inventor of the technique. Presents unique modeling techniques for e-commerce, …
book
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data
Cowritten by Ralph Kimball, the world's leading data warehousing authority, whose previous books have sold more …
book
Beginning Azure Synapse Analytics: Transition from Data Warehouse to Data Lakehouse
Get started with Azure Synapse Analytics, Microsoft's modern data analytics platform. This book covers core components …
book
Automating the Modern Data Warehouse
The opportunity to modernize and improve the enterprise data warehouse is one of the best reasons …