Loading...

Course Description

Delve deeper into Power BI data modeling concepts and discover how to take a large single-source fact table and identify fields to break out and use as dimension/lookup tables.Learn to effectively use time intelligence to manipulate data using time periods and do week-over-week analysisand parallel period analysis. Understand how to create a cumulative total and compare your results against the same period last year.Discover more custom visuals including a word cloud.Learn to combine your results using the Set functions in DAX: Union, Intersect, and Except.Topics include data modeling basics, the star schema data model, and data model properties.Additional topics include handling multiple relationships and dealing with mismatched tables.

In this class, you will learn how to: 

  • Data modeling principles and data model properties 

  • Working with multiple fact tables 

  • Applying advanced Time Intelligence functions 

  • Navigating multiple relationships 

  • Combining results with Union, Intersect, and Except 

  • Working with mismatched tables 

  • Using a Word Cloud custom visualization 

Prerequisites

Advanced Power BI: Level 2 or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced Power BI: Level 3
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Mar 26, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 24, 2024
Transfer Request Deadline
Mar 24, 2024
Section Title
Advanced Power BI: Level 3
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Mar 26, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 24, 2024
Transfer Request Deadline
Mar 24, 2024
Section Title
Advanced Power BI: Level 3
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Apr 30, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 28, 2024
Transfer Request Deadline
Apr 28, 2024
Section Title
Advanced Power BI: Level 3
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Apr 30, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 28, 2024
Transfer Request Deadline
Apr 28, 2024
Section Title
Advanced Power BI: Level 3
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Jun 20, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jun 18, 2024
Transfer Request Deadline
Jun 18, 2024
Section Title
Advanced Power BI: Level 3
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Jun 20, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jun 18, 2024
Transfer Request Deadline
Jun 18, 2024
Required fields are indicated by .