Power BI

Microsoft Power BI Courses

Create Beautiful Dashboard Reports Using Power BI Desktop

Build Power BI Reports Like a Pro!

Our live Power BI courses are delivered via Zoom and open to everyone, with real-time interaction through voice or chat.

Non-members can register for $350 per person. Members pay $0 per person – your organization can become a member starting at just $499/month (billed annually) and receive unlimited, company-wide access to all of our 50+ live public courses — no per-person fees, no limits, no hidden costs. One flat fee covers all the training your entire team needs for a full year.  Secure your membership today and enjoy unlimited learning for your workforce!

Prefer private training? We offer live sessions online or in person at your office. Choose a standard Power BI course, or tailor the content to focus on what matters most to your team. Get in touch for pricing or to book a time that works best for you.

New_Power_BI_Logo.svg

Power BI Desktop
Course 1: Getting Started

Course Fee:  Members: $ 0  /  Non-members: $ 350
Course Length:  6 hours

Get started with Power BI Desktop and learn how to turn your data into engaging, interactive reports. This course walks you through every step—from connecting to data and designing visuals to publishing and sharing reports your team can explore and interact with. It’s everything you need to confidently bring your insights to life.

Accordion Content

Dates & Times

Thu Nov 5, 2026 (9am to 4pm)
Fri May 21, 2027 (9am to 4pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Prerequisites

A basic understanding of Power Query may be necessary, depending on your data. This course focuses on designing reports in Power BI, not cleaning or preparing data. If you need Power Query training, you can learn it before or after this course in Excel Course 6B: Using Power Query (see below).

Course Topics

Working with Data
-Link to a Data Source
-Model the Data
 
Report Design
-Themes, Shapes, Images, Text Boxes
-Add Visualizations (column, tree map, donut, bar, maps, tables, slicer)
-Change Format Settings
-Use Filters
-Cross Highlight & Cross Filter
-Edit Interactions
 
Publish Reports
-Publish & Share a Report
-Semantic Model Settings
-Add Report to Teams or PowerPoint
-Create Excel PivotTables from Model
 
 
New_Power_BI_Logo.svg

Power BI Desktop
Course 2: More Visualizations

Course Fee:  Members: $ 0  /  Non-members: $ 350
Course Length:  6 hours

This course is designed for individuals who are already comfortable creating and publishing Power BI reports using Power BI Desktop. Building on those foundational skills, participants will explore additional visuals and features available in both Power BI Desktop and the Power BI Service.

Accordion Content

Dates & Times

Fri Jul 9, 2027 (9am to 4pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Prerequisites

Completion of Power BI Course 1, or equivalent knowledge, is needed. Participants must already be comfortable creating and publishing Power BI reports.

Course Topics

Visualizations
-Matrix
-Line / Area
-Ribbon
-Cards
-Waterfall
-Word Cloud
-Decomposition Tree
-Gage
 
Features
-Quick Measures
-Custom Tooltips
-Page Navigation Buttons
-Drill-Throughs
-Parameters
 
Power BI Service
-Create a Dashboard
-Workspaces
gear3

Private Training for Your Team

Private training is a course dedicated to your team only, on the date that works best for you. Choose one of our standard Power BI courses or build your own custom course.

Accordion Content

Standard Power BI Courses

These courses can be delivered to your team in a live online format, or in-person at your office.

Get in touch for pricing or to book the most convenient time for your team!

Build Your Own Course

Our team is happy to customize your sessions based on your unique needs. Simply select the topics you would like included in your course. 

Get in touch for pricing or to book the most convenient time for your team!

Take Your Power BI Skills Further

Already enrolled in Power BI Course 1? Great! That course focuses on building and designing reports.

To learn how to transform and model data using Power Query, or unlock advanced insights with DAX formulas in Power Pivot—check out the additional live courses listed below. These targeted sessions are designed to complement your Power BI training and deepen your analytical capabilities

Excel

Excel Course 6B
Using Power Query

Course Fee:  Members: $ 0  /  Non-members: $ 350
Course Length:  6 hours

If you’re constantly updating spreadsheets or battling slow files packed with lookup formulas, it’s time to let Power Query do the heavy lifting. This course shows you how to connect to your source data, shape it to fit your needs, and create smart, streamlined reports like PivotTables—without all the hassle. You’ll also learn best practices for structuring data so it’s Power BI-ready, giving you a strong foundation for building interactive dashboards and reports in Power BI later.

Accordion Content

Dates & Times

Tue Oct 6, 2026 (9am to 4pm)
Thu May 27, 2027 (9am to 4pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Excel Course 2B and Excel Course 5 topics. You must understand how to set up a valid database, the Table feature, and basic PivotTables.

Course Prerequisites

To effectively participate in this course, you will need to understand the concept of setting up a valid database, the Table feature and basic PivotTables (topics from Excel Course 5).
 
Course Topics
 
Getting Data
-Connect to Excel or Other Data
-Load Queries into Excel / Edit Queries
-Refresh / Refresh Options
-Reference / Duplicate Queries
-Merge Datasets
-Use Group By
-Update Names (File, Sheet, Table, Column)
 
Basic Column Transformations
-Transform vs Add Column
-Remove, Duplicate, Format
-Change Case
-Work with Dates
-Extract, Merge, Split
-Fill & Replace Values
-Basic Calculations
-Conditional Columns
 
Other Features
-Data Types
-Sort & Filter  
-Working with Steps
-Remove Duplicates
-Data Statistics
-Find & Fix Data Errors
Excel

Excel Course 6C
Using Power Pivot

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Learn how to work smarter with Excel’s Power Pivot tool and get confident using the Data Model. This course shows you how to connect data from multiple sources, understand relationships, and write PivotTable formulas using DAX to analyze your data more effectively.

Accordion Content

Dates & Times

This course is offered on demand. Dates will be scheduled when sufficient interest is received.

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Prerequisites

You must already know the topics in Excel Course 6A. Knowledge of Excel Course 6B is helpful but not required.

Course Topics

Overview
-Quick Review of Relationships
-Quick Review of the Data Model
-The PowerPivot Window

More About Relationships
-Relationships in Diagram view
-Snowflake vs Star
-How Relationships Flow
-Hide Fields or Tables
-Creating Hierarchies
 
Introduction Dax
-Adding Calculated Columns
-Implicit vs Explicit Measures
-Creating Explicit Measures
 
Calendar Tables
-Why Not Group by Dates?
-Create a Calendar Table in Power Pivot
-Create Calendar Table in Excel
-Dynamic Calendars in Power Query

Our Clients Love Us

We really enjoyed our courses with Gump Training. All the trainers were very professional, incredibly knowledgeable and they made learning fun. Especially loved the training in OneNote, it's dramatically improved our productivity in project management. Thanks for the great training!
Cynthia Grice
TJX Canada
All our employees were always very happy with the training we received from Gump. Excel can be a dry topic, but they made it fun and easy to follow and were very accommodating in allowing us to choose topics for many custom courses this past year. They also provide very professional textbooks for all of their courses.
Lena Sun
Lafarge Canada Inc.
Gump provided excellent training for a variety of skill levels. Michele was willing to travel to our Mississauga and Sudbury facilities and everyone enjoyed her thoroughness and flexibility with learning styles. I'm often asked when the next session will be and I was quickly able to see people apply their knowledge.
Eamonn Doorly
Epiroc
Michele is an excellent instructor and pleasant to deal with. She's very well spoken and explained the steps in a way we were all able to understand and took the extra time if someone needed more help. She also kept it light, entertaining and funny. I highly recommend GUMP for any Microsoft Office training!
Ian Stewart
Detour Gold