Centre for Continuing Education

Power BI course

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

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

A copy of exercises files is provided 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>This Power BI training course will provide you with the skills to tackle data modelling with confidence and improve your

...
Power BI course

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

...
Power BI course

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

...
Power BI course

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

...