The Data Warehouse Toolkit

Updated new edition of Ralph Kimball's groundbreaking book on
dimensional modeling for data warehousing and business
intelligence!

The first edition of Ralph Kimball's The Data Warehouse
Toolkit introduced the industry to dimensional modeling,
and now his books are considered the most authoritative guides in
this space. This new third edition is a complete library of updated
dimensional modeling techniques, the most comprehensive collection
ever. It covers new and enhanced star schema dimensional modeling
patterns, adds two new chapters on ETL techniques, includes new and
expanded business matrices for 12 case studies, and more.

• Authored by Ralph Kimball and Margy Ross, known worldwide as
  educators, consultants, and influential thought leaders in data
  warehousing and business intelligence

• Begins with fundamental design recommendations and progresses
  through increasingly complex scenarios

• Presents unique modeling techniques for business applications
  such as inventory management, procurement, invoicing, accounting,
  customer relationship management, big data analytics, and more

• Draws real-world case studies from a variety of industries,
  including retail sales, financial services, telecommunications,
  education, health care, insurance, e-commerce, and more

Design dimensional databases that are easy to understand and
provide fast query response with The Data Warehouse
Toolkit: The Definitive Guide to Dimensional Modeling, 3rd
Edition.

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.

Zusammenfassung

Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence!

The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more.

• Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence
• Begins with fundamental design recommendations and progresses through increasingly complex scenarios
• Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more
• Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and more
  Design dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.

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 123

Conformed Dimensions 130

Conformed Facts 138

Summary 139

5 Procurement 141

Procurement Case Study 141

Procurement Transactions and Bus Matrix 142

Slowly Changing Dimension Basics 147

Hybrid Slowly Changing Dimension Techniques 159

Slowly Changing Dimension Recap 164

Summary 165

6 Order Management 167

Order Management Bus Matrix 168

Order Transactions 168

Invoice Transactions 187

Accumulating Snapshot for Order Fulfillment Pipeline 194

Summary 199

7 Accounting 201

Accounting Case Study and Bus Matrix 202

General Ledger Data 203

Budgeting Process 210

Dimension Attribute Hierarchies 214

Consolidated Fact Tables 224

Role of OLAP and Packaged Analytic Solutions 226

Summary 227

8 Customer Relationship Management 229

CRM Overview 230

Customer Dimension Attributes 233

Bridge Tables for Multivalued Dimensions 245

Complex Customer Behavior 249

Customer Data Integration Approaches 256

Low Latency Reality Check 260

Summary 261

9 Human Resources Management 263

Employee Profile Tracking 263

Headcount Periodic Snapshot 267

Bus Matrix for HR Processes 268

Packaged Analytic Solutions and Data Models 270

Recursive Employee Hierarchies 271

Multivalued Skill Keyword Attributes 274

Survey Questionnaire Data 277

Summary 279

10 Financial Services 281

Banking Case Study and Bus Matrix 282

Dimension Triage to Avoid Too Few Dimensions 283

Supertype and Subtype Schemas for Heterogeneous Products 293

Hot Swappable Dimensions 296

Summary 296

11 Telecommunications 297

Telecommunications Case Study and Bus Matrix 297

General Design Review Considerations 299

Design Review Guidelines 304

Draft Design Exercise Discussion 306

Remodeling Existing Data Structures 309 Geographic ...