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
Aug 01, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jul 30, 2024
Transfer Request Deadline
Jul 30, 2024
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Aug 01, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jul 30, 2024
Transfer Request Deadline
Jul 30, 2024
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Aug 29, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Aug 27, 2024
Transfer Request Deadline
Aug 27, 2024
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Aug 29, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Aug 27, 2024
Transfer Request Deadline
Aug 27, 2024
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Sep 24, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Sep 22, 2024
Transfer Request Deadline
Sep 22, 2024
Section Title
Advanced Power BI: Level 1
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Sep 24, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Sep 22, 2024
Transfer Request Deadline
Sep 22, 2024
Required fields are indicated by .