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: You may need to “Save Link As” to download the files.
Sample 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).
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.
Building the Hierarchy Bridge Table article
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).
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