Advanced Power BI

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.

Course length: One month
Number of Hours: 16
Cost: $195
Course start dates: 4/1/24, 6/3/24, 8/5/24, 11/4/24

You may also take this course as part of the Power BI Certificate.

Additional Course Information

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 Bookmarks

Cancellation Policy

Continuing Education Classes:

We understand that sometimes life happens. If you are unable to attend your class, please email Continuing-ed@uwm.edu. We will be happy to contact your instructor to let them know and provide you with any material missed.

If you cancel 8 days prior to the start of your class, we are happy to issue an account credit/voucher to you. If you do not provide an 8 day cancellation notice, you will not be eligible to receive a credit/voucher*. Unfortunately, no refunds will be provided.

*Please remember, vouchers are not issued for and cannot be used towards trips, online, or credit courses.*

In order for Continuing Education to continue to provide the community with the outreach programming that we have, all cancellations will be assessed a 6% administrative fee. If you would like to provide a donation or contribute to our scholarship fund, you can do so at check-out by adding any dollar amount to your order! You can also contact our department at continuing-ed@uwm.edu. Continuing Education is cost-recovery and relies on community donations to help support its programs.

Thank you for your continued support!

Course Detail