Great Canadian Training Company color logo

Becoming a Pro with Power BI

Becoming a Pro with Power BI

Course Length:

12 hours (2 days)

Learning Objectives

Upon completing this course, participants will be able to:


  • Explain the ETL process
  • Understand Data Modeling
  • Define and manage relationships
  • Use Quick measures and Time Intelligence functions
  • Create reports using visual Hierarchies, Drill Downs and Slicers
  • Create Bookmarks
  • Use Parameters, filters, and Conditional formatting in reports
  • Work with additional built-in analytical tools

Target Student

The course is targeted towards Business Analysts, Business Intelligence Developers, and Reporting Professionals.

Course Outline

Section 1: Power Query Editor

Review the ETL Process

Column Profile, Distribution, and Quality

Insert Columns Using Different Methods

Work with Query Parameters

Debug Errors

Fuzzy Match

Duplicate Versus Reference Queries

Set Query Options

Query Dependencies


Section 2: Data Modeling

What Is Data Modeling?

Model Relationships

Modeling Options

Convert Flat File into Data Model

What Is Star Schema?

Understand Relationship Types

One to One

Many to Many

Active Versus Inactive

Bi-directional


Section 3: DAX

Quick Measures

Time Intelligence Functions

Create Date Table

Work with Time Dependent Data

Compute Visual Totals Accurately 


Section 4: Reports

Filters Versus Slicers

Creating Hierarchies

Visual Hierarchies and Drill Downs

Drill Through

Apply Conditional Formatting

Define Visual Interactions

Use Analytics Pane

Insert Objects

Create Bookmarks

Create Key Influencer and Other New Visuals

Analyze Visual Data

Becoming a Pro with Power BI

Upcoming Classes

All Public classes are held online
with a live instructor
Dates Price Qty
March 25-26, 2024
9:00 AM to 4:00 PM ET
$1,495.00 Online
July 23-24, 2024
9:00 AM to 4:00 PM ET
$1,495.00 Online
October 30-31, 2024
9:00 AM to 4:00 PM ET
$1,495.00 Online
January 27-28, 2025
9:00 AM to 4:00 PM ET
$1,495.00 Online
* Applicable taxes will be applied on checkout

I want to talk to someone about private or customized training


Have questions about this course? See below or reach out to our training coordinators.

Group of 4 or more? Consider private training

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Guaranteed to run classes
  • Learning Guarantee
  • Anytime after-training support for 30 days
  • Bilingual training, manuals & post-training support available

This course comes with

PDF Reference Guide

Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices



Printed Reference Guide

Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference


Can I customize my course?
OF COURSE!

Tailored Training

Your Reference Guide will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Use Your Own Files

You can include your own files in your training session to make it more applicable to your day-to-day role.