This course has passed.

Overview

Power BI is a Microsoft software that can be used to improve your data analysis and create more compelling visualisations.

Our Visualising and Analysing Data with Power BI course led by Power BI Consultant, Alan Gilbert, gives you a comprehensive overview on how to use Power BI.

Learn how Power BI can help you design more dynamic interactive visualisations and make greater sense of your data.

Through practical workshops and expert-led advice, gain confidence and memorable techniques to use Power BI for reporting and easy-to-read dashboards to use back in your organisation.

Please note this course is designed for those with a limited understanding of Power BI.

Delegates will be asked to download the latest version of Power BI before attending the course.

Unlocking the Power of Virtual

Our virtual courses have been designed with you in mind. From group exercises in breakout rooms to live chat, whiteboards and interactive polls, we use a range of tools and techniques to ensure that you can connect with your trainer; network and share best practice with your peers and leave the day with the skills you need.

Our courses provide you with an interactive and engaging learning environment that can be accessed from any location, helping you to continue to connect, learn and grow. Click here to discover more!

Please note we will use Zoom to virtually deliver the course.

trainer photo
Alan Gilbert
Microsoft Excel and Power BI Consultant

In his 20+ years of teaching Microsoft products, Alan has helped a vast array of industries from finance to construction, media, and government. In the past he has been both lead trainer for Go Courses, and training manager for Ultima Concepts. As work increased, he established his own IT consultancy in 2013, following on from 18 years as a full-time trainer.

Being a certified Microsoft Office Specialist, he found the demand for Microsoft Excel training and consultancy work, including Excel’s many facets, increased substantially. Subsequently, that insider’s perspective led him to establish a second consultancy specialising in Microsoft ...

Read more

Learning Outcomes

  • Improve your understanding of Power BI
  • Learn how to clean and import your data
  • Use Power BI to design visualisations
  • Gain techniques to publish and share reports
  • Increase your confidence at using Power BI back at the workplace
All the Understanding ModernGov courses are Continuing Professional Development (CPD) certified, with signed certificates available upon request for event.

Enquire About In-House Training

To speak to someone about a bespoke training programme, please contact us:
0800 542 9414
[email protected]

Agenda

Collapse all
09:25 - 09:30

Registration

09:30 - 10:00

Trainer’s Welcome and Clarification of Learning Objectives

10:00 - 10:45

Workshop: Power BI Analyses Process

  • Opening Power BI Desktop
  • The Power BI ecosystem
  • The four views of Power BI
  • Visualisations at a glance

Workshop: Importing Files and Managing Connections

  • The process of importing files
  • Importing an Excel file
  • Importing a CSV file
  • Importing from a webpage
  • Managing file connections
10:45 - 11:00

Morning Break

11:00 - 12:00

Workshop: The Query Editor: Cleaning and Shaping Data

  • The process of cleaning data
  • Understand the applied steps
  • Manage different data types
  • Filter and filling data
  • Split columns
12:00 - 13:00

Workshop: Inserting Dashboard Visualisations

  • Insert maps and charts
  • Formatting visualisations
  • Inserting a table, matrix and card
  • Controlling number formats
  • Adding data bars
  • Highlighting key points
  • Filtering reports with slicers
13:00 - 13:45

Lunch

13:45 - 14:00

Reflection Session

  • Trainer will review the day’s learning and the next stages of the course
  • Delegates will have time to ask questions and share views with one another
14:00 - 14:45

Workshop: Publish and Share Reports

  • Publish reports online
  • Pinning visuals to a dashboard
  • Share dashboards

Workshop: The Data Model

  • Understanding table relationships
  • Relationship properties

Workshop: DAX New Columns

  • DAX new columns vs. DAX measures
  • Adding a new column with DAX
14:45 - 15:00

Afternoon Break

15:00 - 16:00

Workshop: Introduction to DAX Measures

  • The SUM measure
  • The DIVIDE measure
  • The COUNTROWS measure
  • The DISTINCTCOUNT measure
  • Adding measures to visualisations

Workshop: Introduction to Time Intelligence

  • Importance of a calendar table
  • Time intelligence functions
  • The TOTALYTD measure
  • View time intelligence visually
16:00 - 16:15

Round Up and Key Takeaways