Intermediate Power BI

Location Online - Self-paced

Term Fall, Summer

Cost $195.00

Intermediate Power BI Overview

Course Overview

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 Dates

May 4th-26th, 2026

Note: This program qualifies as one of the three core programs required to earn the Power BI Certificate.

Request Information

Agenda

Unit One – Power Query

Review the ETL Process
Insert columns using different methods
Group, Summarize, Pivot, and UnPivot data
Merge and Append queries

Unit Two – Data Modeling

What Data Modeling is
Modeling options
Create and manage relationships
Create date table

Unit Three – DAX

Introduction to DAX
Calculate columns and measures
Time Intelligence functions
Quick Measures

Unit Four – Reports

Filters versus Slicers
Visual Hierarchies and Drill downs
Drillthrough
Define visual interactions
Apply conditional formatting

All of Our Programs At-a-Glance

Looking for more options? Choose how you’d like to explore all programs—by catalog, upcoming dates or searchable listings.

View Our Online Program Listing

What's Next

Take the next step by requesting information or enrolling now!