This course has passed.

Overview

There is increasing pressure on public sector organisations to manage, process and present large volumes of data. When presented in the right way, data can create impact and make a convincing case to internal and key stakeholders.

This Designing Powerful Data Visualisations course gives you the knowledge to use a range of publicly available and free to use visualisation tools, such as Power BI, which will help you gain further insight and meaning from your datasets.

Through interactive workshops and the use of laptops, learn how to practice using visualisation digital tools on public sector related datasets.

NB: Delegates who attend the day will be asked to bring their own laptops. 

trainer photo
Mark Wilcock
Data Analysis and Visualisation Expert

Mark is a trainer in data analysis and visualisation. He runs a small consultancy, Zomalex Limited. Zomalex build reports and dashboards using Power BI. Clients include firms from many sectors; banking, local government, health, public transport, charities and higher education. Mark has received Microsoft’s Most Valuable Professional (MVP) award for the last four years. He has a MA in Natural Sciences from Cambridge and an MBA from Imperial College, London. He is the organiser of London Business Analytics Group, a very popular community meetup group.

Read more

Learning Outcomes

  • Gain a quick overview of what makes a good visualisation
  • Effectively utilise publicly available and free visualisation tools
  • Build visualisations through public sector datasets, by using Power BI
  • Get hands-on experience of building your own visualisation
  • Learn editing techniques to get the most impact from your visualisation

 

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:15 - 09:45

Registration

09:45 - 10:00

Trainer’s Introduction and Clarification of Learning Objectives

10:00 - 10:45

A Good Data Visualisation

In this session, delegates use examples of publicly available interactive visualisations and discuss:

  • What makes them effective
  • What techniques do they use?
  • Are they interesting and do they achieve their objectives?
10:45 - 11:00

Morning Break

11:00 - 12:00

Introduction to Visualisation Tools

In this session delegates will be introduced to the following free and publicly available visualisation tools:

  • Python
  • Power BI
  • R programming
  • Tableau
12:00 - 13:00

Workshop Part 1: Creating Impactful Visualisations

In hands-on exercises delegates will practice techniques to build interactive visualisations from public sector datasets, by using Power BI.

  • Slice data: slicers filter our dataset to focus on areas of interest.
  • Apply slicers and look at the different types of slicers (list, slider,..)
  • Navigate hierarchies with drill down
  • Practice drilling down from top level summary to bottom level detail
  • Utilise cascading sliders
  • Drill through:  jump from a summary dashboard that focuses on the nitty-gritty details of an item
  • Build in Interactions between visuals
13:00 - 14:00

Lunch

14:00 - 14:45

Workshop Part 2: Creating Impactful Visualisations

You will learn to use advanced techniques including how to:

  • In this session, delegates will use Power BI
  • Utilise storytelling techniques
  • Create tailored dashboards to follow through a logical narrative – especially useful in presentation to others
  • Implement what-if capabilities
  • Use tooltips and building custom tooltips
  • Creating synchronized slicers
  • Use of colour to signify a value that requires attention
14:45 - 15:00

Afternoon Break

15:00 - 16:00

Edit and Refine Your Visualisation

  • Gain editing techniques to improve your visualisation
  • Use computer programming to refine, and improve your visualisation
  • Make sure your visualisation is compelling
16:00 - 16:15

Feedback, Evaluation and Close

Venue

etc. Venues – Marble Arch, London

Garfield House 86 Edgware Road, London, W2 2EA