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?

Jake Kuyer, Senior Consultant, NEF Consulting

Jake joined NEF Consulting in August 2015.  He is interested in the application of economic analysis to social and environmental issues to improve the overall relationship between the economy, the environment and society.

With several years’ experience in consultancy, he previously worked as an environmental economist with a multinational engineering firm engaged on a wide range of projects for the public and private sector including impact assessment, carbon auditing and the ecosystem services approach.

Dates and venue

7 February – London. Book here.
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