Microsoft 365 Power BI Fundamentals Part 1 [SKT_M365PBIF]

OVERVIEW

Provide business insights at the right time to the right people with Power BI, an interactive data visualisation software product developed by Microsoft with a primary focus on business intelligence. Power BI is part of the Microsoft Power Platform and comprises a collection of software services, apps, and connectors that work together to turn your data into coherent, visually immersive, and interactive insights.

With Power BI Desktop, you will learn how to connect and query data from different sources. Then, using the Power Query Editor, you will clean, shape, and transform this data to produce impactful visuals in reports. You will then explore how reports are published to the Power BI service where your team can access them through intuitive dashboards.

OBJECTIVES

By actively participating in this course, you will learn about the following:

• Identify Power BI Desktop concepts and features.

• Use data sources that are compatible with Power BI Desktop.

• Connect to and manipulate data using the Power Query Editor.

• Apply common query tasks to shape data in Power BI Desktop.

• Explore data visualisations.

• Create and publish reports to the Power BI service.

AUDIENCE

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.

NEXT STEP

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