The Data Warehouse Lifecycle Toolkit

by Kimball, Ralph; Ross, Margy; Thornthwaite, Warren; Mundy, Joy; Becker, Bob

• ISBN13: 9780470149775
• ISBN10: 0470149779
• Edition: 2nd
• Format: Paperback
• Copyright: 2008-01-10
• Publisher: Wiley

Summary

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.

Author Biography

The authors’ professional careers have followed remarkably similar paths. Each author has focused on data warehousing and business intelligence (DW/BI) consulting and education for more than fifteen years. Most worked together at Metaphor Computer Systems, a pioneering decision support vendor, in the 1980s. All the authors are members of the Kimball Group and teach for KimballUniversity. They contribute regularly to Intelligent Enterprise magazine and other industry publications; most have previously written books in the Toolkit series.
Ralph Kimball founded the Kimball Group. Since the mid 1980s, he has been the DW/BI industry’s thought leader on the dimensional approach and trained more than 10,000 IT professionals. Ralph has his Ph.D. in Electrical Engineering from Stanford University.

Margy Ross is President of the Kimball Group. She has focused exclusively on DW/BI since 1982 with an emphasis on business requirements analysis and dimensional modeling. Margy graduated with a BS in Industrial Engineering from Northwestern University.

Warren Thornthwaite began his DW/BI career in 1980. After managing Metaphor’s consulting organization, he worked for Stanford University and WebTV. Warren holds a BAin Communications Studies from the University of Michigan and anMBA from the University of Pennsylvania’sWharton School.

JoyMundy has focused onDW/BIsystems since 1992 with stints at Stanford, Web TV, and Microsoft’s SQL Server product development organization. Joy graduated from Tufts University with a BA in Economics, and from Stanford University with an MS in Engineering Economic Systems.

Bob Becker has helped clients across a variety of industries with their DW/BI challenges and solutions since 1989, including extensive work with health care organizations. Bob has a BSB in Marketing from the University of Minnesota’s School of Business.

Table of Contents

Acknowledgments

Introduction

Introducing the Kimball Lifecycle

Launching and Managing the Project/Program

Collecting the Requirements

Introducing the Technical Architecture

Creating the Architecture Plan and Selecting Products

Introducing Dimensional Modeling

Designing the Dimensional Model

Designing the Physical Database and Planning for Performance

Introducing Extract, Transformation, and Load

Designing and Developing the ETL System

Introducing Business Intelligence Applications

Designing and Developing Business Intelligence Applications

Deploying and Supporting the DW/BI System

Expanding the DW/BI System

Glossary

Table of Contents provided by Publisher. All Rights Reserved.