Welcome to Debtech International

Onsite Seminar

Advanced Dimensional Modeling Concepts

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.

Upon completion of this course attendees will:

  • Understand how to determine the best architecture
  • Understand the appropriate use of surrogate keys
  • Understand how to determine what is a dimension, dividing and combining dimensions, leveled dimensions, abstract dimensions, ragged dimensions
  • Understand how to handle changing dimensions, snapshot data, complex dimensions, multi-valued dimensions
  • Understand how and when to use aggregates
  • Understand how to handle multiple units of measurement, such as currency reporting, and multi-time-zone reporting, etc.
  • Understand how to handle restatement
  • Understand how to handle snowflake structures

Course Outline

  • Additional Data warehouse architectures
  • Handling changing dimensions
  • Conformed facts and dimensions
  • Master Data and the data warehouse
  • Required snowflakes
  • Use of surrogate keys
  • Supporting large scale database environments
  • Heterogeneous product and transaction types
  • Problems with flattening T1 and T2 dimensions
  • Design for parallel
  • Predicate analysis for star joins

2 days

Course Format
Lecture, group discussion and exercises

Tom Haughey

To request a quote for this in-house seminar
Please call (561) 218-4752 or email info@debtechint.com

Return to Onsite Seminars Table of Contents