Data analysis and analytics. Uncover insights and transform your organisation.

This Microsoft Power BI training course will provide you with the skills to tackle data modelling with confidence and improve your decision-making ability with this self-service business intelligence tool.

In this Power BI beginner course, we will show you how to link and model data in Power BI and create visual reports that reveal data insights. The Power BI desktop client will be the primary focus but an introduction to the Power BI web app is also covered.

This Power BI training course will show you how to create dashboards for reporting, create a data visualisation, connect to data sources, use the query editor, model data and manage relationships.

For anyone interested in business intelligence and wanting to improve their reporting and analytical abilities, this Power BI training course is ideal.

Aims

We want to empower you to confidently use the Power BI tool. We aim to give you the ability to create useful data visualisations that improve your business intelligence and your ability to make data-driven decisions.

Outcomes

By the end of this Microsoft Power BI training course, you should be able to:

• navigate between different Power BI tools and their functionality
• build informative reports and dashboards
• work confidently with and create a variety of data visualisations
• work with measures
• create, edit and format interactive visuals
• create multiple levels of filters
• create and use custom slicers
• feature and favourite dashboards.

Content

This Microsoft Power BI course will cover the following topics:

Introducing Power BI

• An Introduction to Microsoft Power BI
• Working with Power BI desktop file
• Connecting to data sources with Power BI Desktop
• Creating a report with visualisations
• Doing more with visualisations

Working with data

• Transforming and sanitising data
• Using the Query Editor
• Data modelling
• Managing relationships

Working with reports and visualisations

• Managing report pages
• Changing report view options
• Working with visualisations
• Adding static objects to a report
• Page navigation

A closer look at visualisations

• Matrices, tables, and charts
• Maps
• Cards, gauges, and KPIs
• Slicers
• Sparklines

Introduction to the Power BI web app

• Getting started with the Power BI web app
• Connecting to data sources with the Power BI web app
• Using workspaces, dashboards, and reports
• Creating custom dashboards
• Power BI web app features

Intended audience

This Microsoft Power BI training course is suitable for:

• Anyone who wants to get the most out of their data and reporting
• Excel users wanting to upgrade their reporting capabilities
• Data Analysts and those performing data analysis, data modelling or data visualisation
• Database Administrators
• Project Managers and those working in project management
• Financial Analysts
• Marketers

Prerequisites

No prior knowledge of programming languages is required for this Power BI course. It is recommended that you be comfortable with the learning outcomes equivalent to our Microsoft Excel Course: Level 1.

Delivery modes

• Face-to-face, presenter-taught training
• Online training via the platform Zoom

Delivery style

Face-to-face classes (CCE, Newtown)

These Microsoft Power BI courses run in a computer lab and you do not need to bring your own device.

Face-to-face classes (external venues including PARKROYAL, Cliftons and CBD)

These Microsoft Power BI courses run in a classroom and you need to bring your own device with a Windows operating system.

Online classes

You will need your own device with a Windows operating system. Power BI Desktop only runs on a Windows operating system. It does NOT operate on Mac.

Materials

A course workbook and exercise files are distributed electronically using Dropbox.

Before the course

Please ensure Power BI Desktop is installed on your device before class. It can be downloaded from the Microsoft Website. Recommended minimum version – July 2022.

You will be provided with a login to Power BI pro – the cloud application. However, you can choose to use your own Power BI pro license if you have one.

Please bring a USB flash drive to class if you would like to make a copy of your work or any relevant class materials. Alternatively, you can save these to a cloud storage space or email them to your personal email address.