Introduction to Microsoft Power BI Training

Course 1360

  • Duration: 3 days
  • Labs: Yes
  • Language: English
  • Level: Foundation
Get This Course £1,295
  • 3-day instructor-led training course
  • After-course computing sandbox included
  • After-course coaching available

  • Learning Tree end-of-course exam included
#1360
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    May 25 - 27 2:00 PM - 9:30 PM BST
    AnyWare
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    Jun 28 - 30 2:00 PM - 9:30 PM BST
    New York or AnyWare
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    Aug 3 - 5 2:00 PM - 9:30 PM BST
    Ottawa or AnyWare
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    Aug 16 - 18 9:00 AM - 4:30 PM BST
    AnyWare
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    Aug 31 - Sep 2 2:00 PM - 9:30 PM BST
    Herndon, VA or AnyWare
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    Sep 27 - 29 2:00 PM - 9:30 PM BST
    New York or AnyWare
  • Oct 26 - 28 2:00 PM - 9:30 PM BST
    Ottawa or AnyWare
  • Nov 14 - 16 9:00 AM - 4:30 PM GMT
    AnyWare
  • Nov 21 - 23 2:00 PM - 9:30 PM GMT
    Herndon, VA or AnyWare
  • Dec 21 - 23 2:00 PM - 9:30 PM GMT
    New York or AnyWare
  • Jan 18 - 20 2:00 PM - 9:30 PM GMT
    Ottawa or AnyWare
  • Feb 13 - 15 9:00 AM - 4:30 PM GMT
    AnyWare
  • Feb 22 - 24 2:00 PM - 9:30 PM GMT
    Herndon, VA or AnyWare
  • Mar 22 - 24 1:00 PM - 8:30 PM GMT
    New York or AnyWare
  • May 15 - 17 9:00 AM - 4:30 PM BST
    AnyWare

Scroll to view additional course dates

In this course, you will gain the basic skills and knowledge to manage and analyse data in Power BI.

More specifically, this Microsoft Power BI Training course will guide you through the five basic steps of transforming raw data into digestible, actionable analysis with Power BI:

  • 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 Microsoft Power BI Training Delivery Methods

  • In-Person

  • Online

Microsoft Power BI Training Course Benefits

  • Create interactive visualisations to deliver insights in an easily digestible and actionable format

  • Share datasets, reports, and dashboards in the Power BI Service

  • Add measures, calculated columns, and calculated tables to your data reports using DAX for enhanced interactivity

  • Import data from relational databases and integrate it with other data sources

  • Explore and extend a Power BI data model

  • Apply your knowledge in hands-on learning labs

  • Test your knowledge in the included end-of-course exam

  • Leverage continued support with after-course one-on-one instructor coaching and computing sandbox

Introduction to Microsoft Power BI Training Course Outline

In this module, you will learn:

  • The basics of visual analysis and visual analytics
  • How to navigate the Power BI software
  • How to load data into Power BI

Hands-On Exercise:

  • 1.1 Loading and Visualising data

In this module, you will learn how to:

  • Use the Power Query language to clean, transform, and load data
  • Profile your data for issues and resolve them
  • Apply a user-friendly name to Queries, tables, and columns
  • Import data from a report formatted in Excel

Hands-On Exercise:

  • 2.1 Transforming Data with Power Query

In this module, you will learn how to:

  • Understand the role of the data model in Power BI
  • Create table relationships
  • Understand cardinality and cross filtering
  • Create star and snowflake schemas
  • Create a date dimension

Hands-On Exercise:

  • 3.1 Creating a Data Model
  • 3.2 Creating Star and Snowflake Schemas

In this module, you will learn how to:

  • Navigate and manipulate report settings
  • Choose the right visualisations for your report
  • Create, format, and style your reports
  • Use hierarchies and drilldown
  • Utilise slicers and filters
  • Add custom visualisations

Hands-On Exercise:

  • 4.1 Creating Reports Part 1
  • 4.2 Creating Reports Part 2
  • 4.3 Creating Reports Part 3

In this module, you will learn how to:

  • 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
  • 5.1 Intermediate Level DAX

In this module, you will learn how to:

  • Understand the main components of the Power BI Service
  • Publish a Power BI project to the Power BI Service
  • Build and share reports and dashboards

Hands-On Exercise:

  • 6.1 Collaboration and Sharing in the Power BI Service

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Introduction to Microsoft Power BI Basics FAQs

Power BI is a desktop application that you can download from Microsoft. Power BI enables you to connect to your data sources, visualise the data and publish your results to either the Power BI Server or the online Software as a Service (SaaS) called Power BI Service. There are also Power BI mobile apps for iOS and Android devices.

Power BI can extract data from multiple data sources, such as a database, data warehouse, excel, text files and many, many others. The different sources of data can be combined in a Data Model and consumed as though it is a single data source. You can create visualisations and reports on the data and save it to the Power BI Service where you can create Dashboards from the reports. These dashboards can then be shared with others. The Power BI Service can also keep your data up to date automatically.

No, all software and licenses are supplied as part of the Training Course which also means you are not affecting your organisation's Power BI Infrastructure. All Reports and Dashboards will be created in the Training System which is an implementation of a live system. The Power BI license is available to you for a period after the course has finished.