Dimensional Modeling Primer
Goals of a Data Warehouse
Components of a Data Warehouse
Dimensional Modeling Vocabulary
Dimensional Modeling Myths
Retail Sales
Four-Step Dimensional Design Process
Retail Case Study
Dimension Table Attributes
Retail Schema In Action
Retail Schema Extensibility
Resisting Comfort Zone Urges
Surrogate Keys
Market Basket Analysis
Inventory
Introduction to the Value Chain
Inventory Models
Value Chain Integration
Data Warehouse Bus Architecture
Procurement
Procurement Case Study
Procurement Transactions
Slowly Changing Dimensions
Hybrid Slowly Changing Dimension Techniques
More Rapidly Changing Dimensions
Order Management
Introduction to Order Management
Order Transactions
Invoice Transactions
Accumulating Snapshot for the Order
Fulfillment Pipeline
Fact Table Comparison
Designing Real-Time Partitions
Customer Relationship Management
CRM Overview
Customer Dimension
Analyzing Customer Data From Multiple Business
Processes
Accounting
Accounting Case Study
General Ledger Data
Budgeting Process
Role of OLAP and Packaged Analytic Solutions
Human Resources Management
Time-Stamped Transaction Tracking in a Dimension
Time-Stamped Dimension with Periodic Snapshot
Facts
Audit Dimension
Keyword Outrigger Dimension
Survey Questionnaire Data
Financial Services
Banking Case Study
Dimension Triage
Arbitrary Value Banding of Facts
Point-In-Time Balances
Heterogeneous Product Schemas
Telecommunications And Utilities
Telecommunications Case Study
General Design Review Considerations
Draft Design Exercise Discussion
Geographic Location Dimension
Transportation
Airline Frequent Flyer Case Study
Extensions to Other Industries
Combining Small Dimensions into a Super Dimension
More Date and Time Considerations
Education
University Case Study
Accumulating Snapshot for Admissions Tracking
Factless Fact Tables
Other Areas of Analytic Interest
Health Care
Health Care Value Circle
Health Care Bill
Complex Health Care Events
Medical Records
Going Back In Time
Electronic Commerce
Web Client-Server Interactions Tutorial
Why the Click Stream Is Not Just Another Data Source
Click Stream Fact Table for Complete Sessions
Click Stream Fact Table for Individual Page Events
Aggregate Click Stream Fact Tables
Integrating the Click Stream Data Mart into the Enterprise Data Warehouse
Electronic Commerce Profitability Data Mart
Insurance
Insurance Case Study
Policy Transactions
Policy Periodic Snapshot
More Insurance Case Study Background
Claims Transactions
Claims Accumulating Snapshot
Policy/Claims Consolidated Snapshot
Factless Accident Events
Common Dimensional Modeling Mistakes to Avoid
Building The Data Warehouse
Business Dimensional Lifecycle Road Map
Project Planning and Management
Business Requirements Definition
Lifecycle Technology Track
Technical Architecture Design
Product Selection and Installation
Lifecycle Data Track
Dimensional Modeling
Physical Design
Data Staging Design and Development
Lifecyle Analytic Applications Track
Deployment
Maintenance and Growth
Common Data Warehousing Mistakes to Avoid