Loading...

Program Description

Expand your knowledge of Power BI Desktop to the highest level. This course focuses on the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results.

Upon successful completion of the course, you will:

  • Check for data inconsistencies
  • Use data profiling to create efficient queries
  • Write efficient DAX code
  • Add trendlines to charts
  • Add Objects and Bookmarks to reports

Learning Objectives:

  • Provide an understanding of Data Profiling in Power Query.
  • Have students learn how to create a Fuzzy Match
  • Give an understanding the difference between Duplicate and Reference Queries
  • Have students know the differences between relationship types
  • Explore advanced DAX functions
  • Create a Key Influencer visual

Course Outline

Unit 1: Power Query
  • Utilize Column profile, distribution, and quality
  • Perform fuzzy match
  • Duplicate versus Reference queries
  • Debug errors
Unit 2: Data Modeling
  • What a Star Schema is
  • Understand relationship types
  • Manage relationships
Unit 3: DAX
  • Understand contexts
  • CALCULATE function
  • COALESCE function
  • Compute visual totals accurately
Unit 4: Reports
  • Insert Objects
  • Create Bookmarks

 

Loading...

Register - Select a section to enroll in

Program Title
Advanced Power BI
Type
Workshop
Dates
Aug 03, 2026 to Aug 28, 2026
Delivery Methods
Online (Self-Paced)  
Program Fee(s)
Program Fee non-credit $195.00

Section Notes

Instructor: With over 20 years of IT and training experience, Marion Williams has been responsible for designing custom solutions using Access and Excel/VBA. As a trainer, Marion has delivered over 200 seminars to CPA associations across Canada. As technology evolved, Marion currently uses her skills to specialize in training Power BI, a tool used for business intelligence.

Marion earned the FLMI designation which is a comprehensive business education in the context of the insurance and financial services industry with a specialty in Information Technology.

Program Title
Advanced Power BI
Type
Workshop
Dates
Nov 02, 2026 to Nov 27, 2026
Delivery Methods
Online (Self-Paced)  
Program Fee(s)
Program Fee non-credit $195.00

Section Notes

Instructor: With over 20 years of IT and training experience, Marion Williams has been responsible for designing custom solutions using Access and Excel/VBA. As a trainer, Marion has delivered over 200 seminars to CPA associations across Canada. As technology evolved, Marion currently uses her skills to specialize in training Power BI, a tool used for business intelligence.

Marion earned the FLMI designation which is a comprehensive business education in the context of the insurance and financial services industry with a specialty in Information Technology.

Required fields are indicated by .