Data analysis for social impact

Quantitative data is the raw ingredient in understanding how much impact you have created.

This one-day workshop will help you to organise, analyse, interpret and visualise your primary data. We will use a live case study and create space for those who have their own sample datasets to discuss and explore data analysis options.

Data analysis skills are crucial for understanding large data sets and performing evaluations such as Social Return on Investment (SROI). If reporting on social impact is part of your job, this is an opportunity to refresh and build your skills. The workshop will help you become a resourceful and independent data analyst who can quickly cut to the heart of what a set of survey and secondary data tells you about social impact.


Topics covered

During this course we will use a live Excel case study to cover:

  • Data cleaning and the key principles for model usability and efficiency.
  • Calculations – useful features of Excel.
  • Building the model logic.
  • Participant data sets – discuss and plan how to analyse your own data.
  • Visualising your data – dashboards.

We will also discuss designing surveys to obtain high quality data.


What you will learn

By the end of the day you will be able to:

  • Understand different types of quantitative data.
  • Design surveys for high quality quantitative data.
  • Construct and navigate an Excel workbook for social impact data analysis.
  • Clean and code your data.
  • Select and apply a number of excel functions.
  • Understand the principles for data layout and navigation.
  • Present your data in appropriate and insightful charts and graphs.

Who should attend

Anyone responsible for collecting quantitative data to understand social impact.

It is particularly relevant for those:

  • Looking to improve the quality of their data collection methods and reporting
  • With a requirement to manage larger and more complex datasets.

It is also ideal for those with simple Excel skills who want to up their game. They will learn how Excel can help organise and present data to provide appropriate, useful and meaningful descriptive statistics and graphical interpretations of data.


Who will be running the workshop?

Sean Pedrick-Case, Analyst, NEF Consulting

Sean Pedrick-Case, AnalystSean is a data analyst and researcher with professional experience in both academic science and ‘triple-bottom line’ consultancy. He has experience working with both qualitative and quantitative data in a range of research fields, whether they come from large data sets, or qualitative or quantitative data from stakeholder consultation exercises.

At NEF Consulting he has been involved in several projects to assess and evaluate outcomes frameworks, and to measure the extent to which interventions have achieved their desired outcomes.


Dates and venue

7 February – London. Book here. *LIMITED PLACES LEFT*
17 May – London. Book here.

For more dates, sign up for updates here.

Prices for courses from 2018

Booking formStandard price                                £345
Registered charity price               £295  

All courses are subject to U.K. VAT.  Fee includes refreshments and lunch, as well as training materials.

Click here to book

See our terms and conditions 

For more information, and a discount on our open training programme, sign up to our newsletters here