Data Warehouse Design Solutions

CONTENTS

CHAPTER 1 THE BUSINESS-DRIVEN DATA WAREHOUSE

The Data Warehouse

Events and the Transaction Model

Business Processes and the Dimensional Model

The Star Schema

The Grain

The Dimensions

The Fact Table

More than One Fact Table

Different Process, Different Star

Core and Custom Fact Tables

Snapshot and Transaction

Coverage

Aggregation

The Enterprise Data Warehouse

Crossing Process Boundaries

Plan a Data Warehouse, Build a Data Mart

Summing Up Dimensional Modeling Principles

CHAPTER 2 SALES

Direct versus Indirect Sales?

Indirect Sales

Car Sales Are Up!

Answering the Sales Analyst's Questions

Understanding Direct Sales

Software Sales

Different Sources, Inadequate Systems

Designing the Direct Sales Data Warehouse

Answering the Sales VP's Questions

The Merchant's Data Warehouse

The Department Store

Winter Coats

Answering the Retailer's Questions

Coat Sales by Product—Stagnant Inventory

Summing Up Sales

CHAPTER 3 MARKETING

What Is Known about the Customer?

The Grocery Store

Grocery Store Sales Schema

Grocery Store Marketer

The Promotion Dimension

Grocery Store Reports

The Telephone Company

The Telco Marketer

The Residential Billing Data Mart

Telecom Reports

Retail Banking

The Banking Schema

Beyond Reports: Using the Banking Data Mart

Summing Up Marketing

CHAPTER 4 FULFILLMENT

Fulfillment and the Value Proposition

Flowers and Time

Flowers over the Phone

On-Time Delivery

Disposition of an Order

Reporting on Fulfillment

Returns: A Second Fact Table

Identifying Suppliers with Quality ...