Loading...

Program Description

Gain insights into your data!  Power BI (business intelligence) is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free. 

In this course, you will discover how to quickly extract, transform, and load data with just a few clicks. You will create interactive visualizations (charts, maps, KPIs) to provide you with insights into your company’s data to make informed decisions. 

Upon successful completion of the course, you will:

  • Understand the components of Power BI Service and Power BI Desktop
  • Connect data from an Excel workbook, folder, Access database and the Web
  • Transform data using Power Query
  • Create and format Visualizations
  • Be able to deliver Format Reports and Pages

Learning Objectives:

  • Explain components of Power BI Service and Power BI Desktop
  • Learn how to download Power BI Desktop
  • Work with the Power Query interface
  • Create and format interactive visuals
  • Know how to share your reports

Course Outline

Unit 1: Overview
  • Power BI Components
  • Install Power BI Desktop (free software)
  • Getting started
Unit 2: Connect with Data Sources
  • Types of data sources
  • Import Excel and text files
  • Connect to databases (Access)
  • Import data from the Web
Unit 3: Transform Data
  • Introduction to Power Query
  • Shape data
  • Filter data
  • Understand the Data Model
Unit 4: Creating Reports
  • Overview
  • Create visuals
  • Format reports
  • Share your files

 

Loading...

Register - Select a section to enroll in

Program Title
Introduction to Power BI
Type
Workshop
Dates
Sep 08, 2026 to Oct 02, 2026
Delivery Methods
Program Fee(s)
Program Fee non-credit $195.00

Section Notes

Instructor: With over 20 years of IT and training experience, Marion Williams has been responsible for designing custom solutions using Access and Excel/VBA. As a trainer, Marion has delivered over 200 seminars to CPA associations across Canada. As technology evolved, Marion currently uses her skills to specialize in training Power BI, a tool used for business intelligence.

Marion earned the FLMI designation which is a comprehensive business education in the context of the insurance and financial services industry with a specialty in Information Technology.

Required fields are indicated by .