By using website you agree to our use of cookies as described in our cookie policy. Learn More


Your Team,
Your Location,
Our Instructors

Dimensional Modeling Beyond the Basics: Intermediate and Advanced Techniques

Duration: Two Day Course

Prerequisite: All attendees should have basic knowledge about dimensional modeling AND some hands-on experience with dimensional modeling.

Course Outline

OK, you have done your homework. You have learned the fundamental dimensional modeling skills and you have jumped into the first, second, third project. Now what? You're at the point where your modeling problems do not fit neatly into the textbook examples. Maybe you are stumped or perhaps you think you have solved the problem correctly but need a second opinion. 

This accelerated class will go beyond the fundamentals and answer some of the most commonly asked questions people ask, as well as addressing the most common mistakes that people make. This course is based on real-world experience dealing with large data volumes and very complex models. The goal of this course is to equip you with the tools and knowledge to address your complex modeling challenges and to meet your demanding business needs.

You Will Learn

  • Advanced techniques for handling complex, real-life dimensional modeling problems
  • How to weigh advantages and disadvantages of design options
  • Guidelines for designing complex data marts
  • Techniques to keep users involved in the modeling process

Geared To

  • All data modelers and database administrators who have been developing or supporting data warehouses should attend this course.  This course is intended to expand their knowledge of modeling techniques beyond the basic concepts.
  • This course is also appropriate for other team members including project managers, staging system developers, and end-user application designers, including BI developers and data scientists.

Contact Us to Get Started Today


Yvonne Baho

Yvonne M. Baho Director, Enterprise Learning
Phone: 978.582.7105


"The instructor was very responsive to input from the class and adapted to meet the needs specific to our context. I especially appreciated the many case studies and focus on assessment."

S. Bessias UNC Healthcare

"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


Yvonne Baho Yvonne M. Baho
Director, Enterprise Learning
Phone: 978.582.7105
TDWI Onsite Brochure Download

Download the Onsite Brochure

Download Now

Contact Us to Get Started Today

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.