Anonymous
Posted Mon Apr 09 00:00:00 EDT 2012
R u on
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.This is an excellent and wonderful book and it contains the details at data warehouse architect level. I use it extensively as a reference and also recommend to my juniors who like to learn data warehousing and techniques. The first three chapters are covers at very basic level. The remaining chapters cover more in depth, which covers details of dimensional modelling.
This book covers dimensional modelling for different industries under different discipline. So readers may find difficult to understand if they are not familiar with that industry. This is a good eye opener for those who want to know the dimensional modelling for the specific industry. Also, doing a project for a particular industry will help immensely in understanding the more detailed aspects of some chapters and hence fully understand the concepts.
More About This Textbook
Overview
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)
Editorial Reviews
From Barnes & Noble
Two acclaimed data warehouse experts share an unmatched library of techniques -- both basic and advanced -- for designing fast, versatile, accessible dimensional databases. They also illustrate their methods at work in e-commerce, financial services, telecommunications, transportation, education, health care, and other industries.From the Publisher
"...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 Critics
Utilizing case studies from a variety of business applications, the authors present dimensional modeling techniques for data warehousing. Emphasizing user understandability and query performance, chapters cover techniques in the areas of retail sales , inventory, procurement, order management, customer relationship management, accounting, human resource management, financial services, telecommunications and utilities, transportation, education, health care, electronic commerce, and insurance. Final chapters discuss the construction of the data warehouse framework and future trends. Annotation c. Book News, Inc., Portland, ORProduct Details
Related Subjects
Meet the Author
RALPH KIMBALL, PhD, has been a leading visionary in the data warehouse industry since 1982 and is one of today's most well- known speakers, consultants, and teachers. He writes the "Data Warehouse Designer" column for Intelligent Enterprise magazine and is also the author of the bestselling books The Data Warehouse Lifecycle Toolkit and The Data Webhouse Toolkit (both from Wiley).
MARGY ROSS is President of DecisionWorks Consulting and a Ralph Kimball Associate. She has focused exclusively on decision support and data warehousing since 1982. Margy coauthored the highly acclaimed The Data Warehouse Lifecycle Toolkit, consults on data warehouse projects worldwide, and teaches data warehouse design for Kimball University.
Table of Contents
Introduction to the Book.
Dimensional Modeling Primer.
Retail Sales.
Inventory.
Procurement.
Order Management.
Customer Relationship Management.
Accounting.
Human Resources Management.
Financial Services.
Telecommunications and Utilities.
Transportation.
Education.
Health Care.
Electronic Commerce.
Insurance.
Building the Data Warehouse.
Present Imperatives and Future Outlook.
Glossary.
Index.