Skip to main content

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd Edition

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd Edition

Ralph Kimball, Margy Ross

ISBN: 978-0-471-20024-6

Apr 2002

464 pages

Select type: Paperback

Product not available for purchase

Description

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)

Introduction to the Book.

Dimensional Modeling Primer.

Retail Sales.

Inventory.

Procurement.

Order Management.

Customer Relationship Management.

Accounting.

Human Resources Management.

Financial Services.

Telecommunications and Utilities.

Transportation.

Education.

Health Care.

Electronic Commerce.

Insurance.

Building the Data Warehouse.

Present Imperatives and Future Outlook.

Glossary.

Index.
"...this is the daddy of data warehousing process books. No other material available so concisely and precisely explains what is required from a data warehousing solution...this is a great book..." (Enterprise Server Magazine, July 2002)
"...this is the daddy of data warehousing process books. No other material available so concisely and precisely explains what is required from a data warehousing solution...this is a great book..." (Enterprise Server Magazine, July 2002)

Ralph Kimball invented a data warehousing technique called "dimensional modeling" and popularized it in his first Wiley book, The Data Warehouse Toolkit. Since this book was first published in 1996, dimensional modeling has become the most widely accepted technique for data warehouse design. Over the past 5 years, Kimball has improved on his earlier techniques and created many new ones. In this second edition, he provides a comprehensive collection of all of these techniques, from basic to advanced.