This revised and updated edition of the bestseller provides a complete library of dimensional modeling techniques, the most comprehensive collection ever written.

Informationen zum Autor RALPH KIMBALL , PhD, has been a leading visionary in the data warehouse and business intelligence industry since 1982. The Data Warehouse Toolkit book series have been bestsellers since 1996. MARGY ROSS is President of the Kimball Group and the coauthor of five Toolkit books with Ralph Kimball. She has focused exclusively on data warehousing and business intelligence for more than 30 years. Klappentext 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 Zusammenfassung This revised and updated edition of the bestseller provides a complete library of dimensional modeling techniques, the most comprehensive collection ever written. Inhaltsverzeichnis Introduction xxvii 1 Data Warehousing, Business Intelligence, and Dimensional Modeling Primer 1 Different Worlds of Data Capture and Data Analysis 2 Goals of Data Warehousing and Business Intelligence 3 Dimensional Modeling Introduction 7 Kimball's DW/BI Architecture 18 Alternative DW/BI Architectures 26 Dimensional Modeling Myths 30 More Reasons to Think Dimensionally 32 Agile Considerations 34 Summary 35 2 Kimball Dimensional Modeling Techniques Overview 37 Fundamental Concepts 37 Basic Fact Table Techniques 41 Basic Dimension Table Techniques 46 Integration via Conformed Dimensions 50 Dealing with Slowly Changing Dimension Attributes 53 Dealing with Dimension Hierarchies 56 Advanced Fact Table Techniques 58 Advanced Dimension Techniques 62 Special Purp...

Autorentext

RALPH KIMBALL, PhD, has been a leading visionary in the data warehouse and business intelligence industry since 1982. The Data Warehouse Toolkit book series have been bestsellers since 1996.

MARGY ROSS is President of the Kimball Group and the coauthor of five Toolkit books with Ralph Kimball. She has focused exclusively on data warehousing and business intelligence for more than 30 years.

Klappentext

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

  Inhalt

  Introduction xxvii

  1 Data Warehousing, Business Intelligence, and Dimensional Modeling Primer 1

  Different Worlds of Data Capture and Data Analysis 2

  Goals of Data Warehousing and Business Intelligence 3

  Dimensional Modeling Introduction 7

  Kimball's DW/BI Architecture 18

  Alternative DW/BI Architectures 26

  Dimensional Modeling Myths 30

  More Reasons to Think Dimensionally 32

  Agile Considerations 34

  Summary 35

  2 Kimball Dimensional Modeling Techniques Overview 37

  Fundamental Concepts 37

  Basic Fact Table Techniques 41

  Basic Dimension Table Techniques 46

  Integration via Conformed Dimensions 50

  Dealing with Slowly Changing Dimension Attributes 53

  Dealing with Dimension Hierarchies 56

  Advanced Fact Table Techniques 58

  Advanced Dimension Techniques 62

  Special Purpose Schemas 67

  3 Retail Sales 69

  Four-Step Dimensional Design Process 70

  Retail Case Study 72

  Dimension Table Details 79

  Retail Schema in Action 94

  Retail Schema Extensibility 95

  Factless Fact Tables 97

  Dimension and Fact Table Keys 98

  Resisting Normalization Urges 104

  Summary 109

  4 Inventory 111

  Value Chain Introduction 111

  Inventory Models 112

  Fact Table Types 119

  Value Chain Integration 122

  Enterprise Data Warehouse Bus Architecture …