<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Home / Power BI / Advanced Data Modeling with Power BI

Advanced Data Modeling with Power BI

This course covers DAX formulas, data model design impacts, calculated columns, measures, and design patterns in data modeling.

Free Community Plan View Pricing Plans
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

In Advanced Data Modeling in Power BI, Greg Trzeciak helps you move beyond basic star schema design and handle the modeling challenges that show up in real-world datasets. This course focuses on the “tricky parts” of modeling, scenarios that can break filters, confuse visuals, or slow performance if they’re not designed intentionally. You’ll learn how to recognize these patterns early and apply proven solutions that keep models predictable, scalable, and easy for report builders to use. You’ll work through advanced relationship and dimension patterns with hands-on demonstrations, including bidirectional filtering, one-to-one relationships, many-to-many with bridge tables, slowly changing dimensions, and special table types like junk and degenerate dimensions. Greg also covers role-playing dimensions and multiple fact table scenarios, helping you design models that support complex business processes without turning into an unmaintainable mess. By the end, you’ll have a toolkit of advanced modeling patterns and best practices you can apply immediately in production Power BI projects.

Course Outline ( Free Preview)

Module 01 - Introduction

Module 02 - BiDirectional Filtering

Module 03 - Bidirectional Filtering Demo 10 min.

Module 04 - One-to-One Relationships 3 min.

Module 05 - One-to-One Relationships Demo 6 min.

Module 06 - Handling Many-to-Many With Bridge Tables 5 min.

Module 07 - Many-to-Many Demo 6 min.

Module 08 - Many-to-Many Demo Part 2 6 min.

Module 09 - Slowly Changing Dimensions 12 min.

Module 10 - Slowly Changing Dimensions Demo 8 min.

Module 11 - Junk Dimensions 3 min.

Module 12 - Junk Dimensions Demo 5 min.

Module 13 - Degenerate Dimensions 2 min.

Module 14 - Degenerate Dimensions Demo 4 min.

Module 15 - Role Playing Dimensions 3 min.

Module 16 - Role Playing Dimensions Demo 11 min.

Module 17 - Multiple Fact Tables Demo 6 min.

Module 18 - Best Practices 2 min.

Module 19 - Class Wrap Up 2 min.

This course includes:

  • 1+ hours of training
  • 19 Modules
  • Expert level content
  • Access on mobile and browser
  • Certificate of Completion
Free Community Plan View Pricing