Communicating data

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

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.

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.

11:45 - 12:25

Monday 10 May

How to use data to tell a good story

How does data translate into publicity and journalism? There are always good stories in data, and this session is about how to bring them out. Freelance journalist David Ainsworth will talk both about how you can use data to tell the story of your own charity, and how data can be used to change perceptions of the voluntary sector as a whole.

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.