Record:   Prev Next
Author Kimball, Ralph
Title The Data Warehouse Lifecycle Toolkit
Imprint Hoboken : John Wiley & Sons, Incorporated, 2008
©2008
book jacket
Edition 2nd ed
Descript 1 online resource (674 pages)
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
Note 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
A thorough update to the industry standard for designing, developing, and deploying data warehouse and business intelligence systems The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. In that time, the data warehouse industry has reached full maturity and acceptance, hardware and software have made staggering advances, and the techniques promoted in the premiere edition of this book have been adopted by nearly all data warehouse vendors and practitioners. In addition, the term "business intelligence" emerged to reflect the mission of the data warehouse: wrangling the data out of source systems, cleaning it, and delivering it to add value to the business. Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. The authors understand first-hand that a data warehousing/business intelligence (DW/BI) system needs to change as fast as its surrounding organization evolves. To that end, they walk you through the detailed steps of designing, developing, and deploying a DW/BI system. You'll learn to create adaptable systems that deliver data and analyses to business users so they can make better business decisions
Description based on publisher supplied metadata and other sources
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2020. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries
Link Print version: Kimball, Ralph The Data Warehouse Lifecycle Toolkit Hoboken : John Wiley & Sons, Incorporated,c2008 9780470149775
Subject Data warehousing
Electronic books
Alt Author Ross, Margy
Thornthwaite, Warren
Mundy, Joy
Becker, Bob
Becker, Bob
Record:   Prev Next