How-to

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!

15:20 - 16:15

Wednesday 12 May

How to use Understanding Society data to examine how the pandemic is affecting and changing society

Harnessing large-scale data well is becoming more critical to the work and impact of organisations. Understanding Society offers unrivalled data collected across adults, children, and families on a wide range of issues from social cohesion, volunteering, and charitable giving to health, poverty, and work. This session will provide an overview of how to make the most of this resource, including use of data collected during the pandemic. It will explore potential uses through case studies, and drill into the data to profile the extent to which particular disadvantaged groups are represented in the study.

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!

10:35 - 11:15

Tuesday 11 May

How to use Google Colab notebooks for collaborative coding

How can Colab Notebooks help you get started with advanced data analysis? This session provides an introduction to what Colab Notebooks are, and how to import, manipulate, and analyse data, using a 360Giving dataset as an example. Colab Notebooks are a free, interactive programming environment provided by Google, and use the Python programming language. You don’t need to be an expert programmer to join the session, but some experience of Python or other programming languages is needed.

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.

13:20 - 14:50

Tuesday 11 May

How to do impact reporting for small organisations

Developing an impact report for the first time can feel like a daunting and time-consuming project, especially for a smaller organisation with limited comms capacity. With a bit of guidance and a useful template, this session will give small charities a jump-start by creating a bite-sized one or two-page impact report that can be easily updated and adapted to fit a website, social media, or funder report. They may even find this is all they need to get their message out to the public and key stakeholders!

15:20 - 16:15

Tuesday 11 May

How to use GrantNav

Learn how to use GrantNav, 360Giving’s free search-engine for grants data, to answer your questions about grant giving in the UK. GrantNav, their flagship online tool, lets you explore, download and analyse data for £billions worth of UK grants - and it’s recently been improved and updated. In this session, 360Giving will explore and analyse UK grants data on GrantNav. You’ll leave the session understanding how GrantNav can help answer your questions and how to get the most from the new version. The session is for existing and completely new users to GrantNav, whether you’re a funder, researcher, charity fundraiser, or anyone wanting to explore UK grants data.

12:30 - 12:55

Monday 10 May

How to use more data visualisation in your charity

Whether it was Covid-19 charts, or US election maps, in 2020 the public became more familiar than ever with data in visual form. But sadly, too few in the social sector use this mix of design and statistics effectively. This session will focus on how they should be using data visualisation to aid decision-making and communication, and how to do it well.

Oliver is the Evaluation Manager at Imperial Health Charity, an NHS charity supporting patients and staff at five London hospitals through grants, arts and volunteering.

14:40 - 15:20

Monday 10 May

How to use the Arts & Culture Benchmark to inform your work

This workshop is for arts and culture organisations who want to compare and contrast their current business model to those of their peers in order to find new opportunities for income development and cost management. We will also look at how we could redefine financial 'success' in the future to more thoroughly encompass ideas of financial resilience, balance, and health.

14:40 - 15:20

Monday 10 May

Leveraging data insights to better support users

Creating an actionable feedback loop with your service users doesn't have to be complicated. In this session, charity Carefree will show you how to use no code tools to join up live user feedback with your operations and track the impact of the improvements you make. No Code tools featured will include: Front App, Herald HQ, Linear and Databox. Carefree is a multi-award winning digital charity that leverages easy to use, flexible technology to match unpaid carers referred by social sector organisations with gifted short breaks.

15:35 - 16:30

Monday 10 May

How to CRM

CRM systems should make life easier but all too often they are a source of gripes and complications. In this practical session, you’ll explore a potential DIY solution for people interested in a lightweight CRM. The Good Ship will share the CRM template they built in Airtable, and provide examples of other organisations who have used it, and how they’ve done so. Participants can then make a copy and start using the CRM for themselves. They can then work out a quick action plan of how they could adapt it for their organisations and how they would get others on board.