Dimensional Modeling for the Data Warehouse Course

Course Code: MV 105
Course Abstract: This course provides participants with the skills necessary to design a successful data warehouse using multi-dimensional data modeling techniques. It is based on Ralph Kimball’s book The Data Warehouse Toolkit, Second Edition published in April, 2002.
Audience: This course is targeted at technical staff, team leaders and project managers who need to understand how to design a data warehouse using multi-dimensional data modeling techniques
Duration: 4 days
Learning Outcomes:

Upon completion of this course, the participant will be able to design a database warehouse using multi-dimensional techniques

Course Topics:

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

Prerequisites: Participants should have at least some experience with any relational database management system.
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning