Loading...

Course Description

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.

Note: This course is part of a Digital Badge for those who wish to earn a credential. You may register for this individual class, but if If you would like to earn the Digital Badge, register for LRN0170 - Online Self-Paced Power BI Digital Badge.

 

.

Course Outline

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

Instructor:

With over 20 years of IT and training experience, Marion Williams has been responsible for designing custom solutions using Access and Excel/VBA. As a trainer, Marion has delivered over 200 seminars to CPA associations across Canada. As technology evolved, Marion currently uses her skills to specialize in training Power B, a tool used for business intelligence. Marion earned the FLMI designation which is a comprehensive business education in the context of the insurance and financial services industry with a specialty in Information Technology

Applies Towards the Following Digital Badges

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced Power BI (Business Intelligence)
Type
Online-Self Paced
Dates
Nov 04, 2024 to Nov 29, 2024
Contact Hours
16.0
Course Fee(s)
Tuition non-credit $195.00 Click here to get more information
Section Notes

For further information on this course, please contact dlanpher@harpercollege.edu.

Required fields are indicated by .