Public sector organisations are increasingly being asked to improve performance, make more effective business decisions and deliver better services. It is therefore essential that professionals are able to understand and utilise effective forecasting and trend analysis techniques, in order to handle these increased pressures.

This Understanding Forecasting and Trends course gives those with a limited understanding of analysing forecasts and trends, the confidence to make more effective decisions, based on data reports.

By attending this Understanding Forecasting and Trends training course: you will gain a very practical overview of common forecasting techniques; the knowledge to utilise basic measures and correlation techniques when predicting trends, and the confidence to apply the right forecasting technique for your organisation.

Through a series of highly practical workshops and use of personal laptops, you will gain the confidence and knowledge to forecast and analyse trends. Leave the day with the ability to make greater sense of your data.

NB: Delegates who attend the day will be asked to bring their own laptops.

What did previous delegates say about this course?

“Extremely insightful course, where a much greater understanding and basic using of excel.” – Head of Patient Safety, RCHT NHS

“Well organised, excellent trainer and fantastic venue.” – Business and Systems Development Officer, Norfolk County Council

“Sue was really engaging and extremely helpful. She made the course fun and understandable. Easy to follow and good documentation.” – Senior Business Management Advisor, Southend-On-Sea Borough Council

09:15 - 09:45


09:45 - 10:00

Trainer's Welcome & Clarification of Learning Objectives

10:00 - 10:45

Workshop 1: Understanding the Language of Forecasting and Trends

  • Overview of common forecasting techniques
  • Understand key terms such as: time series trends, averages and linear patterns
10:45 - 11:00

Morning Break

11:00 - 12:00

Workshop 2: Basic Measures Needed for Trends

  • Different types of averages: mean, median, mode
  • Using an average and the range to compare sets of data
  • Calculating a moving average
  • Considering accuracy of measures
12:00 - 13:00

Workshop 3: How to Choose the Right Forecasting Technique

  • Determine the purpose and desired outcome of the analysis – what do you want to discover: estimation, validation or prediction?
  • Understand different forecasting models: Linear Trends
  • Identify common patterns in your data, averages and begin interpreting data charts
13:00 - 14:00


14:00 - 14:45

Workshop 4: Correlation

  • Understand the difference between correlation and causation
  • Think about different variables, and their interaction
  • Learn to calculate and use Pearson rank and product moment calculations to show ‘fit’ with your models
  • Understand how to measure and graph two different variables
14:45 - 15:00

Afternoon Break

15:00 - 16:00

Workshop 5: Regression

  • Learn how to conduct regression analysis
  • Interpret regression models to make predictions
16:00 - 16:15

Feedback, Evaluation & Close

Sue Southward

Lead Teacher, Comberton Village College, Cambridge Maths Hub

Sue is Lead Teacher at Comberton Village College, which is part of the Cambridge Maths Hub.

Hallam Conference Centre

44 Hallam St,

+44 (0)20 7706 7700

Q: Can I make a provisional booking?

A: Unfortunately, we do not accept provisional bookings. Registrations are subject to our terms and conditions. View terms and conditions here

Q: Can I book without a purchase order number?

A: Yes. Simply email [email protected] after you have booked the course, with your Purchase Order Number. Please quote your order number and the course you are booked onto.

Q: Is lunch included?

A: Yes, a two-course hot buffet is served at lunch. Tea and coffee are served throughout the day.

Q: I have special dietary requirements, how can I request this?

A: Special dietary requirements can be catered for, please ensure you include this in the further information box when registering your place. If you have forgotten to add this, you can also send your requirements to [email protected] or call 0800 542 9440. Please let us know as soon as possible so we can ensure your needs are met.

Q: I have just registered for the course, when will I receive the joining instructions?

A: You will receive the joining instructions and reminders, 6 weeks, 2 weeks and 3 days before the course date. Please check your spam box to see whether the joining instructions were sent there, if not please call 0800 542 9440 so we can have these sent to you immediately.

Q: I can no longer attend the course, can a colleague attend in my place?

A: Substitutions may be made at any time but must be made no later than 48 hours prior to the event. Please call 0800 542 9440 or email [email protected] with the replacement's details.

Q: What is your cancellation policy?

A: Cancellations must be received in writing 30 working days before the date of the event and will be subject to a £195+VAT administration fee. Cancellations received after this time will be subject to the full delegate fee.

Q: Why haven’t I received the speaker’s presentation?

A: Speakers presentations are sent a week after the event date. Please contact a member of the UMG team on 0800 542 9440 or [email protected] if it has been more than a week.

Q: Will there be WI-FI?

A: Yes, all our venues have the latest technology, offer full audio visual support and WI-FI.

Q: Can’t find what you are looking for?

A: Why not contact a member of the UMG team on 0800 542 9440 or email [email protected]

Q: Private: Who is the AgilePM course suitable for?

A: The AgilePM Practitioner course is aimed at experienced project managers. You may be adding to your knowledge of traditional approaches such as PRINCE2®. Or you may be operating in an agile environment and need to be able to run projects in more complex and scalable situations. We have a range of options available to you so please contact us and we will advise you on the right option for you.

Q: Private: Is this an accredited course?

A: Yes. AgilePM is accredited by the APMG; the same accrediting body that look after the PRINCE2 qualifications.