UGotClass: Intermediate Power BI


Course number : 1120096    ID : 23595    Section Number : 01E

« back to classes page
Learn@Home: Online, on your own time
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.

Agenda

Unit 1: Power Query
-Review the ETL Process
-Insert columns using different methods
-Group, Summarize, Pivot, and UnPivot data
-Merge and Append queries

Unit 2: Data Modeling
-What Data Modeling is
-Modeling Options
-Create and manage relationships
-Create Date table

Unit 3: DAX
-Introduction to DAX
-Calculate columns and measures
-Time Intelligence functions
-Quick Measures

Unit 4: Reports
-Filters versus Slicers
-Visual Hierarchies and Drill downs
-Drillthrough
-Define visual interactions
-Apply conditional formatting

No discounts or promotions can be applied to this class.
 
Add To Cart » Send to Friend »

Class Details

Session(s)
Online 24/7

Location
NA - Online

CEUs : 1.6

 

Notice

Please read:  Learn@Home: Online, on your own time - This class is 100% online. You do not need to be on your computer or device at a specific day or time. Reliable internet access and a computer are required. You will receive information via email on how to access your online classroom.

Tuition:  $195.00

Schedule Information

Date(s) Class Days Times Location Instructor(s)
10/5/2026 - 10/30/2026 Online 24/7 12:00 AM - 12:00 AM N/A - Online

Featured Classes

  • No Featured Classes today.

You may also be interested in these classes

Recommended Classes