Your Team,
Your Location,
Our Instructors

Advanced Dimensional Modeling: Techniques for Practitioners

Duration: Two Day Course

Prerequisite: This course assumes a basic understanding of dimensional modeling concepts, techniques, and terminology.

Course Outline

Introductory dimensional data design courses are great for learning the basics. But the examples they show are relatively simple designs consisting of a single fact table, fully additive facts, and single-hierarchy dimensions. Unfortunately, the real world is not as simple as the models that are needed to teach the basic concepts. The novice designer of data warehouses and data marts quickly encounters situations that simply do not fit neatly into basic dimensional design theory.

This course takes you beyond the basics to learn proven techniques to address many of the complexities you will encounter in practice. From multiple fact tables to dimensional complexity, you’ll gain techniques learned through experience and used by the experts to match data designs to business realities, to implement highly complex data models, and to work with very large data volumes.

You Will Learn

  • The real-world challenges that make dimensional modeling in practice more complex than as presented in theory
  • Alternatives for and extensions to transaction-based fact table design
  • Alternatives and extensions to address dimension complexity
  • Design techniques to address growth, change, and scalability
  • How to evaluate alternatives and make informed design choices

Geared To

  • Data modelers, Data warehouse and data mart designers, BI reporting and information delivery developers, anyone who participates in the design process

Contact Us to Get Started Today


Yvonne Baho

Yvonne M. Baho Director, Onsite Education
Phone: 978.582.7105
E-mail: ybaho@tdwi.org


Check out the Onsite Brochure

Download Now


“Very good overall view of DW concepts and provided valuable insight for such a varied audience.”

Jerry Bundt
Nestle Purina

“This was the best training class I’ve had in my 20 year career.”

Tim Grieb
Seattle Children’s Hospital

“The instructor did an excellent job and demonstrated an understanding of real world applications.”

Sean Dewulf
Con-way Freight

Discover the impact Onsite Education has had on real Fortune 500 clients through practical in-depth training.

  • Banking
  • Healthcare
  • Manufacturing
TDWI has provided education to 95% of the Fortune 100 companies.
Our expert instructors will help your company surge ahead of the competition.