The Data Warehouse Toolkit and over 2 million other books are available for Amazon Kindle . Learn more

Buy New

or
Sign in to turn on 1-Click ordering.
Buy Used
Used - Good See details
Price: £5.61

or
 
   
Trade in Yours
For a £0.63 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading The Data Warehouse Toolkit on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Computer Science) [Paperback]

Ralph Kimball , Margy Ross
4.7 out of 5 stars  See all reviews (14 customer reviews)
RRP: £45.00
Price: £43.74 & FREE Delivery in the UK. Details
You Save: £1.26 (3%)
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
Only 4 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 24 Sep.? Choose Express delivery at checkout. Details

Formats

Amazon Price New from Used from
Kindle Edition £41.55  
Paperback £43.74  
Trade In this Item for up to £0.63
Trade in The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Computer Science) for an Amazon Gift Card of up to £0.63, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
There is a newer edition of this item:
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling 4.0 out of 5 stars (7)
£24.43
In stock.

Book Description

25 April 2002 0471200247 978-0471200246 2nd Edition
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)

Frequently Bought Together

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Computer Science) + The Data Warehouse Lifecycle Toolkit + Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema
Price For All Three: £91.64

Buy the selected items together


Product details

  • Paperback: 464 pages
  • Publisher: John Wiley & Sons; 2nd Edition edition (25 April 2002)
  • Language: English
  • ISBN-10: 0471200247
  • ISBN-13: 978-0471200246
  • Product Dimensions: 2.5 x 19.2 x 22.7 cm
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (14 customer reviews)
  • Amazon Bestsellers Rank: 213,996 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

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)

From the Back Cover

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. Wiley Computer Publishing. Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/ Visit Kimball′s Web site at www.kimballuniversity.com

Inside This Book (Learn More)
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:


Customer Reviews

4.7 out of 5 stars
4.7 out of 5 stars
Most Helpful Customer Reviews
15 of 15 people found the following review helpful
5.0 out of 5 stars Required reading for any DW professional ! 24 July 2003
Format:Paperback
Dimensional modelling is the key to designing conformed dimension data warehouses.
This authoritative book covers dimensional modelling in great depth, but at the same time is very accessible. You will want it by your side to reference its examples of how to cope with various scenarios.
ps The companion volume, the DW Life Cycle Toolkit by Kimball & Ross, covers higher level aspects of data warehousing, and is just as good.
Comment | 
Was this review helpful to you?
5 of 5 people found the following review helpful
5.0 out of 5 stars The best book on Data Warehousing. Full Stop. 4 Sep 2008
By John Ryan HALL OF FAME TOP 10 REVIEWER
Format:Paperback
I bought the First Edition of this book over ten years ago, and it helped demystify some of my preconceptions about Data Warehousing. I since buillt upon my experience, along with several highly successful, highly performant warehouse solutions in the Telecoms, Public Services and Banking industries.

In summary - this book works.

One of it's greatest strengths is that it is readable, and easily understood - despite the Initially unusual design techniques. Anyone with database design experience should have no problem following the concepts.

After an initial chapter on the "basics dimensional design" it then explores the subject chapter by chapter using "case studies". You're bound to find one industry you're familiar with, the subjects include Retail Sales, Inventory, Order Processing, HR and Financial Services.

Each case study, explores the fundamentals in further detail, and introduces an additional concept for which a solution is provided.

It's far from a "cook-book" approach, but both myself and colleagues (I've kept in touch with two other people who swear by Ralph Kimball and the toolkit), have relied upon it for solutions through the years.

Take for example, the problem of modling a complex hierarchy of business units which can (in theory) have any number of levels, but users want to analyse data for "Ultimate Parent Companies" or for all the subsidiaries of a given company. Ralph has a solution.

