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

Margy Ross and Bob Becker co-authored The Data Warehouse Lifecycle Toolkit, 2nd Edition (Wiley, 2008) with Ralph Kimball, Warren Thornthwaite, and Joy Mundy.

It’s everything you need to know about the Kimball Lifecycle methodology, the broadly-accepted industry standard for DW/BI system design and development.

 

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