| ||||||||||||||||||
 Trade In this Item for up to £12.10
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling for an Amazon.co.uk gift card of up to £12.10, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Authors
Discover books, learn about writers, and more.
Product Description
Review
Product Description
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)
Concordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
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.
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.
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).
A potentially complex subject is covered with clarity of thought and simplicity of expression. Read more
2. Read more
Listmania!
|
|
Look for similar items by category
- 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
Look for similar items by subject
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.
|
