John Wiley & Sons, 2013

The Data Warehouse Toolkit, 3rd Edition
Buy on Amazon

Ralph Kimball and Margy Ross co-authored the third edition of Ralph’s classic guide to dimensional modeling. It provides a complete collection of modeling techniques, beginning with fundamentals and gradually progressing through increasingly complex real-world case studies.

The book significantly enhances and expands upon the concepts and examples presented in the earlier editions of The Data Warehouse Toolkit.

  • New chapter with the “official” library of the Kimball dimensional modeling techniques
  • Expanded coverage of advanced dimensional modeling patterns for more complex real-world scenarios, including bridge tables for ragged variable depth hierarchies and multivalued attributes
  • Sample data warehouse bus matrices for 12 case studies
  • Enhanced slowly changing dimension techniques type 0 through 7
  • Recommended best practices for big data analytics
  • Guidance regarding collaborative, interactive dimensional modeling design sessions with business stakeholders
  • Updated overview of the Kimball DW/BI project lifecycle methodology
  • Comprehensive review of extract, transformation, and load (ETL) systems and design considerations, including 34 subsystems and techniques to populate dimensional models

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 3

Sample date dimension spreadsheet

DownloadSample date dimension spreadsheet

Correction to Figure 3-13: The first heading in the lower report shown in Figure 3-13 should read “Calendar Week Ending Date,” just like the top report in that figure.

Correction to text at top of page 100 under Dimension Table Surrogate Keys heading: It has 32 bits and therefore can handle approximately 4 billion unsigned positive values (232) or 4 billion total positive and negative values (-231 to 231-1).

Chapter 4

Correction to text beneath Figure 4-3: The only fully additive metric in the figure is Quantity Sold. The Quantity on Hand and inventory valuation metrics are semi-additive as they can’t be simply summed over time periods; you would want to divide the sum by the number of daily observations to arrive at an average inventory balance or valuation.

Chapter 7

Building the Hierarchy Bridge Table article

Chapter 10

Correction to Figure 10-4: The Customer Key in the far right table of Figure 10-4 should be designated as a primary key (PK), not a foreign key (FK).

Chapter 19

Design Tip #80 Adding a Change Reason Attribute

Design Tip #113 Creating, Using, and Maintaining Junk Dimensions

Design Tip #127 Creating and Managing Mini-Dimensions

Design Tip #137 Creating and Managing Shrunken Dimensions

Design Tip #142 Building Bridges