Table of Contents
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
Alternative DW/BI Architectures
More Reasons to Think Dimensionally
Chapter 2: Kimball Dimensional Modeling Techniques Overview
Basic Dimension Table Techniques
Integration via Conformed Dimensions
Dealing with Slowly Changing Dimension Attributes
Dealing with Dimension Hierarchies
Advanced Fact Table Techniques
Four-Step Dimensional Design Process
Enterprise Data Warehouse Bus Architecture
Procurement Transactions and Bus Matrix
Slowly Changing Dimension Basics
Hybrid Slowly Changing Dimension Techniques
Slowly Changing Dimension Recap
Accumulating Snapshot for Order Fulfillment Pipeline
Accounting Case Study and Bus Matrix
Dimension Attribute Hierarchies
Role of OLAP and Packaged Analytic Solutions
Chapter 8: Customer Relationship Management
Bridge Tables for Multivalued Dimensions
Customer Data Integration Approaches
Chapter 9: Human Resources Management
Packaged Analytic Solutions and Data Models
Recursive Employee Hierarchies
Multivalued Skill Keyword Attributes
Chapter 10: Financial Services
Banking Case Study and Bus Matrix
Dimension Triage to Avoid Too Few Dimensions
Supertype and Subtype Schemas for Heterogeneous Products
Chapter 11: Telecommunications
Telecommunications Case Study and Bus Matrix
General Design Review Considerations
Draft Design Exercise Discussion
Remodeling Existing Data Structures
Airline Case Study and Bus Matrix
Extensions to Other Industries
Combining Correlated Dimensions
More Date and Time Considerations
University Case Study and Bus Matrix
Accumulating Snapshot Fact Tables
More Educational Analytic Opportunities
Healthcare Case Study and Bus Matrix
Facility/Equipment Inventory Utilization
Dealing with Retroactive Changes
Chapter 15: Electronic Commerce
Clickstream Dimensional Models
Integrating Clickstream into Web Retailer's Bus Matrix
Profitability Across Channels Including Web
More Insurance Case Study Background
Policy/Claim Consolidated Periodic Snapshot
Common Dimensional Modeling Mistakes to Avoid
Chapter 17: Kimball DW/BI Lifecycle Overview
Lifecycle BI Applications Track
Chapter 18: Dimensional Modeling Process and Tasks
Chapter 19: ETL Subsystems and Techniques
Extracting: Getting Data into the Data Warehouse
Delivering: Prepare for Presentation
Chapter 20: ETL System Design and Development Process and Tasks
Develop One-Time Historic Load Processing
Develop Incremental ETL Processing
Chapter 21: Big Data Analytics