Home
Courses
Introduction to Power BI Training

Introduction to Power BI Training

Course 1360

Duration: 3 days
Labs: Yes
Language: English
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
Visualizing 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 visualizations 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

Chapter 1: Power BI Overview

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

Hands-On Exercise 1.1 Loading and Visualizing data

Chapter 2: Transforming 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

Chapter 3: Creating a Data Model

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

Chapter 4: Visualizing your Data

Discuss Report settings
Choosing the right visualizations
Creating, formatting, and styling your reports
Using Hierarchies and Drilldown
Utilizing Slicers and Filters
Adding Custom Visualizations

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

Chapter 5: Introduction to DAX, Calculated Columns and Measures

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

Chapter 6: Collaboration and Sharing (Publishing Reports and Creating Dashboards)

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

Get This Course 19 530 kr

3-day instructor-led training course
After-course computing sandbox included
After-course coaching available
Learning Tree end-of-course exam included

Include dates with afternoon start times

#1360

Guaranteed to Run - you can rest assured that the class will not be cancelled.
nov 25 - 27 15:00 - 22:30 CET

Virtual
Guaranteed to Run - you can rest assured that the class will not be cancelled.
dec 4 - 6 15:00 - 22:30 CET

Virtual
Guaranteed to Run - you can rest assured that the class will not be cancelled.
dec 18 - 20 15:00 - 22:30 CET

Virtual
jan 8 - 10 15:00 - 22:30 CET

Washington, DC or Virtual
jan 15 - 17 16:00 - 23:30 CET

Austin or Virtual
Guaranteed to Run - you can rest assured that the class will not be cancelled.
jan 22 - 24 15:00 - 22:30 CET

Herndon, VA or Virtual
jan 22 - 24 9:00 - 16:30 CET

Stockholm or Virtual
jan 22 - 24 10:00 - 17:30 CET

London or Virtual
Guaranteed to Run - you can rest assured that the class will not be cancelled.
jan 29 - 31 15:00 - 22:30 CET

Ottawa or Virtual
feb 5 - 7 15:00 - 22:30 CET

New York or Virtual
feb 12 - 14 15:00 - 22:30 CET

Toronto or Virtual
Guaranteed to Run - you can rest assured that the class will not be cancelled.
feb 19 - 21 15:00 - 22:30 CET

Washington, DC or Virtual
mar 5 - 7 16:00 - 23:30 CET

Austin or Virtual
Guaranteed to Run - you can rest assured that the class will not be cancelled.
mar 12 - 14 14:00 - 21:30 CET

Herndon, VA or Virtual
mar 19 - 21 14:00 - 21:30 CET

Ottawa or Virtual
mar 26 - 28 14:00 - 21:30 CET

Toronto or Virtual
mar 26 - 28 9:00 - 16:30 CET

Stockholm or Virtual
mar 26 - 28 10:00 - 17:30 CET

London or Virtual
apr 9 - 11 15:00 - 22:30 CEST

New York or Virtual
apr 23 - 25 15:00 - 22:30 CEST

Herndon, VA or Virtual
apr 30 - maj 2 9:00 - 16:30 CEST

Stockholm or Virtual
apr 30 - maj 2 10:00 - 17:30 CEST

London or Virtual
apr 30 - maj 2 16:00 - 23:30 CEST

Austin or Virtual
maj 7 - 9 15:00 - 22:30 CEST

Washington, DC or Virtual
maj 14 - 16 15:00 - 22:30 CEST

Ottawa or Virtual
maj 21 - 23 15:00 - 22:30 CEST

New York or Virtual
jun 4 - 6 15:00 - 22:30 CEST

Toronto or Virtual
jun 16 - 18 15:00 - 22:30 CEST

Herndon, VA or Virtual
jun 25 - 27 16:00 - 23:30 CEST

Austin or Virtual
jul 9 - 11 15:00 - 22:30 CEST

Washington, DC or Virtual
jul 16 - 18 15:00 - 22:30 CEST

Ottawa or Virtual
jul 23 - 25 9:00 - 16:30 CEST

Stockholm or Virtual
jul 23 - 25 15:00 - 22:30 CEST

New York or Virtual
jul 23 - 25 10:00 - 17:30 CEST

London or Virtual
jul 30 - aug 1 15:00 - 22:30 CEST

Toronto or Virtual
aug 6 - 8 15:00 - 22:30 CEST

Washington, DC or Virtual
aug 13 - 15 15:00 - 22:30 CEST

Herndon, VA or Virtual
aug 20 - 22 16:00 - 23:30 CEST

Austin or Virtual
aug 27 - 29 15:00 - 22:30 CEST

Ottawa or Virtual
sep 3 - 5 15:00 - 22:30 CEST

Toronto or Virtual
sep 10 - 12 15:00 - 22:30 CEST

New York or Virtual
sep 24 - 26 15:00 - 22:30 CEST

Washington, DC or Virtual
okt 1 - 3 9:00 - 16:30 CEST

Stockholm or Virtual
okt 1 - 3 10:00 - 17:30 CEST

London or Virtual
okt 1 - 3 15:00 - 22:30 CEST

Herndon, VA or Virtual
nov 19 - 21 9:00 - 16:30 CET

Stockholm or Virtual
nov 19 - 21 10:00 - 17:30 CET

London or Virtual

Scroll to view additional course dates

Bring this or any training to your organization
Full-scale program development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

#1360

Questions about this course?

Customise Your Team Training Experience

Fill out the form below or call +46 (0)8 506 668 00

* Required Fields

Preferred method of contact:

Phone

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

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.

Introduction to Power BI Training

Introduction to Power BI Training Delivery Methods

Introduction to Power BI Training Information

Introduction to Microsoft Power BI Training Course Outline

Chapter 1: Power BI Overview

Chapter 2: Transforming Data

Chapter 3: Creating a Data Model

Chapter 4: Visualizing your Data

Chapter 5: Introduction to DAX, Calculated Columns and Measures

Chapter 6: Collaboration and Sharing (Publishing Reports and Creating Dashboards)

Introduction to Power BI Training FAQs

What are the prerequisites for attending this Introduction to Power BI Training Course?

What delivery methods are available for this Introduction to Power BI Training Course?

What topics will be covered in this Introduction to Power BI Training Course?

What will I do in this training?

Will I be able to access the software used in the course after the training is complete?

What is the expected outcome of this Introduction to Power BI Training Course?

Related Courses