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, from Power BI to R programming, 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.

Alan Rutter is a journalist, digital consultant, product owner and trainer.
He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has been working with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets.
Until November 2014 he worked with Guardian Masterclasses on curating and delivering new course strands and teaching their B2B data visualisation courses for clients including the Financial Conduct Authority, the Home Office, Novartis, Haringey Council and Gloucestershire Police Constabulary.
Previously he was ...
Agenda
Registration
Trainer’s Welcome and Clarification of Learning Objectives
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?
Morning Break
Introduction to Visualisation Tools
In this session delegates will be introduced to the following free and publicly available visualisation tools:
- JavaScript
- Python
- Power BI
- R programming
- Tableau
Workshop Part 1: Creating Impactful Visualisations
In hands-on exercises delegates will practice techniques to build interactive visualisations from public sector datasets.
- 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
Lunch
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
Workshop Part 2: Creating Impactful Visualisations
You will learn to use advanced techniques including how to:
- 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
Afternoon Break
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