Microsoft 365 Power BI Fundamentals Training Course
Course Code: M365PBIF Duration: 1 Day Price: £395+VAT
Discounts available for Group Training Courses - enquire here
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).
Software Requirements for Virtual Classroom
Delegates will need to have an Office 365 subscription with access to Power BI and have the desktop version installed on their PC. We strongly recommend that delegates also check that their PC meets the Minimum Requirements as outlined on the Microsoft Website in order to run Power BI effectively.
This course is not suitable for MAC users.
Getting Started with Power BI
Concepts and overview
Introduction to main features
Imports
Visualisations
Filters and queries
Reports
Connect to a Data Source
Data sources PowerBI will connect to
Data types
Data behaviours
Importing and entering data
Creating tables
Get data and query using Editor
Combining data sources as a mash up
Merge queries
Append queries
Working with Relationship View
Understanding relationships
Create using AutoDetect
Create relationships manually
Cross Filter
Join Types
Visualisations
What is available?
Create a quick visualisation
Table and matrix visualisation
Conditional formatting
Charts
Types
Create a chart visualisation
Analytics
Forecast
Create a KPI visualisation
Slicers
Drill visualisation to see underlying data
Clustering
Creating role-based views
GEO-data, Categorisation and Maps
Querying and Shaping Data
Filter
Pivot
Add calculations
Reports and Output Options