25,000+ Courses Nationwide
0345 4506120

Microsoft Power BI Desktop Essentials

Please note that the duration of this course is 3 hours.

Power BI is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources. 

With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you can add Visualizations and create Reports.

In this half day session, attendees will learn how to connect Excel workbooks to Microsoft Power BI Desktop.  You will model the data using the Query Editor and then add Visualisations to a report.

 

Please note that this course is not suitable for new Excel users.

Select specific date to see price, venue and full details.

Learning Objectives

  • Power BI Concepts and Main Features
  • Loading Excel Data into Power BI Desktop
  • Apply Common Query Tasks to Shape Data in Power BI
  • Explore Data Visualizations

Pre-Requisites

  • An understanding of basic data types
  • Ability to create and format charts

Course Content

Getting Started with Power BI Desktop

  • Power BI concepts
  • Introduction to main features

 

Connecting Excel Data to Power BI Desktop

  • Using Get Data to connect to Excel workbooks
  • Selecting the data to use
  • Overview of Relationships in Power BI Desktop

 

Common Data Preparation Activities using the Query Editor

  • Setting the Data Type
  • Filters
  • Using Delimiters
  • Group By
  • Tables and Matrices
  • Charts
  • Slicers

 

Adding Visualisations to a Report

  • Tables and Matrices
  • Charts
  • Slicers

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best