The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence - Softcover

Kimball, Ralph; Ross, Margy; Mundy, Joy

Softcover

ISBN 10: 0470563109 ISBN 13: 9780470563106

Publisher: John Wiley & Sons Inc, 2010

Synopsis

An unparalleled collection of recommended guidelines for data warehousing and business intelligence pioneered by Ralph Kimball and his team of colleagues from the Kimball Group.

Recognized and respected throughout the world as the most influential leaders in the data warehousing industry, Ralph Kimball and the Kimball Group have written articles covering more than 250 topics that define the field of data warehousing. For the first time, the Kimball Group's incomparable advice, design tips, and best practices have been gathered in this remarkable collection of articles, which spans a decade of data warehousing innovation.

Each group of articles is introduced with original commentaries that explain their role in the overall lifecycle methodology developed by the Kimball Group. These practical, hands-on articles are fully updated to reflect current practices and terminology and cover the complete lifecycle—including project planning, requirements gathering, dimensional modeling, ETL, and business intelligence and analytics.

This easily referenced collection is nothing less than vital if you are involved with data warehousing or business intelligence in any capacity.

About this title

About the Author

Ralph Kimball, PhD, is the Founder of the Kimball Group and a leading visionary in the data warehouse industry.

Margy Ross is President of the Kimball Group and has focused exclusively on DW/BI solutions since 1982.

From the Back Cover

A collection of the most authoritative, detailed, and practical guidelines for data warehousing and business intelligence

Over the past 15 years, Ralph Kimball and his unparalleled team of colleagues have written articles covering more than 250 topics that have come to define the field of data warehousing (DW). The Kimball Group Reader presents the best of these articles, fully updated to reflect their current thinking and practices. Covering the complete lifecycle including project planning, requirements gathering, dimensional modeling, ETL, and business intelligence (BI) and analytics the authors provide detailed, technical guidance that expands beyond the Toolkit essentials to provide fresh insights and best practices.

The Reader begins with a group of articles that established the core insights and principles of data warehousing. The content that follows provides detailed guidance for every step of the data warehouse lifecycle, with in-depth, practical guidance that you can leverage for your own projects. After covering project planning and business requirements, the authors take a dive into all things dimensional. There are more than 100 articles on dimensional modeling alone. These articles have been fully revised, updated, and expanded where needed to reflect current best practices established by the Kimball Group.

With incomparable articles providing critical advice for successfully designing, deploying, and maintaining the DW/BI system, The Kimball Group Reader covers:

• Dos and Don'ts for gathering requirements

• The Kimball enterprise data warehouse architecture and matrix

• Dimensional modeling tasks and responsibilities

• Fact table and dimension table core concepts

• Data stewardship for conforming dimensions

• Granularity and three fundamental types of fact tables

• Snowflakes and outriggers

• Bridges for handling multi-valued dimension attributes and ragged variable hierarchies

• Nuances encountered in customer dimensions and internationalization issues

• Slowly changing dimensions and hybrid variations

• Subsystems to extract, transform, and load (ETL) data

• Pros and cons of using a commercial ETL tool

• Server-oriented architecture, master data management, and packaged analytics

• Front-room BI applications and data mining

• Techniques for assessing a mature DW/BW environment and getting it back on track

Edition details

• Publisher: John Wiley & Sons Inc
• Publication date: 2010
• Language: English
• ISBN 10: 0470563109
• ISBN 13: 9780470563106
• Binding: Paperback
• Edition number: 1
• Number of pages: 718