CA flag CA
888-843-8733

Introduction to Power BI Training

Course 1360 Advantage Plan Course

  • Duration: 3 days
  • Labs: Yes
  • Language: English
  • 17 PMI PDUs
  • Level: Foundation

This Introduction to Power BI Training will give you all the skills you need to jump-start your Power BI journey. It discusses in depth the industry-recognized steps from raw data to detailed analysis via five main stages:

  • Loading data into Power BI from a wide range of data sources, such as CSV and XLS files
  • Transforming data using Data Analysis Expressions (DAX), M, and Power Query languages
  • Creating and extending a comprehensive data model with DAX
  • Visualising data in Power BI desktop using built-in tools
  • Sharing and collaborating with the Power BI service or Power BI server

Introduction to Power BI Training Delivery Methods

  • In-Person

  • Online

Introduction to Power BI Training Information

  • In this course, you will:

    • Create interactive visualisations to deliver business insights.
    • Extract business intelligence by using DAX, M, and Power Query.
    • Share Datasets, Reports, and Dashboards in the Power BI Service.
    • Pre-format and import data from an Excel Report using Power Query and M.
    • Add value with measures, calculated columns, and calculated tables using DAX.
    • Import data from relational databases and integrate it with other data sources.
    • Profile, shape, and filter tables to prepare for analyses by fixing data issues.
    • Integrate data from CSV files and Excel Workbooks.
    • Explore and extend a Power BI data model.

  • Training Prerequisites

    None.

Introduction to Microsoft Power BI Training Course Outline

  • Visual analysis and visual analytics
  • Power BI Infrastructure
  • Loading Data
  • Introduction to Power BI Desktop

Hands-On Exercise 1.1 Loading and Visualising data

  • Using Power Query to clean, transform and load data
  • Profiling your data
  • Resolve data quality issues
  • Apply user-friendly names to Queries, tables, and columns
  • Import data from an Excel formatted report

Hands-On Exercise 2.1 Transforming Data with Power Query

Hands-On Exercise 2.2 Appending, Merging, and Combining Queries

  • Understand the role of the Data Model in Power BI
  • Create table relationships
  • Understand Cardinality and Cross Filtering
  • Discuss Star and Snowflake schema
  • Create a Date Dimension
  • Build a Data Model from multiple Data sources

Hands-On Exercise 3.1 Creating a Data Model

  • Discuss Report settings
  • Choosing the right visualisations
  • Creating, formatting, and styling your reports
  • Using Hierarchies and Drilldown
  • Utilising Slicers and Filters
  • Adding Custom Visualisations

Hands-On Exercise 4.1 Creating Reports Part 1

Hands-On Exercise 4.2 Creating Reports Part 2

Hands-On Exercise 4.3 Creating Reports Part 3

  • Gain an Introduction to DAX
  • Differentiate between Calculated Columns and Measures
  • Create Calculated Columns
  • Create Measures
  • Understand Filter and Row context
  • Understand the power of the Calculate function

Hands-on Exercise 5.1 Introduction to DAX

Optional Hands-on Exercise 5.2 Intermediate Level DAX

  • Discuss the Power BI Service and Power BI Server
  • Understand the main components of the Power BI Service
  • Publish a Power BI Project to the Power BI Service
  • Share Reports
  • Build and Share Dashboards

Hands-On Exercise 6.1 Collaboration and Sharing in the Power BI Service

Select Commercial or Government Pricing

$2,885

  • 3-day instructor-led training course

  • After-course computing sandbox included

  • After-course coaching available

  • Learning Tree end-of-course exam included

