The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling | 
 enlarge | Authors: Ralph Kimball, Margy Ross
Publisher: John Wiley & Sons
Category: Book
List Price: £35.99
Buy New: £20.76
You Save: £15.23 (42%)
New (43) Used (6) from £20.76
Avg. Customer Rating:  7 reviews
Sales Rank: 33845
Media: Paperback
Edition: 2nd Edition
Number Of Items: 1
Pages: 464
Shipping Weight (lbs): 1.5
Dimensions (in): 9.2 x 7.2 x 1
ISBN: 0471200247
Dewey Decimal Number: 658.40380285574
EAN: 9780471200246
ASIN: 0471200247
Publication Date: April 25, 2002
Availability: Usually dispatched within 1-2 business days
|
| Similar Items:
|
| Customer Reviews: Read 2 more reviews...
The best book on Data Warehousing. Full Stop. September 4, 2008
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.
Ironically, an alternative book The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, is suitable if either you're an ETL developer or simply want a good overview of the techniques. Also co-authored by Ralph Kimball, it provides a succinct overview of Dimensional Design along with a description of the thorny issue of ETL.
A good book November 6, 2007
1. I recommend this book for a beginner and advanced users for clear understanding on dimensional modelling.
2. I am happy to say, I received a replacement book since my first order was not delivered to me.
The Bible for starting a Data Warehouse project September 22, 2007
1 out of 1 found this review helpful
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.
A must have December 4, 2006
3 out of 3 found this review helpful
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!!
Excellent book March 7, 2006
2 out of 3 found this review helpful
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.
|
|
|
