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

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 (electronic copy).

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.

Power BI desktop only runs on a Windows operating system. It does NOT operate on Mac.

If you are attending an online course, you will need a computer with a Windows operating system.

Face-to-face courses currently run in a computer lab and you do not need to bring your own device.

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

...
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.

  • An excellent educator/trainer who paced the course well.
  • 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!