This course has passed.


The public sector holds large volumes of data, from patient records to local government data. Access to such huge volumes of information, gives your organisation an excellent opportunity to utilise data to make more effective decisions.

The effective use of your data can help inform a policy recommendation, improve the performance of a project and streamline outdated processes.

This Effective Data Analytics virtual training course, which has been tailored for the public sector, gives delegates the necessary tools and skills to identify what data to use and how to use it to make more effective decisions.

Through interactive sessions and the use of laptops by relying on Microsoft Excel application, you will use free and publicly available software to use data to enhance your decision making.


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
Branko Pecar
Statistics Consultant

Branko spent most of his career working for Emerson, a global and one of the largest process control equipment manufacturing corporations. His last position was VP Educational Services. In the past, he also lectured at the University of Gloucestershire in several subjects, including quantitative methods and applications of Excel.

He published a series of books in statistics with a variety of publishers, such as McGraw Hill, Oxford University Press and Amazon. Almost all of these books are based around applying a variety of sophisticated methods using the simplest Excel syntax. He has been using Excel for over ...

Read more

Learning Outcomes

  • Understand how data can best be used in decision making
  • Identify what datasets to use
  • Utilise data analysis tools to extract meaning and inform decisions
  • Practise using raw data to 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:15 - 09:30


09:30 - 10:00

Ice Breaker and Clarification of Learning Objectives

  • Decision making in general
  • How could data be used in decision making
  • The essence of Data Driven Decision Making (DDDM)
  • DDDM process
  • DDDM pitfalls
  • Focus on predictive modelling
  • MS Excel as a platform of choice
  • Real-life public datasets
10:00 - 10:45

Big Data, Analytics and Modelling Clarified

  • Big data
  • Data mining, Data analytics, Predictive analytics
  • Methods of analysis
  • Modelling as the foundation for decision making
10:45 - 11:00

Morning Break

11:00 - 12:00

The Language of Data Analysis

  • Different averages
  • Randomness
  • Stationarity
  • Linearity
  • Periodicity and Seasonality
  • Forecasting horizon
  • Accuracy and Precision
  • Error measurements
  • Standard errors of the estimates
  • Prediction intervals
12:00 - 13:00

Data Analysis Tools

  •  The use of different types of mean values
  • Correlation and causality
  • Regression and Univariate approach to time series analysis
13:00 - 13:45


13:45 - 14:00

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

Workshop 1: Data Analysis to Improve a Decision – Hands on Approach Using Excel

  • Visualising data sets for easy identification of patterns
  • Establish relationships between data sets and measure the strength of correlation
  • Build simple linear models to calculate estimates of one dataset from another
15:00 - 16:00

Workshop 2: Data Analysis to Improve a Decision – Hands on Approach Using Excel

  • Single variable extrapolations and predictions (time series analysis)
  • Extrapolate a variety of data trends into the
  • future
  • Establish the reliability of your models, estimates and predictions
  • Some advanced Excel functionality
16:00 - 16:15

Round Up and Key Takeaways