Start reading The Data Warehouse Toolkit on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Colour:
Image not available
 

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling [Kindle Edition]

Ralph Kimball , Margy Ross
4.8 out of 5 stars  See all reviews (17 customer reviews)

Kindle Price: £43.20 includes VAT* & free wireless delivery via Amazon Whispernet
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £43.20  
Paperback £45.00  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book Description

The latest edition of the single most authoritative guide ondimensional modeling for data warehousing!

Dimensional modeling has become the most widely acceptedapproach for data warehouse design. Here is a complete library ofdimensional modeling techniques-- the most comprehensive collectionever written. Greatly expanded to cover both basic and advancedtechniques for optimizing data warehouse design, this secondedition to Ralph Kimball's classic guide is more than sixty percentupdated.

The authors begin with fundamental design recommendations andgradually progress step-by-step through increasingly complexscenarios. Clear-cut guidelines for designing dimensional modelsare illustrated using real-world data warehouse case studies drawnfrom 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 ofpowerful techniques for designing dimensional databases that areeasy to understand and provide fast query response. You will alsolearn how to create an architected framework that integrates thedistributed data warehouse using standardized dimensions andfacts.

This book is also available as part of the Kimball's DataWarehouse Toolkit Classics Box Set (ISBN: 9780470479575) with thefollowing 3 books:

The Data Warehouse Toolkit, 2nd Edition (9780471200246)

The Data Warehouse Lifecycle Toolkit, 2nd Edition(9780470149775)

The Data Warehouse ETL Toolkit (9780764567575)



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

Product details

  • Format: Kindle Edition
  • File Size: 7841 KB
  • Print Length: 464 pages
  • Publisher: Wiley; 2 edition (21 April 2008)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ISBN-10: 0471200247
  • ISBN-13: 978-0471200246
  • ASIN: B006BBLM0Y
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (17 customer reviews)
  • Amazon Bestsellers Rank: #325,543 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Authors

Discover books, learn about writers, and more.


Customer Reviews

4.8 out of 5 stars
4.8 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 Sept. 2008
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?
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?
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 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 Sept. 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 Five Stars
Every thing went swell.
Published 18 days ago by Henrique Pires
5.0 out of 5 stars Must have for anyone building dimensional data marts
Ralph Kimball is known as the father of dimensional modelling for a reason. This is one of the IT books you have to read cover to cover for two reasons.
1. Read more
Published 1 month ago by Mr. David J. Poole
5.0 out of 5 stars Five Stars
Surprisingly readable for a technical book
Published 6 months ago by C. King-cherne
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 on 3 April 2013 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 on 13 Dec. 2012 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
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