Loading...

Course Description

Use Power BI to shape and cleanse data, preparing it for output to visualizations and reports. Learn to work with more advanced data models, and to create and use data hierarchies. Understand how to create/apply reference lines using the Analytics panel, and how to create and use measures. Learn to make calculated columns using Data Analysis Expression (DAX) functions and to use DAX to calculate across multiple tables. Discover the CALCULATE function to generate multiple criteria filters, the RANK function to order data, and other functions to manage date arithmetic. Understand how to use logical functions to create alerts and custom groups. Topics include in-depth calculated columns and measures, and creating end-user parameter controls. Additonal topics include advanced aggregation and filtering using the “X” functions (SUMX, AVERAGEX, MINX, MAXX, COUNTX).

In this class, you will learn how to: 

  • Creating calculated columns 

  • Creating measures 

  • Creating Quick Measures 

  • Ranking values 

  • Performing joins in data queries 

  • Advanced applications of tooltips 

Prerequisites

Intermediate Power BI or equivalent experience.

Applies Towards the Following Certificates

Loading...

Enroll Now - Select a section to enroll in

Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Sep 24, 2026
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $500.00
Drop Request Deadline
Sep 22, 2026
Transfer Request Deadline
Sep 22, 2026
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Oct 15, 2026
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $500.00
Drop Request Deadline
Oct 13, 2026
Transfer Request Deadline
Oct 13, 2026
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
W
Time
8:30AM to 4:00PM
Dates
Nov 04, 2026
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $500.00
Drop Request Deadline
Nov 02, 2026
Transfer Request Deadline
Nov 02, 2026
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Nov 17, 2026
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $500.00
Drop Request Deadline
Nov 15, 2026
Transfer Request Deadline
Nov 15, 2026
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
W
Time
8:30AM to 4:00PM
Dates
Dec 09, 2026
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $500.00
Drop Request Deadline
Dec 07, 2026
Transfer Request Deadline
Dec 07, 2026
Required fields are indicated by .