The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition

Table of Contents

Introduction

Intended Audience

Chapter Preview

Website Resources

Summary

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

Different Worlds of Data Capture and Data Analysis

Goals of Data Warehousing and Business Intelligence

Dimensional Modeling Introduction

Kimball's DW/BI Architecture

Alternative DW/BI Architectures

Dimensional Modeling Myths

More Reasons to Think Dimensionally

Agile Considerations

Summary

Chapter 2: Kimball Dimensional Modeling Techniques Overview

Fundamental Concepts

Basic Fact Table Techniques

Basic Dimension Table Techniques

Integration via Conformed Dimensions

Dealing with Slowly Changing Dimension Attributes

Dealing with Dimension Hierarchies

Advanced Fact Table Techniques

Advanced Dimension Techniques

Special Purpose Schemas

Chapter 3: Retail Sales

Four-Step Dimensional Design Process

Retail Case Study

Dimension Table Details

Retail Schema in Action

Retail Schema Extensibility

Factless Fact Tables

Dimension and Fact Table Keys

Resisting Normalization Urges

Summary

Chapter 4: Inventory

Value Chain Introduction

Inventory Models

Fact Table Types

Value Chain Integration

Enterprise Data Warehouse Bus Architecture

Conformed Dimensions

Conformed Facts

Summary

Chapter 5: Procurement

Procurement Case Study

Procurement Transactions and Bus Matrix

Slowly Changing Dimension Basics

Hybrid Slowly Changing Dimension Techniques

Slowly Changing Dimension Recap

Summary

Chapter 6: Order Management

Order Management Bus ...