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
T
Time
8:30AM to 4:00PM
Dates
Apr 16, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 14, 2024
Transfer Request Deadline
Apr 14, 2024
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Apr 16, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 14, 2024
Transfer Request Deadline
Apr 14, 2024
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Jun 04, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jun 02, 2024
Transfer Request Deadline
Jun 02, 2024
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Jun 04, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jun 02, 2024
Transfer Request Deadline
Jun 02, 2024
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Jun 13, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jun 11, 2024
Transfer Request Deadline
Jun 11, 2024
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Jun 13, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jun 11, 2024
Transfer Request Deadline
Jun 11, 2024
Required fields are indicated by .