Dimensional Modeling

Dimensional Modeling-Data Modeling for the Data Warehouse
and Advanced Dimensional Modeling Concepts
Tom Haughey
October 20-23, 2008
Courtyard Marriott, Orlando, FL

This interactive seminar 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 seminar 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.

Topics covered in the Dimensional Modeling-Data Modeling for the Data Warehouse Seminar include:

· Brief introduction to Data Warehousing
· Data Warehouse Architectures
· Gathering Information Requirements and how it is different for data warehousing
· Creating a Dimensional Modeling
· Creating the Central Warehouse
· Designing Data Marts
· Advanced Dimensional Topics
· Designing Aggregations
· Designing for Time and History
· Data Extraction and Transformation
· The Data Warehouse Project
· Metadata and the Data Warehouse
· The operational Data Store
· Data Warehouse Technology

Among the most important factors you will learn at this seminar will be how to design a dimensional data warehouse. The seminar will teach how to effectively accomplish this aspect of data modeling, while ensuring a quality data warehouse design. Concepts learned are reinforced by individual and group exercises

Click here for detailed agenda

Advanced Dimensional Modeling Concepts Seminar
October 23, 2008
Courtyard Marriott, Orlando, FL

The seminar will focus on the most challenging data warehouse data design problems the world of data warehousing has faced. Among these requirements are: handling aggregation, heterogeneous product and transaction types, handling time and history, handling changing dimensions, handling late arriving data, supporting data with different rates of change and stability, supporting large scale database environments such as MPP (massively parallel processing). Designing a data warehouse requires different roles and uses of data, a different use of normalization, and new modeling constructs. Key special requirements of the data warehouse focus on time, location, and dimensional aspects of data. These requirements are among the reasons that analytical data modeling demands different skills, perspectives and techniques.

Topics covered 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
· Master Data and the data warehouse
· Heterogeneous dimensions and facts
· Late arriving data: facts and dimensions
· Fact to fact joins
· Factless facts
· The "unity" dimension
· Handling multi-valued dimensions and complex dimensions, such as hierarchical, ragged, multiple dimensions
· Designing aggregates
· Aggregates vs. on-the-fly
· Special issues in near real-time data warehousing

Click here for detailed agenda

Tom Haughey is currently President of InfoModel, Inc., a training and consulting company specializing in practical and rapid development methods. His courses on data management, data warehousing, and software development have been delivered to Fortune 1000 companies around the world. He has worked on the development of seven different CASE tools, over 40,000 copies of which have been sold to date. He was formerly Chief Technology Officer for the Pepsi Bottling Group and Enterprise Director of Data Warehousing for Pepsico. He wrote his own CASE tool in 1984.He formerly worked for IBM for 17 years as a Senior project manager. He is the author of many articles on Data Management, Information Engineering and Data Warehousing.

Tuition
$1995 (entire 4 day class)
$1695 (Dimensional Modeling-Data Modeling for the Data Warehouse
$645 (Advanced Dimensional Modeling Concepts only)

$100 Discount when registering for 3 or 4 days by September 17, 2008.
Additional $100 discount for members of DAMA, ERwin Groups, IDMA and MPO when registering for 3 or 4 days.

$50 Discount when registering for the Advanced Concepts only by September 17, 2008.

Additional $50 discount for members of DAMA, ERwin User Groups, IDMA and MPO when registering for Advanced Concepts only,

Group discounts are available.

For registration please click here.

Seminar Location and Hotel Accommodations
Courtyard by Marriott Lake Buena Vista at Vista Centre
8501 Palm Parkway
Lake Buena Vista, FL, 32830

Seminar attendees are eligible for a discounted hotel rate of $129 per night.

This rate is available until September 25, 2008 or when the hotel block sells out.

Please call 1 800-787-3636 and mention Dimensional Modeling in order to obtain the discount rate.

For additional information please email davida@debtechint.com or call (973)379-7212.