Microsoft Power BI Course

Create Beautiful Dashboard Reports Using Power BI Desktop

Online / In-Person Power BI Training

Our standard Power BI course is 3 ½ hours in length and includes a PDF reference manual and 30 days of technical support.   The Public course (open to anyone) is $ 175 per person and is delivered online (live and fully interactive).  Speak with the Instructor at any time during the course or use the Chat and Q&A features.  (Learn more about how our online training works.) 

Private training is available for your team in a live online format or in-person at your office, in your company meeting room.   Choose our standard Power BI course, or build your own custom course by letting us know the specific topics you would like included.  (Learn more about build your own courses.)  Get in touch for pricing or to book the most convenient time for your team!

power bi logo2

Power BI Desktop
Building Reports

$ 175 per person / 3 ½ hours

In this course you will learn how to use Power BI Desktop to create interactive reports from Excel or other data and then publish or share them with your colleagues so they can view and interact with them.

Dates & Times

This course will be offered in 2024

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

Course Topics

Overview
-How to Install Power BI Desktop
-Getting Data
-Transform Data in Power Query
-Relationships
-Refresh
 
Setup Reports
-Add Fields / Visualizations
-Move, Size, Filter
-Change Formats & Settings
-Add Quick Measures
 
Deliver Reports
-Save a Report
-Publish a Report
-Share a Report
-Add a Teams Tab with a Report
-Embed Live Data in PowerPoint
 
You will need knowledge of the Power Query editor prior to this course (Excel Course 6B).  Knowledge of Power Pivot DAX is also helpful (Excel Course 6C), but not required.  Both courses are shown 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.

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!

ezgif.com-webp-to-png

Excel Course 6B
Using Power Query

$ 150 per person / 3 ½ hours

If you’re constantly updating or appending datasets, or working in slow files filled with lookup formulas, then it’s time to learn Excel’s Power Query to link to source data, shape it the way you want, and then report on it (e.g. in PivotTables).   
 

Dates & Times

Wed Sep 13 (1:30pm to 5pm)

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 Courses 2B and 5).  Knowledge of Course 6 and 6A is helpful, but not required.
 
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
-Extract, Merge, Split / Fill & Replace Values
-Change Case / Work with Dates
-Basic Calculations / Conditional Columns
 
Other Features
-Data Types / Sort & Filter  
-Working with Steps
-Remove Duplicates
-Data Statistics / Find & Fix Data Errors
ezgif.com-webp-to-png

Excel Course 6C
Using Power Pivot

$ 150 per person / 3 ½ hours

Learn how to effectively work with The Data Model using Excel’s Power Pivot tool. Whether the data you use comes from Excel files, or other sources, this course will teach you how to fully understand relationships and build flexible PivotTable formulas using the DAX language.

Dates & Times

Wed Oct 18 (9am to 12:30pm)

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

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