The data warehouse toolkit

This book is a definitive guide to dimensional modeling, starting with fundamental design recommendations and progressing through increasingly complex real-world scenarios.

It covers advanced dimensional modeling patterns, including bridge tables, multivalued attributes, and slowly changing dimensions.

The book also includes case studies from various industries such as retail sales, financial services, telecommunications, and healthcare.

It emphasizes the use of the bus matrix for identifying relationships between dimensions and applications and provides guidance on ETL systems and the Kimball BI/DW life cycle methodology.