Loading...

Course Description

Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using modeling features and relationships. Perform calculations using DAX (Data Analysis Expressions) functions. Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports.

Course Outline

Unit 1 – Power Query
Unit 2 –  Data Modeling
Unit 3 – DAX
Unit 4 – Reports

For a more detailed agenda view course here

Learner Outcomes

  • Utilize the ETL process to shape your data
  • Know how to Pivot and Unpivot your data
  • Create a Data Model
  • Design a Drillthrough report
  • Use Visual Hierarchies and Drill Downs

 

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Intermediate Power BI
Type
Online, self paced
Dates
May 06, 2024 to May 31, 2024
Delivery Options
Online  
Course Fee(s)
Course Fee non-credit $195.00
CEUs
1.6 CEUs
Section Notes

This one-month, self-paced, online course (no-Live meetings) is scheduled for May 6-31, 2024. There are no set meeting dates or times.

Instructor: Marion Williams 

NOTE: Students will receive log-on information from LERN/UGotClass the Wednesday before class begins. 

Section Title
Intermediate Power BI
Type
Online, self paced
Dates
Jul 01, 2024 to Jul 26, 2024
Delivery Options
Online  
Course Fee(s)
Course Fee non-credit $195.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes

This one-month, self-paced, online course (no-Live meetings) is scheduled for July 1-26, 2024. There are no set meeting dates or times.

Instructor: Marion Williams 

NOTE: Students will receive log-on information from LERN/UGotClass the Wednesday before class begins. 

Section Title
Intermediate Power BI
Type
Online, self paced
Dates
Oct 07, 2024 to Nov 01, 2024
Delivery Options
Online  
Course Fee(s)
Course Fee non-credit $195.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes
  • Instructor: Marion Williams
  • Course Format: Online, self-paced
  • Course Duration: October 7 to November 1, 2024. This is a 4-week course.
  • Access to Course: An invitation into the online classroom will be emailed to you typically the Wednesday prior to the start of the course. If you haven’t received the invite by the following morning, you can forward the confirmation email to info@ugotclass.org for a prompt resend.