Great Canadian Training Company color logo

Fundamentals of Power BI

What You'll Learn in Fundamentals of Power BI

Course Length:

12 hours (2 days)

Learning Objectives

Upon completing this course, participants will be able to:

  • Create an Excel Data Model using multiple tables
  • Create and manage relationships in Excel
  • 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
  • Format reports and pages
  • Create calculated columns and DAX Measures
  • Publish to Power BI Service
  • Create and share a dashboard

Target Student

This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.

Course Outline

Section 1: Excel Data Model

What Is the Excel Data Model?

What Is Power Query?

Accessing Power Pivot

Create Relationships Between Tables

Create Pivot Tables and Charts Using the Data Model

Section 2: Power BI and Excel

Explore Power BI Desktop and the Power BI Services

Compare Features of Excel and Power BI

Section 3: Power BI Desktop

Examine the Report, Data and Model Views

Connect to Excel Data Model

Connect to Excel Workbook, Text Files and Folders

Connect to Database

Connect to Web Data

Section 4: Power Query

Explore Power Query Editor Interface

Clean and Shape Data

Change Data Types

Merge and Append

Determine Join Type

Group, Summarize, Pivot and Unpivot

Section 5: Reports

Working with the Field and Visualizations Panes

Create Visualizations – Charts, Maps, Tables and Matrices

Customize Visualizations Using the Fields Pane

Create Visual and Page Filters

Create Slicers

Manage Report Pages

Export Report to PDF

Section 6: Introduction to DAX

Understand DAX Concepts

Create Calculations When Necessary

Create Measures

Section 7: Share and Collaborate

Publish from Power BI Desktop

Create Dashboards in Power BI

Use Q&A to Ask Questions

Share a Dashboard from Power BI

Use the Power BI Mobile App

Fundamentals of Power BI

Upcoming Classes

All Public classes are held online
with a live instructor
Dates Price Qty
June 26-27, 2024
9:00 AM to 4:00 PM ET
$1,295.00 Online
October 30-31, 2024
9:00 AM to 4:00 PM ET
$1,295.00 Online
January 14-15, 2025
9:00 AM to 4:00 PM ET
$1,295.00 Online
* Applicable taxes will be applied on checkout

I want to talk to someone about private or customized training

Have questions about this course? See below or reach out to our training coordinators.

Group of 4 or more? Consider private training

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Guaranteed to run classes
  • Learning Guarantee
  • Anytime after-training support for 30 days
  • Bilingual training, manuals & post-training support available

This course comes with

PDF Reference Guide

Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices

Can I customize my course?

Tailored Training

Your Reference Guide will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Use Your Own Files

You can include your own files in your training session to make it more applicable to your day-to-day role.