Data analysis

11:55 - 13:25

Wednesday 12 May

How to use - Tableau

Data is an increasingly important tool used to make evidence-based decisions, however, often one of the hardest things is turning a boring spreadsheet into something that will engage decision-makers and bring to life the story of the data. If you ever find yourself repeating the same sums in Excel or producing the same graphs over and over again for reports, then this workshop is for you! Using Tableau, we will explore ways to automate these processes, saving you a lot of time and resources in the long run. This workshop will cover an introduction to data visualisation & dashboards, how to connect to data sources, introduction to data manipulation techniques, build a simple interactive dashboard tracking key organisational metrics, how you can have easy updates of the reports if data updates or changes, how you can download the visuals for static reports (for example, in pdf form for a meeting) and good practices for dashboard design…and you don’t need to be able to code to do any of the above! Experience with spreadsheet data (e.g. using Excel) is beneficial for this workshop.

12:15 - 12:40

Wednesday 12 May

Combining data using GIS 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.

14:25 - 15:05

Wednesday 12 May

Data Journey at Working Families

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.

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.

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 funding, from crisis response to renewal, and distributed around £55m to community organisations in London. London Funders used the data generated to interrogate who the funding is reaching, in particular, smaller, ‘led-by’ organisations. By working alongside funders and equity partners, we’ve developed tools to monitor this and interrogated the data together to understand how well we are achieving this. The collaboration and its partners have used the data to shape how the LCR is designed and delivered. We hope this will inspire change to wider funder approaches.
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 our current approach including how they have used data in our shift to virtual delivery during the pandemic and future plans. They will also talk about some of the challenges faced (plenty!) and how they have overcome them.

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.