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.
|Edition description:||New Edition|
|Product dimensions:||7.20(w) x 9.20(h) x 1.40(d)|
About the Author
Ralph Kimball, PhD, is the Founder of the Kimball Group and has been a leading visionary in the data warehouse industry since 1982.
Table of Contents
Chapter 1 Introducing the Kimball Lifecycle 1
Chapter 2 Launching and Managing the Project/Program 15
Chapter 3 Collecting the Requirements 63
Chapter 4 Introducing the Technical Architecture 109
Chapter 5 Creating the Architecture Plan and Selecting Products 179
Chapter 6 Introducing Dimensional Modeling 233
Chapter 7 Designing the Dimensional Model 287
Chapter 8 Designing the Physical Database and Planning for Performance 327
Chapter 9 Introducing Extract, Transformation, and Load 369
Chapter 10 Designing and Developing the ETL System 425
Chapter 11 Introducing Business Intelligence Applications 473
Chapter 12 Designing and Developing Business Intelligence Applications 505
Chapter 13 Deploying and Supporting the DW/BI System 541
Chapter 14 Expanding the DW/BI System 579
Most Helpful Customer Reviews