Microsoft Power BI Training Course

Microsoft’s Power BI is a cloud-based business analytics service that gives you a comprehensive view of your most critical business data. You can monitor the health of your business by creating rich interactive reports with Power BI Desktop and publish your reports to the cloud using PowerBI.com. You can then create powerful interactive dashboards that can be accessed via native Power BI Mobile apps on tablets and smartphones.

By attending our 2-day Microsoft Power BI course, you will learn how to create the visualisations that allow you to stay up to date with the information that matters to you.

Download course informationGet a Quote for this Course

Microsoft Power BI Service - Course content - Duration: 2 Days

What is Microsoft Power BI

  • The Power BI software explained

Exploring Power BI Desktop

  • How to work with the Fields and Visualisation Panes
  • Creating visualisations using the Report View
  • Sort and formatting data using Data View

Understanding Data Sources in Power BI Desktop

  • How to import a wide range of data sources into Power BI Desktop
  • How to connect to Access Databases, Excel Workbooks and CSV files

Power BI Desktop Visualisations Workshop

  • How to add visualisation to the Report Canvas
  • How to understand and control the interactions between visualisations
  • How to use Drill Down and Drill Through with visualisations
  • How to create and use Hierarchies
  • How to understand summarisation options
  • How to import custom visualisations
  • (Attendees of the two day course can practice how to create and design a variety of interactive visualisations in Power BI)

Creating a Data Model in Power BI desktop

  • How to understand the Data Model
  • How to use Relationship View
  • How to create Many-to-One relationships
  • How to use filter propagation

Introduction to DAX in Power BI Desktop

  • Understanding uses of calculation within the Data Model
  • Using Calculated Columns
  • How to create simple measures for data summation
  • How to use CountRows and DistinctCount functions
  • Overview of advanced DAX functions SUMX and CALCULATE
  • Understanding time intelligence functions

Using Queries in Power BI Desktop

  • The role of queries in data import
  • How to use Extract, Transform & Load (ETL)
  • Exploring a wide range of data transformations
  • Using Applied Steps
  • Working with the Unpivot transformation
  • Using Connect to Folder to append CSV and XLSX files

Publishing to Power BI Service

  • Publishing your report on PowerBI.com
  • Dashboard setup and creation
  • Sharing your dashboard inside and outside of your organisation
  • How to use Quick Insights
  • Interactive data searching with Q & A

Power BI Service Data Import

  • How to connect to a wide range of Cloud-based data sources, including OneDrive, Google Analytics, Azure SQL Databases and Websites

Apps & Groups

  • Apps and Groups benefits
  • Restrict access to dashboards using groups
  • How to create Organisation Apps
  • How to connect to cloud based Apps

Data Refresh

  • Refresh data manually
  • How to install and use Personal Gateway
  • How to install and use the Enterprise Gateway
  • How to create a scheduled refresh

Using Power BI on Mobile Devices

  • Understanding mobile clients
  • Using Power BI on Tablet Clients, Windows 10, iPad and Android
  • Understanding the differences between iPhone, iPad and Android clients

On the course, you will learn how to produce interactive dashboards, similar to the embedded example below. Click on an element of the dashboard to filter the entire dashboard by that element.
 
 

Speak to a trainer now

0800 0199 746 for any questions about the courses we offer