The Data Warehouse Toolkit and over 360,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device. Learn more

 

or
Sign in to turn on 1-Click ordering.
 
 
Express Checkout with PayPhrase
What's this? | Create PayPhrase
Sorry!
More Buying Choices
58 used & new from $27.80

Have one to sell? Sell yours here
 
   
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
 
 
Start reading The Data Warehouse Toolkit on your Kindle in under a minute.

Don’t have a Kindle? Get your Kindle here.
 
  

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition) (Paperback)

~ (Author), (Author)
Key Phrases: snapshot fact table, warehouse bus matrix, accumulating snapshot, Store Key, Account Key, Organization Key (more...)
4.5 out of 5 stars  See all reviews (31 customer reviews)

List Price: $60.00
Price: $49.98 & this item ships for FREE with Super Saver Shipping. Details
You Save: $10.02 (17%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Upgrade this book for $12.00 more, and you can read, search, and annotate every page online. See details
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Tuesday, November 10? Choose One-Day Shipping at checkout. Details
38 new from $35.89 20 used from $27.80

Formats

Amazon Price New from Used from
  Kindle Edition, April 26, 2002 $39.98 -- --
  Paperback, April 25, 2002 $49.98 $35.89 $27.80

Frequently Bought Together

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition) + The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin + The Data Warehouse Lifecycle Toolkit
Price For All Three: $121.95

Show availability and shipping details

  • This item: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition) by Ralph Kimball

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin by Ralph Kimball

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • The Data Warehouse Lifecycle Toolkit by Ralph Kimball

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought

The Data Warehouse Lifecycle Toolkit

The Data Warehouse Lifecycle Toolkit

by Ralph Kimball
4.4 out of 5 stars (56)  $44.47
The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset

The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset

by Joy Mundy
4.4 out of 5 stars (21)  $42.50
Building the Data Warehouse

Building the Data Warehouse

by W. H. Inmon
3.3 out of 5 stars (24)  $34.13
Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance

Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance

by Christopher Adamson
4.7 out of 5 stars (6)  $48.47
The Data Model Resource Book, Vol. 3: Universal Patterns for Data Modeling

The Data Model Resource Book, Vol. 3: Universal Patterns for Data Modeling

by Len Silverston
5.0 out of 5 stars (10)  $43.87
Explore similar items

Editorial Reviews

Review

"...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)


Product Description

Single most authoritative guide from the inventor of the technique.
* Presents unique modeling techniques for e-commerce, and shows strategies for optimizing performance.
* Companion Web site provides updates on dimensional modeling techniques, links related to sites, and source code where appropriate.

