Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.
The Data Warehouse Toolkit and over 300,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.
 
 
More Buying Choices
62 used & new from $25.00

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 yours here.
 
  

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

by Ralph Kimball (Author), Margy Ross (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: $52.17 & this item ships for FREE with Super Saver Shipping. Details
You Save: $7.83 (13%)
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 Thursday, July 16? Choose One-Day Shipping at checkout. Details
32 new from $39.78 30 used from $25.00
Also Available in: List Price: Our Price: Other Offers:
Kindle Edition (Kindle Book) $46.95

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: $136.37

Show availability and shipping details


Customers Who Bought This Item Also Bought

The Data Warehouse Lifecycle Toolkit

The Data Warehouse Lifecycle Toolkit

by Ralph Kimball
4.2 out of 5 stars (6)  $44.35
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)  $43.59
The Data Warehouse Lifecycle Toolkit : Expert Methods for Designing, Developing, and Deploying Data Warehouses

The Data Warehouse Lifecycle Toolkit : Expert Methods for Designing, Developing, and Deploying Data Warehouses

by Ralph Kimball
4.4 out of 5 stars (49)  $56.70
Building the Data Warehouse

Building the Data Warehouse

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

Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance

by Christopher Adamson
4.8 out of 5 stars (5)  $47.84
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.

See all Editorial Reviews

Product Details


Inside This Book (learn more)



Books on Related Topics (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.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.
(4)
(1)

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

 

Customer Reviews

31 Reviews
5 star:
 (23)
4 star:
 (5)
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

 
91 of 95 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)



 
32 of 34 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

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 1 month 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 4 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 4 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 5 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 8 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 12 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 14 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 21 months ago 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

4.0 out of 5 stars Building a Data Warehouse
Excelent book, it shows how to build a good data warehouse by using the best patterns. I recommend the book to you, it is not as boring as another books regarding this issue, in... Read more
Published on March 8, 2007 by Gonzalo Tachack

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (2 discussions)
  Discussion Replies Latest Post
questions on screens and audit dimension 0 November 2008
How do you define your Business Key Performance Indicators? 0 August 2008
See all 2 discussions...  
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   


Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Storm Warning

Black & Decker Storm Station
Buy the Black & Decker Storm Station--an all-in-one emergency power source, radio, and flashlight--for the unbelievably low price of $119.99.

Shop the Power Tools Store

 

Big Savings in Books

Bargain Books
Find great titles at fantastic prices in our Bargain Books Store.
 

Buy Three Books, Get a Fourth Free

4-for-3 Books
Order any four eligible books under $10 and get the lowest-price book free in our 4-for-3 Books Store. See more details.
 

Introducing Subscribe & Save

Get automatic reorders plus extra savings on items you use frequently, including coffee, shampoo, and laundry detergent, with our new Subscribe & Save program.

More about Subscribe & Save

 

 

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.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

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

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Paranoia
Paranoia by Joseph Finder
My Soul to Lose
My Soul to Lose by Rachel Vincent
Glenn Beck's Common Sense
Glenn Beck's Common Sense

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates