Coming soon · Book Profile

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

The definitive guide to dimensional modeling for data warehousing and business intelligence, teaching practitioners how to design simple, fast, business-driven analytic databases through case-study-driven techniques.

A profile of this book is on the way.

Get the book →

What it’s about

The Data Warehouse Toolkit, Third Edition, by Ralph Kimball and Margy Ross, is the industry's seminal reference for dimensional modeling. Drawing on decades of real-world consulting experience, the authors present a comprehensive, technique-centric methodology for building data warehouse and business intelligence (DW/BI) systems that prioritize two simultaneous goals: business user understandability and fast query performance. Organized around vivid business vignettes spanning retail, inventory, procurement, order management, accounting, CRM, HR, finance, telecom, transportation, education, healthcare, e-commerce, and insurance, the book develops more than 75 dimensional modeling techniques—fact tables and dimension tables, the enterprise data warehouse bus matrix with conformed dimensions, slowly changing dimension techniques, bridge tables, and accumulating snapshots—while dispelling persistent myths about dimensional design. It then extends into the full Kimball Lifecycle, the 34 subsystems of ETL, and emerging big data analytics best practices. Whether you are a designer, modeler, ETL developer, or DW/BI manager, this toolkit equips you to marshal an organization's data and deliver it to business users for better, fact-based decision making.

The through-line

Who it’s for: A DW/BI designer, modeler, ETL developer, or manager who wants to deliver analytic data that business users can easily understand and query quickly to make better, fact-based decisions.
The problem: Organizations collect tons of data scattered across disparate operational systems but can't access, integrate, or analyze it consistently or quickly. Practitioners feel overwhelmed by complexity and uncertain whether their designs will withstand unpredictable business questions, fearing the dreaded 'it depends' spaghetti-mess of databases.
The plan: Focus first on business requirements and the most critical, feasible business process.
Apply the four-step dimensional design process: select the business process, declare the grain, identify dimensions, identify facts.
Build fact tables at the lowest atomic grain with verbose dimension attributes.
Integrate processes using conformed dimensions on the enterprise data warehouse bus architecture.
Handle attribute changes with appropriate slowly changing dimension techniques.
The payoff: Business professionals make better decisions and generate payback on DW/BI investments. · A coherent, integrated DW/BI environment delivers consistent, understandable, and fast information across the enterprise. · Development becomes more agile as conformed dimensions are reused, shrinking time-to-market for new business processes.

See our guide

Related profiles we’ve built

Additional reading

Competing on Analytics: The New Science of Winning · Thomas H. Davenport and Jeanne G. Harris
The authors' previous book, which provides the strategic context by describing the earliest and most aggressive adopters of analytics. This book builds on it by providing a 'how-to' guide for all organizations.
Sources of Power: How People Make Decisions · Gary Klein
Discusses decision-making in high-pressure situations where there is no time for systematic data gathering, providing a contrast to the analytical approach and showing when intuition is necessary.
The Black Swan: The Impact of the Highly Improbable · Nassim Nicholas Taleb
Argues that statistical analysis is limited because it cannot predict rare, high-impact 'black swan' events, serving as a cautionary note on the limits of analytics.
Moneyball: The Art of Winning an Unfair Game · Michael Lewis
A popular case study of how the Oakland A's baseball team used an analytical approach to player selection to compete with richer teams, illustrating the power of competing on analytics.
Why Great Leaders Don't Take Yes for an Answer · Michael Roberto
Describes how to foster a culture of constructive conflict and debate in decision-making processes, which is essential for an analytical culture where assumptions are tested and merit triumphs over politics.
The Visual Display of Quantitative Information · Edward Tufte
A foundational work on how to create clear visual representations of data, a key skill for communicating analytical findings effectively.
Super Crunchers: Why Thinking-By-Numbers Is the New Way to Be Smart · Ian Ayres
The book discusses how statistical analyses are replacing human intuition and expert judgment in decision-making, a core theme related to the discussion of 'Moneyball' and the demise of the expert.
Seeing Like a State: How Certain Schemes to Improve the Human Condition Have Failed · James Scott
Documents how governments' fetish for quantification and data can lead to misguided and harmful policies, providing a deep historical context for the book's warnings about the 'dictatorship of data'.
The War Managers · Douglas Kinnard
A survey of U.S. generals' views on the Vietnam War, revealing that the 'body count' metric was seen as a worthless and inflated measure of progress, illustrating the dangers of relying on flawed data.
Thinking, Fast and Slow · Daniel Kahneman
Explains the cognitive biases that lead humans to see illusory causal links, which the author's argue big data correlations can challenge and disprove.