Product Details

  • Paperback: 464 pages
  • Publisher: Wiley; 2 edition (April 26, 2002)
  • Language: English
  • ISBN-10: 0471200247
  • ISBN-13: 978-0471200246
  • Product Dimensions: 9.2 x 7.2 x 1 inches
  • Shipping Weight: 1.5 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (31 customer reviews)
  • Amazon.com Sales Rank: #13,432 in Books (See Bestsellers in Books)

    Popular in these categories: (What's this?)

    #1 in  Books > Computers & Internet > Databases > Data Warehousing
    #3 in  Books > Computers & Internet > Graphic Design > 3D Graphics
    #5 in  Books > Computers & Internet > Databases > Database Design

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Inside This Book (learn more)




What Do Customers Ultimately Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(4)

Your tags: Add your first tag
 

 

Customer Reviews

31 Reviews
5 star:
 (22)
4 star:
 (6)
3 star:
 (1)
2 star:    (0)
1 star:
 (2)
 
 
 
 
 
Average Customer Review
4.5 out of 5 stars (31 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
93 of 97 people found the following review helpful:
5.0 out of 5 stars Practical Wisdom, May 5, 2002
By Jim Stagnitto (New Hope, PA USA) - See all my reviews
(REAL NAME)   
There are a lot of data warehousing books out there that try to answer the question: 'Why'? Why data warehouses are needed to help businesses make better decisions - why the OLTP systems that run the business can't do this - and sometimes even why businesses ought to invest in data warehouses. These books were terrifically useful to us years ago, when we needed help (and scholarly footnotes) in our data warehouse project proposals. This book is not one of those - it is all about:

How

How to actually design and build a repository that will deliver real value to real people. In this reviewer's opinion, Ralph Kimball's many contributions related to the 'how' of data warehousing stand alone.

An engineer wishing to jump-start his or her data warehouse education would need to read Ralph's Data Warehouse Toolkit first edition, his Data Webhouse Toolkit... a bunch of "Data Warehouse Designer" Intelligence Enterprise magazine articles... AND lurk on the Data Warehousing List Server...for a few years (all terrific resources - by the way) - in order to stockpile the knowledge that is crisply presented here.

No shortcuts taken by the authors that I can spot: all of the toughest dimensional design issues that I've tripped on - and that I can remember surfacing on in discussion groups over the past few years - are addressed in this significantly updated text. Not all of the solutions are 'pretty' - but it is clear that they thoughtfully address the problem. This approach, in my opinion, instills student confidence - and lets us know that we are getting sound instruction - not dogma.

The authors have been listening to and addressing the data warehouse community's 'pain' through periodicals and posts for years - but this book pulls these point solutions together very nicely. I learned a surprising number of really useful new techniques, and was genuinely enlightened by the 'Present Imperatives and Future Outlook' section.

As in the first edition, there is minimal philosophical lecturing, and zero religion. Instead, we get generous helpings of real-world case studies - aptly applied to progressively more advanced series of design concepts.

This style absolutely works for me. And I suspect that engineering mindsets typical of the folks that build these things will likely agree. In short, the Data Warehouse Toolkit Second Edition will significantly lighten the load of books that I carry between data warehouse engagements.

Jim Stagnitto
Llumino, Inc.
www.llumino.com
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
34 of 36 people found the following review helpful:
5.0 out of 5 stars Top-notch course in dimensional data warehouses, August 27, 2002
By A Customer
If you want to understand data warehouse design either as user, architect or developer, you need to read this book cover to cover.

Things I like about this book:

* Coverage of all core principles in dimensional data modeling using examples. Ralph does not just lecture to you -- he shows you how to put it into practice

* Coverage of a vast variety of domains. This alone makes the book a must-read

* Recap of major principles at the end of the book to bring it all together

* Excellent writing -- Ralph does not treat you like a dummy; neither does he assume that you have an IQ north of 200

* When you purchase this book, you are in effect purchasing a sliver of the combined knowledge of both authors in the data warehousing field. Highly recommended

I implemented a data warehouse using some of these principles back in 1999. The project was a resounding success and is the most popular application in the financial services firm that I implemented it in. (Infact when I lost my job at an Internet company, they immediately offered me a job based on this implementation). The only sad part to the whole story is that we made a few mistakes in implementation that are now very difficult to correct because the data warehouse has become core to the business -- we have too many end-user applications riding on it!

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
30 of 33 people found the following review helpful:
5.0 out of 5 stars Data Warehousing is in the eye of the beholder, June 6, 2003
By Srihari Mailvaganam (Vancouver, British Columbia Canada) - See all my reviews
(REAL NAME)   
Data Warehousing is more of an art than a science - but then again what isn't?

There isn't a standard blueprint that can come close to solving most data issues. Data Warehousing (DW) involves constant tweaking and the goal of good DW project management is minimizing the associated operational cost.

I have been a fan of Ralph Kimball as he writes as a person who has been through many implementations. With Mr. Kimball there isn't a miracle cure being touted - stay away from publications that claim such a cure.

Mr. Kimball approached the subject with good advices and encourages the readers to watch out for the pitfalls and follow best-practices in design implementation. It is similar to working with a well experienced supervisor.

The core to successful DW implementations is - LISTENING. Listening to the users on their needs and gauging the software resources available at your disposal.

Trade-offs in design versus cost/performance are a must. You will never have all the resources you need to implement the DW of your dreams. And if you did, chances are very high that once the DW is ready for use the business cases have changed making the design redundant.

Mr. Kimball will help in passing these information and much more. It also goes in good technical detail for suggested modeling of data.

I hope this review is helpful, please let me know if you have any questions or suggestions.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

4.0 out of 5 stars Answers the question - how should I set up the schema?
There are many aspects to setting up a data warehouse and I have not found a book which adequately covers enough of the bases to think that it gives enough information that I... Read more
Published 2 months ago by F. Hu

5.0 out of 5 stars One of the best IT books I've ever read...
...I'll be short after so many comments. What I like especially about this book:

- The business/industry based approach which leads quite naturally to different... Read more
Published 5 months ago by Lukas

4.0 out of 5 stars Now I understand data warehouses
This book is a great primer on data warehouses: what they are for, how data should be organized in the warehouse, and what you can do with it. Read more
Published 8 months ago by J. Peterson

5.0 out of 5 stars a must read
I love this book. I read every page and enjoyed each one of them. If you are into DWing and BI, I highly recommend this book.

Ash Sehgal
Published 8 months ago by Ashwani Sehgal

5.0 out of 5 stars Good exposure to dimensional data modeling
A great book for exposure to dimensional data modeling, easy and relatively a fast read. Sometimes takes a somewhat idealistic simpler view as compared to a real system that... Read more
Published 9 months ago by Russell D. Ebbing

5.0 out of 5 stars A must have for any data warehouse architect
This is an excellent book and a must have for any serious data warehouse architect. I use it extensively as a reference and also recommend it to my clients trying to learn data... Read more
Published 12 months ago by ihafidh

5.0 out of 5 stars One of the best technical books ever
I found this to be one of the best technical books written - ever. When the authors demanded my full attention by advising in the Intro section that the book has to be read from... Read more
Published 16 months ago by Ramkumar Krishnan

5.0 out of 5 stars Excellent blend of technical and business concepts
There are at least 3 excellent books from the Kimball Group in their data warehouse toolkit series. This one, "The Complete Guide to Dimensional Modeling", is extremely... Read more
Published 18 months ago by Dennis M. Clark

4.0 out of 5 stars Good for Dimentional Modeling
I did not get chance to read it, but everybody says it the best source to learn Dimensional Modeling. I our project, the DBA is doing it.
Published on October 4, 2007 by C. Nirmal

5.0 out of 5 stars A tool rather than a toolkit
This book delivers exactly what it says. Except that word "toolkit" in its title - you'd better think about this book being a single tool, not a whole toolkit. Read more
Published on July 2, 2007 by Dmitry Dvoinikov

Only search this product's reviews



Customer Discussions

This product's forum
See all 2 discussions...  
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
   



So You'd Like to...


Create a guide

Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Look for Similar Items by Subject

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.