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 course is 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 our 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
Building Reports

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.

Register

Accordion Content

Dates & Times

Wed May 27, 2026 (9am to 4pm)
Mon Aug 10, 2026 (9am to 4pm)
Thu Nov 5, 2026 (9am to 4pm)

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

Course Topics

Working with Data
Link to a Data Source
Model the Data
 
Report Design
Themes, Shapes, Images, Text Boxes
Visuals (Column, Bar, Tree Map, Ribbon, Cards, Pie/Donut, Map, Line/Area, Waterfall, Table, Matrix, and Slicers)
Change Format Settings
Using Filters
Cross highlighting & Cross filtering
Custom Tooltips
Add Quick Measures
 
Publish Reports
Publish & Share a Report
Semantic Model Settings
Add Report to Teams or PowerPoint
Create Excel PivotTables from Model
 
Note: A basic understanding of Power Query may be necessary, depending on your data. This course focuses on designing reports in Power B, 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).
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 our standard Power BI course or build your own custom course.

Get in Touch!
Accordion Content

Standard Power BI Course

This course 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 our Power BI course? 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.

Register

Accordion Content

Dates & Times

Fri Apr 24, 2026 (9am to 4pm)
Tue Oct 6, 2026 (9am to 4pm)

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

Course Topics

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 Course 5).
 
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.

Register
Accordion Content

Dates & Times

Please contact us for dates

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

Course Topics

To effectively participate in this course, you should already know the topics in Excel Course 6A. Knowledge of Course 6B is very helpful, but not required.

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

(See More Clients & Testimonials)

BeFunky-design (67)
grey7 (1) (3)
grey10
grey9 (1) (1)
grey1 (1) (1)
grey3 (1)
grey5
grey11
grey14
grey5 (1)
BeFunky-design (67)
grey7 (1) (3)
grey10
grey9 (1) (1)
grey1 (1) (1)
grey3 (1)
grey5
grey11
grey14
grey5 (1)
BeFunky-design (67)
grey7 (1) (3)
grey10
grey9 (1) (1)
grey1 (1) (1)
grey3 (1)
grey5
grey11
grey14
grey5 (1)
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
Register