The public sector holds large volumes of important data, from patient records to local government data like waste collection, procurement, planning applications and social care.

With access to such huge volumes of information, and the right skills and knowledge, you can utilise the data to make more effective decisions and improve service delivery in your organisation.

This Utilise Data to Make Better Decisions training course gives you the necessary tools and skills to identify what data to use to inform a policy recommendation, improve the performance of a project, and streamline outdated processes.

Through interactive workshops, case-studies and the use of laptops, practice data analytics on various public sector datasets using Excel. Learn how to use free and accessible data analytics tools, summarising results to make decisions supported by your data.

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 be using Zoom to deliver this course.

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

  • Understand how data can best be used to aid decision making
  • Establish what data analytics is and what it means for your organisation
  • Identify what datasets to use
  • Utilise data analysis tools to extract meaning and inform decisions
  • Practise using raw data to improve the quality of decision making
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]


Collapse all
09:25 - 09:30


09:30 - 10:00

Trainer’s Welcome and Clarification of Learning Objectives

10:00 - 10:45

Data in Public Sector Decision Making

  • How is data currently used in decision making?
  • Examine best and bad practice
  • Benchmark how data is used against other organisations
  • Examine real-life public sector datasets
  • Easy tips on how to navigate through a bank of numbers – like shares, indices, ROI calculations
  • Ascertain what your data is telling you
  • Learn the best methods and techniques to analyse data
  • Find useful insights from your data
10:45 - 11:00

Morning Break

11:00 - 12:00

The Language of Data Analysis

  • Different averages (Mean, mode, median, moving average)
  • Randomness
  • Stationarity
  • Linearity
  • Periodicity and Seasonality
  • Forecasting horizon
  • Accuracy and Precision
12:00 - 13:00

Data Analysis Tools

  • Correlation and causality
  • Regression and Univariate approach to time series analysis
13:00 - 14:00


14:00 - 15:00

Workshop 1: Data to Improve a Decision – Hands on approach using Excel

  • Visualising data sets for easy identification of patterns
  • Establish relationships between multiple data sets and measure the strength of correlation
15:00 - 16:00

Workshop 2: Data to Improve a Decision – Hands on approach using Excel 

  • Build simple linear models to estimate one dataset from the other
  • Use linear regression models to predict the future values of the datasets
  • Extrapolate a variety of data trends into the future
  • Establish the reliability of your models, estimates and predictions
16:00 - 16:15

Feedback, Evaluation & Close


Central Government & Agencies - Virtual

Delegate Price

Local Government, Housing, Education & Health - Virtual

Delegate Price

Charity - Virtual

Delegate Price

Private Sector - Virtual

Delegate Price


“This is an excellent course, well run by a practitioner in this field. I feel equipped to go and experiment with new techniques in representing data.”
Effective Data Visualisation University of Edinburgh
“Very good examples used. Makes you assess data differently made topic interesting. Well delivered and informative will be recommending to colleagues.”
Effective Data VisualisationOversight Officer, Independent Police Complaints Commission
“Really interesting easy to follow interactive course covering all aspects of effective data visualisation.”
Effective Data Visualisation Research Associate, University of Manchester
“I have learned a great deal with many tips and ideas to enable to improve the authority’s reports.”
Effective Data Visualisation Corporate Performance Management Officer, Carmarthenshire County Council