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!

In this session, we'll dive into some of the key services and capabilities available through the Microsoft Cloud for Nonprofit and how you can leverage them to amplify the impact of your social good endeavors. We'll see examples of technology solutions where Microsoft Philanthropies is partnering with nonprofit and humanitarian organizations to help address some of the world's most pressing challenges. We'll discuss how to enable easier collaboration across nonprofit organizations and tools to help you innovate with social impact in mind.

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!

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.

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.

Google Data Studio allows us to connect to data, build a presentation and more importantly share to make sure it gets into the hands of those who need it, when they need it. This session will look at the pros and cons, the good, the bad and the downright tricky elements of using Google Data Studio. It is aimed at those who are using or might want to start using this (free to use) tool, and are curious about getting started. Ian will use the example of Government web traffic (using dummy data) to demonstrate.

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.

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.

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.

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.