Microsoft 365 Power BI Fundamentals
This introductory course is perfect for users who are looking to make a bigger impact with the way they report on data through visualisations. The course will be of particular benefit to team leaders, management at all levels, or anyone who needs to commission the production of reports or dashboards. Please note that this course does not cover PowerBI Pro, PowerBI accessed via Microsoft 365 or SharePoint Services.
Description
COURSE CONTENT
Getting Started with Power BI
-
Concepts and overview
-
Introduction to main features
Connect to a Data Source
-
Data sources Power BI will connect to
-
Methods of connecting to data
Get data and query using Power Query Editor
-
Shape, clean and transform data
-
Combining data sources
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
-
KPI visualisation
-
Slicers
-
Drill visualisation to see underlying data
-
Clustering
-
GEO-data and Maps
-
Publishing
Using Power BI Service
-
Pin visuals to Dashboards
-
Export visuals to other platforms
-
Get insights