<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)

Advanced Data Modeling with Power BI - What you need to get started

Module 00 - Class Introduction

Module 01A – Data Modeling Basics and Power BI Desktop Internals (Overview Part 1))

Module 01B – Data Modeling Basics and Power BI Desktop Internals (Overview Part 2))

Module 01C - Data Modeling Basics And Power Bi Desktop Internals (Lab 1) 16 min.

Module 02 - Data Modeling Best Practices 36 min.

Module 03A - Dax Calculated Columns & Measures (Calculated Columns) 21 min.

Module 03B - Dax Calculated Columns & Measures (Calculated Measures) 16 min.

Module 03C - Dax Calculated Columns & Measures (Lab 2) 18 min.

Module 04 - Calculate 19 min.

Module 05A - Evaluation Context (Row And Filter Context) 19 min.

Module 05B - Evaluation Context (Table Functions) 19 min.

Module 05C - Evaluation Context (Lab 3) 24 min.

Module 06 - Advanced Dax Time Intelligence Functions 12 min.

Module 07 - Dax Best Practices 17 min.

This course includes:

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