Select Page

Microsoft Power BI Training | Power BI Introduction Level Training Course



Course Fee: CAD 

Fee: $800

Reserve your seat: $50  Non-refundable. To be refunded if PMVISION cancels the class.

Remainder:   Due one week before the start date

Upcoming Classes (Online)

Limited seats ( 6-8 attendees by session- Reserve your seat

Thu-Fri (June 06-07) (10 a.m.- 5:00 p.m. EST)

Microsoft Power BI Training | Power BI Introduction Level Training Classes


Course:                Microsoft Power BI Training Course

Training Type:   Classroom Training – Downtown Toronto & Online

Course Level:      Introduction Level

Number of students per session:  Our class sizes are typically 4-6 students per session. Our classes are intentionally kept small to foster more interaction between the instructor and students. We limit classes to a maximum of six (6) students unless we are teaching a private group or organization. Each student is provided with a laptop(Windows)

Locations:    Downtown Toronto ( 1 Yonge St, Suite 1801- Executive Boardroom ). ( 1 Yonge St),  Also, we offer the course in Mississauga,  Scarborough, Oakville, Hamilton & Barrie. Mississauga ( 55 Village Centre Pl, Mississauga, ON L4Z 1V9).  Barrie (92 Caplan Ave, Barrie ON L4N 9J2)  or ( at Georgian College (One Georgian Dr. Barrie, ON L4M 3X9).  The training is also offered at other locations including Scarborough, Hamilton, Ajax, Burlington, Niagara Falls, Ottawa &  Montreal. Please contact to discuss an alternate course location.

Duration:            1 weekend: Sat-Sun ( 10 AM- 4: 30 PM) .  Or Weekdays: 2 days ( 10 AM- 4: 30 PM)

Special Offers:   Sign up with a friend and save 5% each  – Sign up with 2 friends and save 10%

Corporate Training:  Contact us for special offers ( Training at our location or on-site at your location, anytime, anywhere). We can deliver the training to anywhere within Toronto GTA and the surrounding area including Oakville, Hamilton, Pickering, Burlington, Oshawa, Ajax, Guelph, Milton, Whitby, Newmarket, Niagara Falls, and Burlington.


Course Description:

Power Bi is a cloud-based service provided by Microsoft to help you gain intelligent insight from your data.  This Microsoft Power BI training course aims to familiarize subscribers to Power BI with the key features and operations of the Power BI service and with the use of Power BI Desktop to prepare reports.

Delegates will learn how to connect to local data sources and online services; customize and transform data sources to suit their requirements; model data by creating relationships, calculated columns, and measures; create reports using a wide variety of visualizations; publish reports to the Power BI service; distribute reports and dashboards both internally and to a wider audience; and schedule automatic refreshes of their datasets.

Power BI Training Course Outline

Getting started

  • The key components of Power BI; What is Power BI Desktop; The Power BI service; Power BI free vs Power BI Pro; Power BI vs Excel add-ins; Dashboards, reports, and datasets

Connecting to software services

  • Understanding content packs for services; Google Analytics content pack; Salesforce content pack; Microsoft Dynamics CRM content pack

Getting data into Power BI

  • Connecting to data sources in the Power BI service; Connecting to data sources in Power BI Desktop; Importing excel workbooks; Importing Access databases; Connecting to SQL Server

Cleaning up and transforming data

  • Using the Query Editor; Creating a query; Understanding query steps; Automatically generated steps; Removing query steps; Modifying query steps; Renaming columns; Reordering and removing columns; Changing data types; The close & apply command

Data Modeling

  • Working in data view; Working in relationship view; Auto-detection of table relationships; Creating table relationships manually; Setting cardinality; Cross filter direction

Using DAX

  • Creating Calculated columns; Creating measures; Understanding row context; Understanding filter context; The SUMX function; The CALCULATE function; The ALL function; The FILTER function; Using time intelligence functions

Creating reports

  • Working in report view; Creating tables and key metrics; Working with matrixes; Filtering data with slicers

Creating visualizations

  • Creating column and bar charts; Creating line and area charts; Creating scatter charts; Treemap visualizations; Using charts as slicers; Using maps with geographical data; Using custom visuals in your reports

Publishing content

  • Publishing Power BI Desktop reports; Printing and exporting dashboards and reports; Creating Groups in the Power BI service; Creating content Packs; Assigning groups to content packs; Sharing dashboards with your organization; Publishing reports to the web; Embedding a report in a web page

Creating Power BI Mobile Content

  • Optimizing visuals for small viewports; Creating a phone version of a dashboard; Creating phone-optimised reports

Consuming and customizing content

  • Browsing group content; Using content packs; Creating read-only versions; Using Quick Insights in Power BI; Creating dashboards from your reports; Querying with natural language; Creating custom Q & A suggestions

Refreshing content

  • Setting up a personal gateway; Customizing dataset refresh settings; Scheduling a refresh frequency; Setting up enterprise gateways; Managing enterprise gateways; Adding and removing data sources, Creating live connections to data

What you will Learn from the Power BI Training

  • You will learn how to connect to a wide variety of data sources, using both Power BI Desktop, and the Power BI Service.
  • You will be able to use the Query Editor to transform and morph data into the right format for your reporting purposes.
  • You will be able to perform complex data modeling operations using relationships, calculated columns, measures, and DAX expressions.
  • You will learn how to share dashboards and reports, with colleagues, business partners, and potential clients; and how to use Power BI’s sophisticated security features to control the exact content your audience can view.


Participants should have a strong knowledge of Excel 2010, 2013 2016, 2019, or 365 and have an understanding of data analysis.

Who Should Attend

Anyone who needs a solid understanding of the skills required to use Power BI.

Included Course Materials

  • Course workbook “PDF” including step-by-step course exercises complete with many actual screen captures and advanced project tips, exercises, and answers
  • Data files with all applicable Microsoft Excel files used in the course
  • Certificate of completion (PDF)


Delivery Methods:

  1.  Classroom Training: Downtown Toronto – Mississauga , Scarborough, Ottawa & Montreal.
  2.  Virtual Classroom
  3.  On-Site Training: At your location, anytime , anywhere
  4.  Corporate Training: Special rates for Corporate Training

Group Discount:

We provide special rate for groups :

  • 5% Discount for Group of 2
  • 10% Discount for Group of 3
  • 15% Discount for Group of 4

PMVISION reserves the right to postpone/cancel an event, or change the location of an event because of insufficient enrollments, instructor illness or force-majeure events.


Cancellation & Refund Policy

  • Reserve your seat fee:  Non Refundable. To be refunded if the class is cancelled by PMVISION
  • Reserve your seat is not “transferable”, if you wish to attend the class in anther date, you will have to reserve again
  • In case PMVISION  cancels an event, 100% refund will be paid to the delegate.
  • If the cancellation is done by the delegate within 48 hours of subscribing, 10%  will be deducted as administration fee.
  • If a cancellation is done by a delegate 7 days or more, prior to the event, 20% will be deducted as administration fee.
  • If a cancellation is done by a delegate 7 days or less, prior to the event, no refunds will be made
  • Bookings made at discounted prices ( Including Early Bird Booking) cannot be cancelled.
  • If you will have to travel to attend the course, please don’t make any travel arrangements until we confirm the class. We usually usually confirm the class by emails at least one week prior to the start date.


IMPORTANT: We recommend waiting to book any non-refundable travel until 1 week  before the start of class. PMVISION is not responsible for any loss incurred as a result of a canceled class. Please email: for any additional questions.

Certificate of Completion (PDF Format) is available upon attending the course.