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
W
Time
8:30AM to 4:00PM
Dates
Feb 19, 2025
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Feb 17, 2025
Transfer Request Deadline
Feb 17, 2025
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
W
Time
8:30AM to 4:00PM
Dates
Feb 19, 2025
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Feb 17, 2025
Transfer Request Deadline
Feb 17, 2025
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
Mar 14, 2025
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 12, 2025
Transfer Request Deadline
Mar 12, 2025
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
Mar 14, 2025
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 12, 2025
Transfer Request Deadline
Mar 12, 2025
Required fields are indicated by .