Centre for Continuing Education

Power BI Course: Introduction

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

COVID-19 update: arrangement of our courses

We are now delivering courses both online and in-person. Please check the delivery format for each class before you enrol.

Please note that course materials for all classes (excluding prescribed textbooks) are shared electronically within 48 hours of a course starting. Printing is not 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

Delivery options:

  • Presenter-taught, computer-based training in a computer lab on University premises. Follow along step-by-step as the facilitator demonstrates key concepts and gives you practical exercises to attempt at your computer.
  • Online training via the platform Zoom.

Materials

You will be provided with an electronic copy of the course workbook and exercise files.

Additional information

Face-to-face classes

These classes run in a computer lab and you do not need to bring your own device.

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.

Online classes

If you are attending an online class, 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.

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.

Before the course

Please ensure Power BI Desktop is installed on your device before class. It can be downloaded from the Microsoft Store.

Features

  • Expert trainers
  • Central locations
  • Course materials – yours to keep
  • CCE Statement of Completion

Power BI Course: Introduction

<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: Introduction

<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: Introduction

<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: Introduction

<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: Introduction

<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: Introduction

<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: Introduction

<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: Introduction

<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: Introduction

<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: Introduction

<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

...

What others say.

  • Instructor-lead course provided a great deal of expertise that can be difficult to find with other delivery methods. Highly recommend!
  • The course was excellent and I would recommend it to others. The facilitator was very experienced and professional, and covered lots of important topics in such a short time. Thank you!
  • An excellent educator/trainer who paced the course well.