This course has passed.


The public sector holds large volumes of data, from patient records to local government data. Access to large volumes of information gives your organisation an excellent opportunity to make more effective decisions, improve service delivery and enhance efficiency using data analytics.

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 use 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

  • Examine real-life public sector datasets
  • Learn the best methods to analyse data
  • Ascertain what data to use to aid your analytics
  • Establish what data analytics is and what it means for your organisation
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:30

Workshop 1: What is Data Analytics?

In this interactive session, delegates will examine what data analytics is and what it means for their organisation.

  • De-mystify data analytics
  • Map data analytics with the trainer and peers
  • Examine ways data analytics can be used in the public sector
  • Examine best practice case studies
11:00 - 11:15

Morning Break

11:15 - 12:00

Workshop 2: Identify What Data to Use

Assess what data to use when using data analytics. 

  • Identify what data sets to use
  • Gain the confidence to use your data
  • Establish what the data set should include
  • Ensure the integrity and diversity of the data
12:00 - 13:00

Workshop 3: Analysing Public Sector Datasets

  • Find useful insights from your data
  • Examine real-life public sector data sets
  • Determine what your data is telling you
  • Understand how to measure your data sets
  • Learn the best methods and techniques to analyse data
  • Easy tips on how to navigate through a bank of numbers – like shares, indices and ROI calculations
13:00 - 13:45


13:45 - 14:00

Reflective Session

  • The 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 4: Summarising Data

In this practical workshop session, learn how to summarise your findings through a group activity followed by a laptop activity.

  • Summarise a big data set into clear usable findings
  • Know what data and information your audiences need
  • Translate and contextualise the data into meaningful information
14:45 - 15:00

Afternoon Break

15:00 - 16:00

Workshop 5: Utilise Data Analytics to Improve a Service

In this interactive workshop session, learn how to utilise data analytics to improve decision making.

  • Identify your key service delivery objectives
  • Learn how to use free and available data analytical tools
  • In groups, you will use laptops to use data to improve a service and decision making
16:00 - 16:15

Feedback, Evaluation & Close