Centre for Continuing Education

Power BI course

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

Coronavirus (COVID-19) update: arrangement of our courses

Some of our courses have moved to online delivery. We aim to continue to deliver a high-quality educational experience through interactive, online classes in real-time. If you are currently enrolled in a course with us, we will be in touch soon with options for your enrolment.

Please note that for online classes, all course materials will be shared electronically. No printed resources will be available.


This 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 beginner’s 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 short 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.

This course is for anyone interested in business intelligence and wanting to improve their reporting and analytical abilities.

Aims

We want to empower you to confidently use Power BI. 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 course, you should be able to:

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

Content

Introducing Power BI

  • An Introduction to 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

A closer look at visualisations

  • Matrixes, tables, and charts
  • Maps
  • Cards, gauges, and KPIs
  • Slicers

Introduction to the Power BI web app

  • Getting started
  • 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

  • Anyone who wants to get the most out of their data and reporting
  • Excel users willing to upgrade their reporting capabilities
  • Data Analysts
  • DB Administrators
  • Project Managers
  • Financial Analysts
  • Marketers

Prerequisites

No prior knowledge of programming languages is required. It is recommended that you are comfortable with the learning outcomes equivalent to our Microsoft Excel Course: Level 1.

Delivery style

This interactive training course is taught in a computer lab. You will follow along step-by-step as the facilitator demonstrates key concepts and gives you practical exercises to attempt at your computer.

Materials

You will be provided with a course workbook (with exercise files) in class.

Additional information

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.

Features

  • Expert trainers
  • Central locations
  • Free, expert advice
  • Course materials – yours to keep
  • CCE Statement of Completion

Power BI course

<p>{block name:“Course Tagline - Data Analysis and Analytics”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>This Power BI training course will provide you with the skills to tackle data

...
Power BI course

<p>{block name:“Course Tagline - Data Analysis and Analytics”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>This Power BI training course will provide you with the skills to tackle data

...
Power BI course

<p>{block name:“Course Tagline - Data Analysis and Analytics”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>This Power BI training course will provide you with the skills to tackle data

...
Power BI course

<p>{block name:“Course Tagline - Data Analysis and Analytics”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>This Power BI training course will provide you with the skills to tackle data

...
Power BI course

<p>{block name:“Course Tagline - Data Analysis and Analytics”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>This Power BI training course will provide you with the skills to tackle data

...
We acknowledge the tradition of custodianship and law of the Country on which the University of Sydney campuses stand. We pay our respects to those who have cared and continue to care for the Country.