Skip to content

Power BI Certificate (Online at your own pace)


Adult Enrichment / Computers & Technology -
Online Certificates and Courses 2025

Gain insights into your data using business intelligence software – Power Business Intelligence. Power BI 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. Discover the process of creating interactive reports. Integrate financial, marketing, or any other source data in your accounting system, Excel, or on the Web. Streamline the data to what is needed using Power Query. Create charts, maps, and other visuals to see your data in real time. Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using relationships and DAX (Data Analysis Expressions). Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports and analyze your results. This certificate will enhance your skills in data analysis, giving you greater insight into your organization’s performance and allowing you to make more informed decisions. 

This Certificate must be taken in the following order:

  1. Introduction
  2. Intermediate
  3. Advanced  

Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ


Class Details:

Introduction to Power BI
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

Intermediate Power BI
Unit 1: Power Query
    Review the ETL Process
    Insert columns using different methods
    Group, Summarize, Pivot, and UnPivot data
    Merge and Append queries


Unit 2: Data Modeling
    What Data Modeling is
    Modeling Options
    Create and manage relationships
    Create Date table

Unit 3: DAX
    Introduction to DAX
    Calculate columns and measures
    Time Intelligence functions
    Quick Measures
Unit 4: Reports
    Filters versus Slicers
    Visual Hierarchies and Drill downs
    Drillthrough
    Define visual interactions
    Apply conditional formatting
Advanced Power BI
Unit 1: Power Query
    Utilize Column profile, distribution, and quality
    Perform fuzzy match
    Duplicate versus Reference queries
    Debug errors
Unit 2: Data Modeling
    What a Star Schema is
    Understand relationship types
    Manage relationships
Unit 3: DAX
    Understand contexts
    CALCULATE function
    COALESCE function
    Compute visual totals accurately
Unit 4: Reports
    Insert Objects
    Create Bookmarks
Instructor

Marion Williams


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.

OE-62120a-ugc

  Marion Williams


Online
Sun-Sat, Feb 3 - May 2
12:01 - 11:59 AM

Su
M
Tu
W
Th
F
Sa

Min Age   18 yr.

Price: $ 495 00
OE-62120b-ugc

  Marion Williams


Online
Sun-Sat, Apr 7 - Jun 27
12:01 - 11:59 AM

Su
M
Tu
W
Th
F
Sa

Min Age   18 yr.

Price: $ 495 00
Registration begins  
Jan. 7th
OE-62120c-ugc

  Marion Williams


Online
Sun-Sat, Jun 2 - Aug 29
12:01 - 11:59 AM

  No Class Aug 3


Su
M
Tu
W
Th
F
Sa

Min Age   18 yr.

Price: $ 495 00
Registration begins  
Jan. 7th
OE-62120d-ugc

  Marion Williams


Online
Sun-Sat, Sep 2 - Nov 28
12:01 - 11:59 AM

Su
M
Tu
W
Th
F
Sa

Min Age   18 yr.

Price: $ 495 00
Registration begins  
Jan. 7th