Power BI Course: Introduction
Class Details
<p>This Power BI beginner 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.
...
Course summary
This Power BI beginner 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. You will learn how to link and model data and create visual reports that reveal data insights. We 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.
The Power BI desktop client will be the primary focus but an introduction to the Power BI web app is also covered. 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.
Learning 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
Who this course is for
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
Materials
A course workbook and exercise files are distributed electronically using Dropbox.
What you need to do before the course
Face-to-face classes (CCE, Sydney)
Classes are held in a computer lab. You do not need to bring your own device or login details.
Face-to-face classes (external venues including PARKROYAL and CBD)
Please bring a laptop with Microsoft Power BI installed. 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.
- Required operating system: Windows (please note Power BI does not run on MacOS)
- Required software: Microsoft Power BI (latest version is recommended)
Online classes
You will need Microsoft Power BI installed on your device. 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.
- Required operating system: Windows (please note Power BI does not run on MacOS)
- Required software: Microsoft Power BI (latest version is recommended)
For the best experience, we recommend using a computer with a large monitor or dual screens/devices. Small laptop screens can make it difficult to follow the facilitator’s display while working in the software.
Sessions
Location
Face-to-face (CCE Building, Sydney)
Public transport
As bus and train timetables regularly change, we suggest you visit the Transport for NSW trip planner before you set out.
The nearest train stations are Newtown Station and Macdonaldtown Station. Macdonaldtown Station is closer by distance than Newtown Station, however trains do not stop as frequently as at Newtown Station.
Other information
Parking
Nearby parking is available at Wilson Parking - RPA Medical Centre Car Park (entry via Elizabeth Street off Carillon Avenue).
A Flexi Saver Rate is available but must be booked in advance online and includes the booking fee. Bookings can be made via the Wilson website or by downloading the Wilson Parking App. Otherwise, hourly parking rates will apply, as advertised on the Wilson Parking website.
