Welcome to Wilshire Conferences Seminars

Seminar Overview

Seminar Description

Seminar Fees and Logistics

Instructor

Back to Wilshire Seminars

Comments from Recent Attendees:

“Friendly, helpful, non-intimidating presentation with great practical experience behind it.”

“The lectures, discussions, and exercises helped validate the topic.”

“We have had Tom teach onsite before, so I knew this class would be good.”

Dimensional Modeling: Data Modeling for the Data Warehouse
San Francisco, CA, October 2-5, 2007

A 4-DAY WORKSHOP with TOM HAUGHEY

Dimensional Modeling: Data Modeling for the Data Warehouse
This workshop will focus on the specialized techniques used to model data warehouse data. This will include but go beyond dimensional modeling. It provides concrete guidelines and rules for modeling this data. This workshop will stress that this is not just an intuitive process based solely on the spontaneous judgment of a skilled analyst. It can be based on sound rules and guidelines just as production data models are. It is also not a process that can rely entirely on pre-defined patterns like star schemas.

Course Topics

Topics covered in the Dimensional Modeling and Data Warehouse Seminar, October 2-4 include:

Scope and levels of modeling
Data Warehouse Methodology
Different Architectures for the Data Warehouse
Running a Data Warehouse Project
Building the Central Data Warehouse Model
Levels of Data In the Enterprise
Designing Data Marts
Designing Aggregate Data
Modeling Time and History
Analyzing Current Systems
Data Transformations during ETL
Critical Warehouse Components
Optimizing the Data Warehouse Design
Data Design Compromises
Safe and Aggressive Compromises to Data
Critical Factors in Data Design
The Steps of Optimization
Data Warehouse Technology
Important Considerations and Issues

Topics covered in the Advanced Dimensional Modeling Concepts Seminar, October 5 include:

Heterogeneous Product and Transaction Types
Handling Changing Dimensions
Supporting Data with Different Rates of Change and Stability
Supporting Large Scale Database Environments
Required Snowflakes
Conformed Facts and Dimensions
Heterogeneous Dimensions and Facts
Master Data and the Data Warehouse
Late Arriving Data: Facts and Dimensions
Fact to Fact Joins
Factless Facts
Handling Multi-valued Dimensions and Complex Dimensions, such as Hierarchical, Ragged, Multiple Dimensions
Aggregates vs. on-the-fly
Special Issues in Near Real-time Data Warehousing

Who should attend?

Data warehouse project managers
Data and process modelers
Data administrators/Database administrators
Physical database designers

A 4-DAY WORKSHOP with TOM HAUGHEY

San Francisco, CA, October 2-5, 2007

Seminar Fees:

$1995: Entire 4 days of classes, including Advanced Dimensional Modeling on October 5th

$1595: First 3 days only

$695: Advanced Dimensional Modeling only, on October 5th

Early Bird Discount:

Save $200 on three (3) or four (4) day fees if paid by August 10

Save $100 on three (3) or four (4) day fees if paid by September 7

Groups of 5 or more receive a 20% discount.
The team discount is not available with online registration. Please call (310) 477-4475 to register your team or use THIS registration form.