The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

5.0 1
by Ralph Kimball, Margy Ross
     
 

View All Available Formats & Editions

The most authoritative and comprehensive guide to dimensional modeling, from its originators—fully updated

Ralph Kimball introduced the industry to the techniques of dimensional modeling in the first edition of The Data Warehouse Toolkit (1996). Since then, dimensional modeling has become the most widely accepted approach for presenting

See more details below

Overview

The most authoritative and comprehensive guide to dimensional modeling, from its originators—fully updated

Ralph Kimball introduced the industry to the techniques of dimensional modeling in the first edition of The Data Warehouse Toolkit (1996). Since then, dimensional modeling has become the most widely accepted approach for presenting information in data warehouse and business intelligence (DW/BI) systems. The Data Warehouse Toolkit is recognized as the definitive source for dimensional modeling techniques, patterns, and best practices.

This third edition of the classic reference delivers the most comprehensive library of dimensional modeling techniques ever assembled. Fully updated with fresh insights and best practices, this book provides clear guidelines for designing dimensional models—and does so in a style that serves the needs of those new to data warehousing as well as experienced professionals.

All the techniques in the book are illustrated with real-world case studies based on the authors' actual DW/BI design experiences. In addition, the Kimball Group's "official" list of dimensional modeling techniques is summarized in a single chapter for easy reference, with pointers from each technique to the case studies where the concepts are brought to life.

The third edition of The Data Warehouse Toolkit covers:

  • Practical design techniques—both basic and advanced—for dimension and fact tables
  • 14 case studies, including retail sales, electronic commerce, customer relationship management, procurement, inventory, order management, accounting, human resources, financial services, healthcare, insurance, education, telecommunications, and transportation
  • Sample data warehouse bus matrices for 12 case studies
  • Dimensional modeling pitfalls and mistakes to avoid
  • Enhanced slowly changing dimension techniques type 0 through 7
  • Bridge tables for ragged variable depth hierarchies and multivalued attributes
  • Best practices for Big Data analytics
  • Guidelines for collaborative, interactive design sessions with business stakeholders
  • An overview of the Kimball DW/BI project lifecycle methodology
  • Comprehensive review of extract, transformation, and load (ETL) systems and design considerations
  • The 34 ETL subsystems and techniques to populate dimension and fact tables

Read More

Editorial Reviews

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, OR

Product Details

ISBN-13:
9781118530801
Publisher:
Wiley
Publication date:
07/01/2013
Pages:
600
Sales rank:
251,669
Product dimensions:
7.40(w) x 9.20(h) x 0.70(d)

Related Subjects

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >