Contents
A Data Warehouse Needs a Purpose
Gravitational Pull of a Data Warehouse
Chapter 2 What Is Market Basket Analysis?
Elements of Market Basket Analysis
Statistics in Market Basket Analysis
Logic of Market Basket Analysis
What Market Basket Analysis Is Not
Market Basket Analysis as an Activity
Chapter 3 How Does Market Basket Analysis Produce ROI?
Chapter 4 Why Is Market Basket Analysis Difficult?
Completeness and Data Sampling
Data Warehouse Data Structures
Recursive Nature of Market Basket Analysis
Chapter 5 Market Basket Analysis Solution Definition
Definition of the Driver Object
Definition of the Correlation Object
Market Basket Analysis BI View
Additional Group by Data Elements
Beyond the Market Basket Analysis BI View
Market Basket Reporting in Batch
Chapter 6 Market Basket Architecture and Database Design
Market Basket Analysis Architecture
Market Basket Reporting Architecture
Market Basket KPI Exception Reporting
Market Basket Data Definition Language (DDL)
Construction of the Market Basket Table
Construction of the Market Basket BI Table
Chapter 7 ETL into a Market Basket Datamart
Requirement: Populate the Market Basket BI Table
Step 1: Extract from a Fact Table and Load to a Market Basket Table
Step 2: Recursively Join the Market Basket Table and Load a Market Basket BI Table
Step 3: Arithmetic Juxtaposition of Driver Objects and Correlation Objects
Step 4: Load a Market Basket BI Table Using a Correlation Hierarchy
Step 5: Load a Market Basket BI Table Using a Driver Hierarchy
Step 6: Load a Market Basket BI Table Using the Same Hierarchy as Driver and Correlation
Chapter 8 What Is Time Variance?
Year, Quarter, Month, Week, Cycle, Day of Week, Time Zone, Date, and Time of Day
Ralph Kimball’s Variations of Time Variance
Type 1—All History Looks Like Now
Type 2—All History in Its Own Context
Chapter 9 How Does Time Variance Produce ROI?
Cause and Effect Is Not Causal Analysis
Chapter 10 Why Is Time Variance Difficult?
Sets—The Bane of Time Variance
Chapter 11 Time Variant Solution Definition
The Goal of This Time Variant Solution Design
Join to a Compound Instance Key
Which Tables Use Instance Keys?
First Time Variant Subject Area
Chapter 12 Time Variant Database Definition
Tables of Types and Types of Tables
Type 2 Time Variant Dimension Tables
Type 1 and Type 2 Time Variant Dimension Tables in a Shared Environment
Type 1 Time Variant Dimension Tables
Only the Row in Effect Right Now
Chapter 13 ETL into a Time Variant Data Warehouse
Instance Keys in Dimension ETL
Instance Keys—The Manufacturing Example
Metadata, Data Quality, and the Like
Chapter 14 Market Basket Analysis in a Time Variant Data Warehouse
Market Basket Analysis at a High Level
Market Basket Analysis in a Time Variant Context at a High Level
Elements of Time Variant Market Basket Analysis
Forms of Time Variant Market Basket Analysis
Instance Driver Object and Instance Correlation Object
Instance Driver Object and Entity Correlation Object
Entity Driver Object and Instance Correlation Object