Skip to main content

Advanced Power BI

ID : 66477   
« back to classes page
Expand your knowledge of Power BI Desktop to the highest level. This course focuses on the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results.
Agenda
Unit 1 - Power Query
  • Utilize Column profile, distribution, and quality
  • Perform fuzzy match
  • Duplicate versus Reference queries
  • Debug errors
Unit 2 - Data Modeling
  • What a Star Schema is
  • Understand relationship types
  • Manage relationships
Unit 3 - DAX
  • Understand contexts
  • CALCULATE function
  • COALESCE function
  • Compute visual totals accurately
Unit 4 - Reports
  • Insert Objects
  • Create Bookmark

Class Details

4 Session(s)
Online 24/7

Location
Online

Instructor
Marion Williams 

CEUs : 1.6

Tuition: 

$195.00


View Certificate Series Information

Registration Closes On
Monday, November 4, 2024 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
11/4/2024 - 11/29/2024 Online 24/7 12:00 AM - 12:00 AM N/A - Online Marion Williams 

Contact Us!

ncal@normandale.edu - 952.358.8343
Normandale Community College - Continuing Education

9700 France Avenue South, Bloomington, MN 55431

A member of the Minnesota State Colleges & Universities System