Microsoft Power BI Course

Create Beautiful Dashboard Reports Using Power BI Desktop

Live Power BI Training (Virtual or On-site at Your Office)

Our standard Power BI course is 3 ½ hours in length.   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.  

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.  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, unleash the capabilities of Power BI Desktop as you discover how to craft dynamic, interactive reports from Excel or other data sources. Learn to seamlessly publish and share these reports, empowering your colleagues to view and interact with the data.

Accordion Content

Dates & Times

Fri Oct 18, 2024 (1:30pm to 5pm)

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.

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!

ezgif.com-webp-to-png

Excel Course 6B
Using Power Query

$ 350 per person / 7 hours

If you find yourself frequently updating or appending datasets, or grappling with sluggish files laden with lookup formulas, it’s high time to harness the power of Excel’s Power Query. Discover how to seamlessly link to source data, mold it to your specifications, and generate insightful reports, such as PivotTables.

Accordion Content

Dates & Times

Mon Aug 19, 2024 (9am 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.
 
NOTE: this is a full-day topic list.  For this half day course, topics will be covered as time permits.
 
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

$ 175 per person / 3 ½ hours

Master the intricacies of Excel’s Power Pivot tool to efficiently navigate the Data Model. Whether your data originates from Excel files or other sources, this course empowers you to grasp relationships fully and construct adaptable PivotTable formulas using the DAX language.

Accordion Content

Dates & Times

Wed Sep 4, 2024 (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 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