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

Paperback (Print)
Rent from
(Save 67%)
Est. Return Date: 07/28/2015
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 96%)
Other sellers (Paperback)
  • All (28) from $1.99   
  • New (7) from $6.67   
  • Used (21) from $1.99   


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)

Read More Show Less

Editorial Reviews

From Barnes & Noble
Two acclaimed data warehouse experts share an unmatched library of techniques -- both basic and advanced -- for designing fast, versatile, accessible dimensional databases. They also illustrate their methods at work in e-commerce, financial services, telecommunications, transportation, education, health care, and other industries.
From the Publisher
"...this is the daddy of data warehousing process books. No othermaterial available so concisely and precisely explains what isrequired from a data warehousing solution...this is a greatbook..." (Enterprise Server Magazine, July 2002)
From The Critics
Utilizing case studies from a variety of business applications, the authors present dimensional modeling techniques for data warehousing. Emphasizing user understandability and query performance, chapters cover techniques in the areas of retail sales , inventory, procurement, order management, customer relationship management, accounting, human resource management, financial services, telecommunications and utilities, transportation, education, health care, electronic commerce, and insurance. Final chapters discuss the construction of the data warehouse framework and future trends. Annotation c. Book News, Inc., Portland, OR
Read More Show Less

Product Details

  • ISBN-13: 9780471200246
  • Publisher: Wiley
  • Publication date: 4/28/2002
  • Edition description: REV
  • Edition number: 2
  • Pages: 464
  • Product dimensions: 7.38 (w) x 9.24 (h) x 1.05 (d)

Meet the Author

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

Read More Show Less

Table of Contents

Introduction to the Book.

Dimensional Modeling Primer.

Retail Sales.



Order Management.

Customer Relationship Management.


Human Resources Management.

Financial Services.

Telecommunications and Utilities.



Health Care.

Electronic Commerce.


Building the Data Warehouse.

Present Imperatives and Future Outlook.



Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 – 2 of 3 Customer Reviews
  • Anonymous

    Posted April 9, 2012


    R u on

    Was this review helpful? Yes  No   Report this review
  • Posted May 19, 2009

    more from this reviewer

    Data Warehouse: Dimensional Modeling

    This is an excellent and wonderful book and it contains the details at data warehouse architect level. I use it extensively as a reference and also recommend to my juniors who like to learn data warehousing and techniques. The first three chapters are covers at very basic level. The remaining chapters cover more in depth, which covers details of dimensional modelling.

    This book covers dimensional modelling for different industries under different discipline. So readers may find difficult to understand if they are not familiar with that industry. This is a good eye opener for those who want to know the dimensional modelling for the specific industry. Also, doing a project for a particular industry will help immensely in understanding the more detailed aspects of some chapters and hence fully understand the concepts.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 – 2 of 3 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)