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)
The Data Warehouse Toolkit
and over 1.5 million other books are available for Amazon Kindle . Learn more
| ||||||||||||||||||
 Trade In this Item for up to £8.13
Trade in The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling for an Amazon.co.uk gift card of up to £8.13, 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:
|
Book Description
Frequently Bought Together
Product details
Would you like to update product info or give feedback on images?
|
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)
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
15 of 15 people found the following review helpful
By Mike Casey
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.
5 of 5 people found the following review helpful
By John Ryan
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.
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.
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.
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).
Would you like to see more reviews about this item?
›
Go to Amazon.com to see all 51 reviews
4.4 out of 5 stars
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.
Worth buying if you are a starter in the DW technology.
Published 1 month 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.
Likes: Comprehensive coverage.
Published 5 months ago by Libs
5.0 out of 5 stars
Kimball Wizard
Before you read this book, read the confusingly similarly titled "The Data Warehouse Lifecycle Toolkit". Read more
Published on 25 July 2010 by Andy Hogg
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
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
2. Read more
Published on 6 Nov 2007 by Var
5.0 out of 5 stars
The Bible for starting a Data Warehouse project
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... Read more
Published on 22 Sep 2007 by Barry Ryan
5.0 out of 5 stars
A must have
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. Read more
Published on 4 Dec 2006 by PSB1
Customer Discussions
|
This product's forum
Search Customer Discussions
|
Related forums
|
Listmania!
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 > Programming > Graphics & Multimedia > 3D Programming
- Books > Computing & Internet > Software & Graphics > Graphics & Multimedia > 3-D Graphics
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
