PowerBI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.
With PowerBI Desktop, you get a report authoring tool that enables you to connect and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can add visualisations and create reports. Reports can then be published.
The course introduces PowerBI Desktop and is designed for users who are looking to make a bigger impact with the way in which they want to report on data through visualisations.
It covers the use of PowerBI Desktop to connect to data, create visualisations, query the data and publish reports.
Please note that this course does not cover PowerBI Pro, PowerBI accessed via Microsoft 365 or SharePoint Services.
By actively participating in this course, you will learn about the following:
Understand Power BI concepts and main features.
Use data sources that are compatible with Power BI Desktop.
Connect to data.
Explore data visualisations.
Apply common query tasks to shape data in Power BI Desktop.
Create and publish reports.
This course is not suitable for users who are new to Excel or Databases as delegates must have an understanding of the basic data concepts.
Delegates must already have the knowledge and ability to create and format chart outputs and they should also have a basic understanding of Functions (ideally Aggregate Functions).
Getting Started with Power BI
Concepts and overview
Introduction to main features
Filters and queries
Connect to a Data Source
Data sources PowerBI will connect to
Importing and entering data
Get data and query using Editor
Combining data sources as a mash up
Working with Relationship View
Create using AutoDetect
Create relationships manually
What is available?
Create a quick visualisation
Table and matrix visualisation
Create a chart visualisation
Create a KPI visualisation
Drill visualisation to see underlying data
Creating role-based views
GEO-data, Categorisation and Maps
Querying and Shaping Data
Reports and Output Options