Tools

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.

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.

10:35 - 11:15

Tuesday 11 May

Undertaking a CRM transformation to improve data quality and insights at Teach First

Teach First is in the process of upgrading our CRM and undertaking a large scale business transformation, reviewing all processes, and most importantly data. As one of the first adopters of Salesforce, their data structure is not fit for purpose and limits the insights the organisation is able to generate. This session will cover Teach First’s experience in transforming its Salesforce, challenges faced and emerging lessons for any organisations in the process or about to undertake a similar transformation.

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: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.

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.

15:35 - 16:30

Monday 10 May

How to CRM

This is a practical session 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.