John Wiley & Sons, 2008

The Data Warehouse Lifecycle Toolkit, 2nd Edition: Practical Techniques for Building Data Warehouse and Business Intelligence Systems
Buy on Amazon

The world of data warehousing and business intelligence has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. Ralph Kimball and the Kimball Group refined the original set of lifecycle methods and techniques.

With significant amounts of new and updated material, The Data Warehouse Lifecycle Toolkit, 2nd Edition will set the standard for DW/BI system design and development for the next decade. It’s everything you need to know about the Kimball methodology.

Tools and Utilities

NOTE: If your browser opens a file rather than downloading it, try right-clicking on the link and selecting “Save Target As.”

Chapter 2

Project plan task list

Chapter 3

Requirements questionnaire for business manager or analyst

Example pre-interview letter to brief interviewee

Example business user kickoff meeting agenda

Chapter 5

Sample architecture document table of contents

Sample product evaluation matrix

Metadata data model and create scripts

Chapter 7

Example high level model diagram

Example detailed dimensional design worksheet

Chapter 8

Physical model template

Chapter 10

Date dimension spreadsheet

Chapter 12

Sample report mockup

Sample report description spreadsheet