Data analysis

11:55 - 13:25

Wednesday 12 May

How to use - Tableau

Tableau is one of the leading tools for building interactive dashboards. This is a practical workshop aimed at those who have no/little experience in Tableau. Starting with some fake service user data held in spreadsheets we will work through building an interactive dashboard that looks to answer some key questions for a social change organisation. The aim is by presenting the data in an engaging and easy to read format the organisation can more easily gain insights leading to making data driven decisions. 

 

If you ever find yourself producing the same graphs over and over again in Excel for reports, then this workshop could be for you.

 

If you plan to follow along (which is definitely encouraged) please download the Tableau Public programme before the workshop (https://public.tableau.com/en-us/s/download). If it is possible, a 2 screen/device set up is optimal (one screen to watch the workshop and another to follow on your own Tableau programme) but it is definitely not a necessity!

12:15 - 12:40

Wednesday 12 May

Combining data using GIS (geographic information system mapping) for behaviour change insights at Sustrans

This session will provide an overview of how the Hands Up Scotland Survey (HUSS) and other data sources such as accident data, the Scottish Index of Multiple Deprivation, and traffic data are analysed and combined in GIS to provide detailed insights into where and how to deploy behaviour change interventions. The HUSS data set on children in Scotland's travel-to-school habits has been collected by Sustrans for 12 years and is now an Official Statistic of the Scottish Government.

12:15 - 12:40

Wednesday 12 May

How we used our data (both internally and externally, for good) during COVID at Citizens Advice

In this session, Citizens Advice discuss how they built a consolidated dashboard and set up regular data discussions to help their service tackle the COVID crisis internally. They’ll talk about what they learnt from this process, and from their work using social media influencing with their news and comms teams to help their external stakeholders and the government understand the ever-changing concerns of people during the pandemic.

12:15 - 12:40

Wednesday 12 May

Measuring the impact of using data for good at the Data for Children Collaborative with UNICEF

How does the Data for Children Collaborative with UNICEF measure its impact? Measuring and demonstrating impact of Data for Good projects can be a challenge. We will talk through how we address this challenge in the Data for Children Collaborative with UNICEF. The project is a unique partnership between UNICEF, The Scottish Government and the University of Edinburgh which aims to use responsible innovative data science techniques to improve children’s lives.

13:35 - 14:20

Wednesday 12 May

What role does data science have in the social sector?

Drawing from DataKind UK’s nine years of experience supporting social change organisations to use data science, you’ll hear real-life case studies from charities, local government, and social enterprises across the UK. You’ll gain insight into how organisations like yours can use data science to improve their operations, understand their clients better, evaluate their services, and increase their impact. You’ll also hear about some of the tools and resources that DataKind UK use to help organisations frame their data challenges, scope projects and assess data ethics.

14:25 - 15:05

Wednesday 12 May

Data Journey at Working Families

Working Families directly advise 2,000-3,000 parents each year, via  free phone and email helpline for working parents/carers, most of them in some way disadvantaged by income level, BAME background, profound caring responsibilities, etc.

But… there is a limit to how many people we can help as a charity.

This talk explores why we adapted to a new digital platform, and our digital data journey to this point

15:25 - 16:55

Wednesday 12 May

How to use - Excel

Are you looking to increase your confidence in using Excel, and get quick insights from your data to answer organisational questions? This workshop will cover data layout, sorting, filtering and basic data manipulation. We’ll also look at basic formulas, making charts, and tips for designing your spreadsheets to make them easy to follow.

 

If it is possible a 2 screen/device set up is optimal (one screen to watch the workshop and another to follow on your own Excel) but it is definitely not a necessity!

12:15 - 12:40

Tuesday 11 May

How to use geospatial data

This session aims to inspire attendees to make use of their own, and externally held, geospatial data and equip them with the knowledge to do so. Based on a broad range of real life examples of nonprofit use of geospatial data that range in complexity, the type or format of data, tools used, and eventual visual output, attendees can follow along with each stage and leave the session inspired to map their own data.

14:25 - 14:50

Tuesday 11 May

Helping learners succeed: Improving University Success Through Predictive Modeling

According to a report by the National Student Clearinghouse, nearly half of all students entering college are at risk of leaving without earning a degree. John Jay College, located in New York City, inquired how existing student data and machine learning techniques could be combined to address challenges surrounding graduation completion rates. John Jay looked to DataKind to help answer these questions and develop a tool to support their efforts to improve graduation rates. Sponsored by the Mastercard Center for Inclusive Growth, with additional support from the Robin Hood Foundation, the DataKind team analyzed more than ten years of historical student data, identifying features associated with at risk students. The predictive model and insights were used to design effective interventions to reduce dropout, as well as a novel software application that allowed the John Jay administration to identify students at risk of drop out, so that the students can receive proactive outreach and support from the college. In its first year, the tool analyzed roughly 1,114 advanced credit students to identify students who were most at risk of stop-out or drop-out. Through targeted and strategic interventions, John Jay has already helped more than 800 of those students graduate over one year, or approximately 73%, compared to a projected graduation rate of 54% over two years for similar students without the tool and interventions. In support of this work, John Jay College received $800,000 for emergency grants and extra staff.

10:10 - 10:30

Monday 10 May

In-sights into data at Moorfields Eye Hospital

Alex Karet of Softwire will ask how Softwire and Moorfields Eye Hospital give medical researchers access to millions of patient scans without compromising patient confidentiality.

They will discuss how they combine these anonymised images with relevant clinical data, explaining their work producing a state-of-the-art research platform. They will highlight how this platform allows researchers to explore the available dataset without granting access to any identifiable patient records. They will mention their work balancing accessibility of the data with the information governance concerns working with personally identifiable health data. They will also explain how this helps produce datasets for HDRUK and the future of health data research in the UK.

10:35 - 11:30

Monday 10 May

Analysing grant data to shape funder responses to crisis at London Funders

The London Community Response is a collaboration of 67 funders. By May 2021 they will have completed five waves of Covid funding, from crisis response to renewal, and distributed around £55m to community organisations in London. London Funders used the data from this to interrogate who the funding is reaching, in particular whether it supported smaller, ‘led-by’ organisations. Working alongside funders and equity partners, they developed tools to monitor and understand how well they were achieving this throughout. The data was used to shape how the London Community Response is designed and delivered. London Funders hope this will inspire change to wider funder approaches.
11:45 - 12:25

Monday 10 May

Lambeth and Southwark’s Urban Health Index

This talk will cover the how, why, and what’s next for the recently developed Urban Health Index, from Impact on Urban Health (part of Guy's & St Thomas' Foundation).

Impact on Urban Health partnered with the Social Progress Imperative, founders of the Social Progress Index (SPI), to develop a Lambeth & Southwark specific Urban Health Index. The Index looks beyond economic indicators to understand the other important characteristics of neighbourhoods that shape health and wellbeing.

By layering data relating to different social and environmental indicators, we hope to build a better picture of the circumstances of people living in urban areas and how their environment impacts their health.

The Urban Health Index provides information on 68 neighbourhoods in Lambeth and Southwark and includes the most recent publicly available data. We capture data on 42 indicators relating to basic human needs, foundations of wellbeing and opportunity, viewable as an interactive scorecard for different neighbourhoods.

12:30 - 12:55

Monday 10 May

Using data for quality, performance and assurance at Change Grow Live

Change Grow Live talk about their work as the biggest drug and alcohol service provider in England. Using data to make a difference has helped the organisation grow from a tiny volunteer-led group to supporting over 100,000 people every year. Key to this is a data strategy that has transformed how the organisation uses data, having an impact on service users, those on the first line, and leaders. They moved from Excel-style reporting to use of a data visualisation tool which continues to form an essential part of organisation’s response to the challenges of Covid-19.

12:30 - 12:55

Monday 10 May

Using Data at Teach First

Teach First is a charity set up to address educational inequality. Teach First has been in operation for 19 years and over that time helped train and develop over 15,000 school teachers and leaders serving disadvantaged communities. In this session they will talk about Teach First’s journey of using data to inform both strategic and operational decision making. They will discuss their current approach including how they have used data in our shift to virtual delivery during the pandemic and future plans. Join Jonathan Tan, Head of Data and Performance and Daria Kuznetsova, Executive Director, to learn about their journey so far - including some of the challenges faced (plenty!) and how they have overcome them.

12:30 - 12:55

Monday 10 May

The approach to data at Esmée Fairbairn Foundation

Josh Cockcroft at Esmée Fairbairn Foundation will talk us through internal data use, including what data they collect and why - and their ambitions for the future. They'll also talk about their work with social investment data, as well as the Foundation's approach to supporting grantees data needs.

13:35 - 14:35

Monday 10 May

What is Data Science?

Data science is where maths, statistics, and computer science meet. It’s a broad church, but the end game is always the same: to get insight from data. DataKind UK has years of experience supporting social change organisations to use and value data science. This talk will introduce you to the basics of data science and what you might use it for in your organisation, as well as some key first approaches and ways to get started in order to find out more about your clients or beneficiaries, evaluate your services, or improve operational efficiency. For some organisations, data science can be transformative in how services are run, and the impact they have.

14:40 - 15:20

Monday 10 May

From Paper to Power Suite – Taking off on a digital and data journey at London’s Air Ambulance

To use data, you need to collect data. For London’s Air Ambulance helipad daily operations, that meant moving from equipment and vehicle checklists on paper, to data-driven digital checklists built in Microsoft’s Power Apps. LAA’s move to Microsoft’s dataverse and ‘no-code’ tools is designed not only to save team time, but also to build data on checklist completions and issues – leading to reporting and insights to help patient care. In this workshop, LAA will discuss technical benefits and shortcomings of the Microsoft suite (especially for non-experts), and the sociotechnical issues and human factors involved in integrating the existing processes of specialist teams of clinicians, pilots, and fire crew with digital tools and data innovation.