The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

Front Cover
John Wiley & Sons, Aug 8, 2011 - Computers - 464 pages
9 Reviews
The latest edition of the single most authoritative guide on dimensional modeling for data warehousing!

Dimensional modeling has become the most widely accepted approach for data warehouse design. Here is a complete library of dimensional modeling techniques-- the most comprehensive collection ever written. Greatly expanded to cover both basic and advanced techniques for optimizing data warehouse design, this second edition to Ralph Kimball's classic guide is more than sixty percent updated.

The authors begin with fundamental design recommendations and gradually progress step-by-step through increasingly complex scenarios. Clear-cut guidelines for designing dimensional models are illustrated using real-world data warehouse case studies drawn from a variety of business application areas and industries, including:

* Retail sales and e-commerce

* Inventory management

* Procurement

* Order management

* Customer relationship management (CRM)

* Human resources management

* Accounting

* Financial services

* Telecommunications and utilities

* Education

* Transportation

* Health care and insurance

By the end of the book, you will have mastered the full range of powerful techniques for designing dimensional databases that are easy to understand and provide fast query response. You will also learn how to create an architected framework that integrates the distributed data warehouse using standardized dimensions and facts.

This book is also available as part of the Kimball's Data Warehouse Toolkit Classics Box Set (ISBN: 9780470479575) with the following 3 books:

The Data Warehouse Toolkit, 2nd Edition (9780471200246)

The Data Warehouse Lifecycle Toolkit, 2nd Edition (9780470149775)

The Data Warehouse ETL Toolkit (9780764567575)

 

What people are saying - Write a review

User ratings

5 stars
5
4 stars
2
3 stars
2
2 stars
0
1 star
0

Review: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

User Review  - Dan - Goodreads

Really dry reading. Not a great starting off point for beginners. But it would be great as a reference book Read full review

Review: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

User Review  - Abhishek Gupta - Goodreads

Amazing book to grasp the fundamentals and advanced concepts of DWH. Kimball's methodology of explaining the concepts with industry specific scenarios instills learning with business knowledge. Must read for practitioners of DWH. Read full review

Contents

Dimensional Modeling Primer
1
Retail Sales
29
Inventory
67
Procurement
89
Order Management
107
Customer Relationship Management
141
Accounting
173
Human Resources Management
187
Education
243
Health Care
255
Electronic Commerce
277
Insurance
305
Common Dimensional Modeling Mistakes to Avoid
326
Lifecycle Data Track
353
Present Imperatives and Future Outlook
371
Glossary
389

Financial Services
199
Telecommunications and Utilities
217
Transportation
229

Common terms and phrases

About the author (2011)

RALPH KIMBALL, PhD, has been a leading visionary in the data warehouse industry since 1982 and is one of today's most well- known speakers, consultants, and teachers. He writes the "Data Warehouse Designer" column for Intelligent Enterprise magazine and is also the author of the bestselling books The Data Warehouse Lifecycle Toolkit and The Data Webhouse Toolkit (both from Wiley).
MARGY ROSS is President of DecisionWorks Consulting and a Ralph Kimball Associate. She has focused exclusively on decision support and data warehousing since 1982. Margy coauthored the highly acclaimed The Data Warehouse Lifecycle Toolkit, consults on data warehouse projects worldwide, and teaches data warehouse design for Kimball University.

Bibliographic information