Available Dates


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.

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:00 - 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


"An excellent and informative course delivered by knowledgeable presenters. I recommend it!"
A Guide to Successful Information and Records Management Agency Records Officer, Vehicle Certification Agency
"This course provides a good combination of general theory and very practical, experience based advice; really adding value to your day to day activities if you work with records management.”
A Guide to Successful Information and Records Management GDPR Protect Manager, DataAI
“A good introduction to an area I was completely unfamiliar with. Gives a lot to think about going forward.”
Developing Agile TeamsAssistant Economist, Food Standards Agency
"The trainer was an excellent instructor who provided insight from their own experience and applied to fun and engaging practical sessions that i can apply to my own teams."
Developing Agile Teams Operations Manager, University of Portsmouth
"A really informative, interactive and beneficial course for anyone who doesn't know much about agile."
Developing Agile Teams Programme Management Support Officer, Avon Fire and Rescue Service