The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Computer Science) Paperback – 25 Apr 2002
There is a newer edition of this item:
Customers Who Bought This Item Also Bought
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
"...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
∗ Order management
∗ Customer relationship management (CRM)
∗ Human resources management
∗ Financial services
∗ Telecommunications and utilities
∗ 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
What Other Items Do Customers Buy After Viewing This Item?
Top Customer Reviews
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.
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).
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 ›
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 ›
1. It is a well thought out, thorough but easy to read book
2. The book builds on each preceding chapter
Most Recent Customer Reviews
I read a review claiming this to be "the daddy" and I see why!
As a relative newbie to MI at this level, the book does the job well and was recommended to me by... Read more
Fantastic down to earth explanations with real business situations.
Worth buying if you are a starter in the DW technology.
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.
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 morePublished on 18 July 2010 by S. Dietz
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
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 morePublished on 24 July 2009 by M. Sear
Look for similar items by category
- Books > Business, Finance & Law > Management > Human Resources > Professional Development
- Books > Business, Finance & Law > Management > Information Management
- Books > Computing & Internet > Databases > Data Storage & Management > Data Warehousing
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Hardware
- Books > Computing & Internet > Networking & Security > Network Topics
- Books > Computing & Internet > Programming > Graphics & Multimedia
- Books > Computing & Internet > Software & Graphics > Graphics & Multimedia > 3-D Graphics