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