In summary, if you're working in the Business Intelligence industry, as a designer, architect or even an intested project manager - you should understand Dimensional Design techniques, and this is the book the explain them.
Read more ›
Comment | 
Was this review helpful to you?
11 of 12 people found the following review helpful
By A Customer
Format:Paperback
Excellent ground up introduction to dimensional modelling. If you think you need this book, then this is most certainly the book to get you started and take you well into the subject.
Ralph Kimball wrote the first edition of this book. This edition has been updated by another author and includes (for example sections on finance, health and education).
Will not disappoint. We used this book as a management communication vehicle (we gave them copies and that saved a LOT of repeated and dumb questions). Minor issue, - not enough mauve in the book.
Recommended if you want to get into marts, warehouses and a series of career opportunities. I also recommend the series (they look very similar to this cover).
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
5.0 out of 5 stars Kimball Wizard 25 July 2010
Format:Paperback
Before you read this book, read the confusingly similarly titled "The Data Warehouse Lifecycle Toolkit". Then marvel at one man's obsession for writing so many different books with near identical titles and cover illustrations.

However what Kimball lacks in imagination for his dust-jackets, he makes up for with his unparalleled knowledge of dimensional modelling.

Every chapter in this book illustrates the practical application of the principles of dimensional modelling to a different business process or industry - getting more and more complex the further in you read.

If you are going to be responsible for solving the problems of dimensionally modelling a business, then this book is going to save you months of scratching your head and wondering "How am I going to....."

This book has so much important information in it that I read it not once but twice whilst I was laying by a pool on holiday in Spain. Other people were reading things like Andy McNab and John Grisham.

There isn't too much in the way of covert military operations, international espionage, or court room dramas in this book - perhaps Dr Kimball could look into that when he writes his next book. Perhaps additionally when he writes his next book, his publisher could tell him that there is no law which says that books have to have the words "Data Warehouse" or "Toolkit" in them.

Look at Andy McNab. "Bravo Two-Zero". Not "The Bravo Two-Zero Data Warehouse Toolkit".
Look at John Grisham. "The Firm". Not "The Data Warehouse Firm Toolkit".
Read more ›
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
5.0 out of 5 stars A must have 4 Dec 2006
By PSB1
Format:Paperback|Verified Purchase
I picked this up about 18 months ago as a primer, and it's still helping me today as I continue to develop new datawarehouse designs. Each time I have to do something for the first time, there's usually a chapter in the book for it. I feel a lot more comfortable having it on my desk!!
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
5.0 out of 5 stars The Bible for starting a Data Warehouse project 22 Sep 2007
Format:Paperback|Verified Purchase
Our organisation was establishing a BI competence centre. This book along with the others in the series offered all the guidance needed to make sense of the terminology - and more importantly gave real-life worked examples rather than just theory. We bought it for everyone on the team.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Most Recent Customer Reviews
5.0 out of 5 stars Excellent Buy
Fantastic down to earth explanations with real business situations.
Worth buying if you are a starter in the DW technology.
Published 17 months ago by Priyangshu
3.0 out of 5 stars It's OK
Dislikes: Long book, can't it get to the point a lot quicker? Maybe it can if it tried. Examples are boaring. Not enough exercises.

Likes: Comprehensive coverage.
Published 21 months ago by Libs
5.0 out of 5 stars Kimball is the definitive source for DW/BI
If you are looking for clarity as to how to approach particular dimensional data models for specific usage, this book has plenty of examples and discussion. Read more
Published on 18 July 2010 by S. Dietz
5.0 out of 5 stars Spot on
This book does what it says on the tin. It's clear and easy to follow with good examples.
Published on 19 Jun 2010 by David Raison
4.0 out of 5 stars Good but not perfect
In the perfect world this would be a great book. But the world isn't perfect. As such I find the tone all a little condescending in places. Read more
Published on 24 July 2009 by M. Sear
5.0 out of 5 stars Good grounding
I found this to be one of the best written IT books I have come across.
A potentially complex subject is covered with clarity of thought and simplicity of expression. Read more
Published on 16 Dec 2008 by Andrew M
5.0 out of 5 stars A good book
1. I recommend this book for a beginner and advanced users for clear understanding on dimensional modelling.
2. Read more
Published on 6 Nov 2007 by Var
5.0 out of 5 stars Excellent book
I found this book extrememly useful. I do not come from a database background, I'm more of an analyst but the concepts were well explained and it all made sense.
Published on 6 Mar 2006 by Ian Peter Avery
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback