Introduction to Microsoft Power BI Training

Course 1360

  • Duration: 3 days
  • Labs: Yes
  • Language: English
  • Level: Foundation
Get This Course 21.900 kr
  • 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.
    okt 26 - 28 15:00 - 22:30 CEST
    Virtual
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    nov 14 - 16 10:00 - 17:30 CET
    London or Virtual
  • nov 14 - 16 9:00 - 16:30 CET
    Stockholm or Virtual
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    nov 21 - 23 15:00 - 22:30 CET
    Herndon, VA or Virtual
  • dec 21 - 23 15:00 - 22:30 CET
    New York or Virtual
  • jan 18 - 20 15:00 - 22:30 CET
    Ottawa or Virtual
  • feb 13 - 15 10:00 - 17:30 CET
    London or Virtual
  • feb 13 - 15 9:00 - 16:30 CET
    Stockholm or Virtual
  • feb 22 - 24 15:00 - 22:30 CET
    Herndon, VA or Virtual
  • mar 22 - 24 14:00 - 21:30 CET
    New York or Virtual
  • apr 19 - 21 16:00 - 23:30 CEST
    Austin or Virtual
  • maj 8 - 10 15:00 - 22:30 CEST
    Ottawa or Virtual
  • maj 15 - 17 10:00 - 17:30 CEST
    London or Virtual
  • maj 15 - 17 9:00 - 16:30 CEST
    Stockholm or Virtual
  • jun 21 - 23 15:00 - 22:30 CEST
    New York or Virtual
  • jul 5 - 7 15:00 - 22:30 CEST
    Virtual
  • jul 19 - 21 16:00 - 23:30 CEST
    Austin or Virtual
  • aug 9 - 11 15:00 - 22:30 CEST
    Virtual
  • aug 23 - 25 15:00 - 22:30 CEST
    Herndon, VA or Virtual
  • sep 6 - 8 15:00 - 22:30 CEST
    Virtual

Scroll to view additional course dates

This Introduction level Microsoft Power BI Training course will give you all the skills you need to jump-start your Power BI journey. It discusses in depth the industry-recognised 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

Throughout the course, you will access data from a wide range of 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.

Introduction to Microsoft Power BI Training Delivery Methods

  • In-Person

  • Online

Microsoft Power BI Training Course Information

  • Microsoft Power BI Training Course Benefits

    • 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

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

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 them 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.