Would you like to take this course as a team?
  • Oct. 14 - 16 12:00 p.m. - 7:30 p.m. EDT
    Bellevue, WA or Virtual
  • Guaranteed-to-Run - You can rest assured this class will not be canceled. Delivery format is subject to change – please call Customer Service if you have any questions.
    Oct. 21 - 23 9:00 a.m. - 4:30 p.m. EDT
    Herndon, VA or Virtual
  • Oct. 28 - 30 10:00 a.m. - 5:30 p.m. EDT
    Austin or Virtual
  • Nov. 4 - 6 9:00 a.m. - 4:30 p.m. EST
    Washington, DC or Virtual
  • Nov. 18 - 20 9:00 a.m. - 4:30 p.m. EST
    Ottawa or Virtual
  • Nov. 23 - 25 9:00 a.m. - 4:30 p.m. EST
    Toronto or Virtual
  • Dec. 2 - 4 9:00 a.m. - 4:30 p.m. EST
    New York or Virtual
  • Dec. 9 - 11 11:00 a.m. - 6:30 p.m. EST
    Aurora, CO or Virtual
  • Jan. 13 - 15 9:00 a.m. - 4:30 p.m. EST
    Herndon, VA or Virtual
  • Jan. 20 - 22 10:00 a.m. - 5:30 p.m. EST
    Austin or Virtual
  • Jan. 27 - 29 9:00 a.m. - 4:30 p.m. EST
    Washington, DC or Virtual
  • Feb. 3 - 5 9:00 a.m. - 4:30 p.m. EST
    Ottawa or Virtual
  • Feb. 17 - 19 9:00 a.m. - 4:30 p.m. EST
    Toronto or Virtual
  • Mar. 3 - 5 9:00 a.m. - 4:30 p.m. EST
    New York or Virtual
  • Apr. 7 - 9 9:00 a.m. - 4:30 p.m. EDT
    Herndon, VA or Virtual
  • Apr. 14 - 16 10:00 a.m. - 5:30 p.m. EDT
    Austin or Virtual
  • Apr. 21 - 23 9:00 a.m. - 4:30 p.m. EDT
    Washington, DC or Virtual
  • Apr. 28 - 30 9:00 a.m. - 4:30 p.m. EDT
    Ottawa or Virtual
  • May 5 - 7 12:00 p.m. - 7:30 p.m. EDT
    San Francisco or Virtual
  • May 12 - 14 9:00 a.m. - 4:30 p.m. EDT
    Toronto or Virtual
  • May 26 - 28 9:00 a.m. - 4:30 p.m. EDT
    New York or Virtual
  • Jun. 2 - 4 11:00 a.m. - 6:30 p.m. EDT
    Aurora, CO or Virtual
  • Jun. 28 - 30 9:00 a.m. - 4:30 p.m. EDT
    Herndon, VA or Virtual
  • Jul. 7 - 9 10:00 a.m. - 5:30 p.m. EDT
    Austin or Virtual
  • Jul. 14 - 16 9:00 a.m. - 4:30 p.m. EDT
    Washington, DC or Virtual
  • Jul. 28 - 30 9:00 a.m. - 4:30 p.m. EDT
    Ottawa or Virtual
  • Aug. 4 - 6 9:00 a.m. - 4:30 p.m. EDT
    Toronto or Virtual
  • Aug. 11 - 13 9:00 a.m. - 4:30 p.m. EDT
    New York or Virtual
  • Sep. 15 - 17 9:00 a.m. - 4:30 p.m. EDT
    Herndon, VA or Virtual
  • Sep. 22 - 24 10:00 a.m. - 5:30 p.m. EDT
    Austin or Virtual
  • Oct. 6 - 8 9:00 a.m. - 4:30 p.m. EDT
    Washington, DC or Virtual

Scroll to view additional course dates

$2,539

  • 3-day instructor-led training course

  • After-course computing sandbox included

  • After-course coaching available

  • Learning Tree end-of-course exam included

Would you like to take this course as a team?
  • Oct. 14 - 16 12:00 p.m. - 7:30 p.m. EDT
    Bellevue, WA or Virtual
  • Guaranteed-to-Run - You can rest assured this class will not be canceled. Delivery format is subject to change – please call Customer Service if you have any questions.
    Oct. 21 - 23 9:00 a.m. - 4:30 p.m. EDT
    Herndon, VA or Virtual
  • Oct. 28 - 30 10:00 a.m. - 5:30 p.m. EDT
    Austin or Virtual
  • Nov. 4 - 6 9:00 a.m. - 4:30 p.m. EST
    Washington, DC or Virtual
  • Nov. 18 - 20 9:00 a.m. - 4:30 p.m. EST
    Ottawa or Virtual
  • Nov. 23 - 25 9:00 a.m. - 4:30 p.m. EST
    Toronto or Virtual
  • Dec. 2 - 4 9:00 a.m. - 4:30 p.m. EST
    New York or Virtual
  • Dec. 9 - 11 11:00 a.m. - 6:30 p.m. EST
    Aurora, CO or Virtual
  • Jan. 13 - 15 9:00 a.m. - 4:30 p.m. EST
    Herndon, VA or Virtual
  • Jan. 20 - 22 10:00 a.m. - 5:30 p.m. EST
    Austin or Virtual
  • Jan. 27 - 29 9:00 a.m. - 4:30 p.m. EST
    Washington, DC or Virtual
  • Feb. 3 - 5 9:00 a.m. - 4:30 p.m. EST
    Ottawa or Virtual
  • Feb. 17 - 19 9:00 a.m. - 4:30 p.m. EST
    Toronto or Virtual
  • Mar. 3 - 5 9:00 a.m. - 4:30 p.m. EST
    New York or Virtual
  • Apr. 7 - 9 9:00 a.m. - 4:30 p.m. EDT
    Herndon, VA or Virtual
  • Apr. 14 - 16 10:00 a.m. - 5:30 p.m. EDT
    Austin or Virtual
  • Apr. 21 - 23 9:00 a.m. - 4:30 p.m. EDT
    Washington, DC or Virtual
  • Apr. 28 - 30 9:00 a.m. - 4:30 p.m. EDT
    Ottawa or Virtual
  • May 5 - 7 12:00 p.m. - 7:30 p.m. EDT
    San Francisco or Virtual
  • May 12 - 14 9:00 a.m. - 4:30 p.m. EDT
    Toronto or Virtual
  • May 26 - 28 9:00 a.m. - 4:30 p.m. EDT
    New York or Virtual
  • Jun. 2 - 4 11:00 a.m. - 6:30 p.m. EDT
    Aurora, CO or Virtual
  • Jun. 28 - 30 9:00 a.m. - 4:30 p.m. EDT
    Herndon, VA or Virtual
  • Jul. 7 - 9 10:00 a.m. - 5:30 p.m. EDT
    Austin or Virtual
  • Jul. 14 - 16 9:00 a.m. - 4:30 p.m. EDT
    Washington, DC or Virtual
  • Jul. 28 - 30 9:00 a.m. - 4:30 p.m. EDT
    Ottawa or Virtual
  • Aug. 4 - 6 9:00 a.m. - 4:30 p.m. EDT
    Toronto or Virtual
  • Aug. 11 - 13 9:00 a.m. - 4:30 p.m. EDT
    New York or Virtual
  • Sep. 15 - 17 9:00 a.m. - 4:30 p.m. EDT
    Herndon, VA or Virtual
  • Sep. 22 - 24 10:00 a.m. - 5:30 p.m. EDT
    Austin or Virtual
  • Oct. 6 - 8 9:00 a.m. - 4:30 p.m. EDT
    Washington, DC or Virtual

