Microsoft Power BI - Beginner

Length 1 day

Course overview

View dates &
book now

Why study this course

Power BI is Microsoft's powerful data visualisation tool that is commonly used for business analytics. With the ability to connect to data, clean and transform it, and create interactive dashboards, users can gain valuable insights to support informed decision-making. In our courses, you will gain hands-on experience using both Power BI Desktop and the Power BI service to create compelling visualisations. Learning Power BI has never been easier, and our courses will provide you with the skills you need to leverage this powerful tool effectively.

The Power BI beginner course is your one-stop shop for all of the basics of Power BI. Not only will you learn how to create powerful interactive dashboards and custom reports, you will also be able to analyse data and share insights. With the skills you'll gain from this course, you'll be able to create dynamic dashboards that can be accessed on any device, allowing you to monitor your business and make data-driven decisions quickly and confidently. The power of data-driven decision-making has never been so easily accessible.

Nexacu Public Schedule

Nexacu is part of the Lumify Group, offering you the largest public schedule of end user applications and professional development training in Australia, New Zealand, and the Philippines. You can now access the schedule of courses and book, by clicking on the button below.

Book now!

Request Course Information

What you’ll learn

At the completion of this course you should be able to:

Understand the principles of self-service Business Intelligence using Power BI
Build informative and interactive dashboards for data-driven decision-making
Create a variety of visualisations to represent data clearly and effectively
Use the “Quick Insights” feature to uncover patterns and trends
Design dashboards optimised for both desktop and mobile viewing
Build and manage data models to support analysis
Expand and refine datasets for improved reporting and performance

Microsoft Apps at Lumify Work

As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.

View all Microsoft Apps at Lumify Work courses

Who is the course for?

This beginner course is designed for individuals who want to develop a fundamental understanding of data visualisation tools necessary for analysing data and leveraging data analysis expressions.

Course subjects

Introduction

A history of Business Intelligence
The development of Self Service Business Intelligence
Introducing Power BI
Introducing the three main tools:
- Power BI Service
- Power BI Desktop
- Power BI Mobile
When to use Power BI Desktop

Using Data from Excel

Understanding your data
Fact and dimension tables
Creating tables for Power BI to connect to

Power BI Desktop

Getting started
Connecting to data
Using Power Query Editor
Data types
Renaming columns and queries
Navigating the main Power BI Desktop window
The data model
Create and delete relationships
Modify data formats

Data Normalisation

Normalising a dataset

Visualisations

Overview of visualisations
Create a column or bar chart
Basic formatting of visualisations
Focus mode
Create a line chart
Create a card visualisation
Create a gauge visualisation
Create a table visualisation
Create a matrix visualisation

Working with Formats in a Visualisation

Axes
Data labels
Titles
Sizing and alignment
Data colours, backgrounds, borders, and shadows

Power BI Mobile

Installing the Power BI mobile apps
Interacting with reports and dashboards on a mobile
Favourite dashboards
Interacting with reports
Annotating reports
Sharing a dashboard
QR Scanner

Data Samples

Viewing data samples
Working through the Retail Analysis Sample Pack

From Visualisations to Reports

Adding and naming report pages
Re-using visualisations
Text boxes and other visual elements

More Visualisations

Create a treemap visualisation
Create pie or donut chart visualisations

Using Visual Interactions

Introducing Visual Interaction
Turning Interaction On or Off
Interacting by Filtering, Highlighting, or None

Working with Filters

Slicers
Slicers and the data model
The Filters pane
Visual filters
Creating a Top N filter
Filter an entire page
Filter an entire report

Spatial Visuals

Create a map visualisation
Create a filled map visualisation

Q & A and Analysis

Analyse data in a visual

Custom Visuals

AppSource Power BI visuals
Chiclet slicer
Import chiclet slicer
Use images on the chiclet slicer
Play axis dynamic slicer

Publish to Power BI Service

Power BI Service layout
Create a new report

Create Dashboards

Reports to dashboards
Create a new dashboard
Pin visualisations from other pages and reports
Pin an entire report page
Quick Insights
Related Insights
Other tiles
Add an image to a dashboard
Add web content to a dashboard
Add video to a dashboard
Add a text box to a dashboard

Working with Dashboards

Renaming dashboards
Favourite dashboards
Dashboard actions
Duplicate a dashboard
Print dashboard
Refresh dashboard tiles
Performance inspector
Settings
Dashboard themes
Arrange a dashboard for mobile use
Generating alerts from cards and KPIs

Refreshing Data

Refreshing data in Power BI Desktop
Refreshing local data from Power BI Service
Refreshing data from the cloud from Power BI Service

Share Reports and Dashboards

Sharing reports
Sharing dashboards
QR codes

Getting Help

Official Microsoft sources
Other sources

Prerequisites

No prior Power BI experience required; basic data and Excel knowledge is recommended, with Power BI familiarity helpful but not essential.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.