Scroll to view additional course dates

Speak with a Learning Consultant
* Required Fields

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Contact Us

Introduction to Power BI Training FAQs

There are no prerequisites for attending this course. However, it is recommended that participants have basic knowledge of Excel and data analysis.

The Introduction to Power BI Training Course is available in two delivery methods: in-person and online. In-person training is conducted in a physical classroom, while online training is conducted virtually through a video conferencing platform.

This course covers the following topics:

  • Power BI Overview
  • Transforming Data
  • Creating a Data Model
  • Visualizing Your Data
  • Introduction to DAX, Calculated Columns, and Measures
  • Collaboration and Sharing

Participants will also have the opportunity to engage in hands-on exercises that will reinforce the concepts covered in the course.

Throughout the course, you will access data from various data sources and create Reports using the in-built visuals. You will also be shown how to format those visuals for maximum effect and how to import custom visuals to extend your reporting capability. 

You will gain an introduction to the M and DAX languages and then publish your masterpiece to a workspace in the Power BI Service, creating Dashboards, sharing Reports and Dashboards with colleagues, and concluding with scheduling a data refresh.

The software and licenses used during the course will only be available for the duration of the training. However, participants will be provided with a Power BI license for a period of time after the training is complete.

By the end of the course, participants will have the skills necessary to load data into Power BI from a variety of sources, transform data using DAX, M, and Power Query languages, create and extend a comprehensive data model, visualize data in Power BI desktop using built-in tools, and share and collaborate with the Power BI service or Power BI server.

Participants will also be able to create interactive visualizations to deliver business insights and extract business intelligence by using DAX, M, and Power Query.

Related Courses

  • Learning Tree
    Tableau Visual Analytics Training

    This Tableau Visual Analytics course will teach you to create interactive visualisations to deliver business insights using real-time data models.

    Foundation
    3 days
    Online or In-class
    Starts from $2,885
  • Learning Tree
    Advanced Tableau Training

    Take your Tableau skills to the next level with our Advanced Tableau course. Harness the full potential of data visualization and analysis.

    Advanced
    3 days
    Online or In-class
    Starts from $2,885
  • Learning Tree
    Designing Data Models in Excel for Power BI Reports Training

    Learn to design BI Data Models for Power BI or Excel dashboards in our Designing Data Models in Excel for Power BI Reports Training.

    Intermediate
    3 days
    Online or In-class
    Starts from $2,885
  • Learning Tree
    Introduction to Data Analytics

    This Data Analytics Introduction provides a clear understanding of data analytics's purpose, tools, and techniques.

    Foundation
    3 days
    Online or In-class
    Starts from $2,885
  • Learning Tree
    Data Governance for AI-Enabled Organizations

    Learn Data Governance & assess Data Maturity with IEC/ISO 38505 standards. Get trained now!

    Intermediate
    3 days
    Online or In-class
    Starts from $2,885
  • Learning Tree
    Copilot in Power BI Training

    Learn AI integration in Power BI, from data loading to visualization, with hands-on exercises. No prior AI experience needed.

    Intermediate
    1 day
    Online or In-class
    Starts from $1,075