The Q&A session with the three expert speakers on our DigiShift on Data-Driven Charities was one of our most active sessions. Scottish charities are definitely interested in why and how to better use their data.
Steve MacLaughlin from Blackbaud made it clear he is not a data person. He was never good at maths or statistics but he knew data was powerful and wanted to understand how to use it. He is the author of the highly acclaimed book Data Driven Nonprofits written for non-data people.
Our two data experts were
• Brian Hills from Data Lab Scotland, whose mission is to help Scotland maximise value from data and lead the world to a data powered future
• Giselle Cory from DataKind UK, a community of volunteer data scientists who use their expertise to help charities use data to improve their services for social good
You probably already use your data to show impact - but your data can help you do so much more. You simply need to switch from reporting data to being hypothesis driven.
“Data is the raw material for adding value to your charity”Steve MacLaughlin, Blackbaud
Sometimes we shy away from using data because it is messy; or we don’t understand it. This is perilous because as Steve puts it
"Without data, decisions are left to tribal knowledge or worse, the whims of the Highest Paid Person’s Opinion (HiPPO)"Steve MacLaughlin, Blackbaud
The best argument you have against your HiPPO is your data. Turn your data into information and use that information to drive action to lead improvement or change.
Most organisations are using data less well than they could be, not just charities. Most organisations have few resources; feel they are miles behind; and are not sure where to start.
When an organisation does start to look at data, many tend to jump in the deep end with a huge data strategy that stalls.
You need to pause and identify what you want to achieve.
“Forget about data - take time to find out what the problem is”Giselle Cory, DataKind UK
You need to map out your processes, identify your challenges, then think about which might be helped with data.
When Brian talked about how your charity can incorporate data into your services, he advised
"Root your data in the challenges you are trying to tackle"Brian Hills, Data Lab Scotland
Pick one small issue where data will easily fix something. Use this quick win to gain support and traction to continue using data.
• Find the goldilocks issue
Start with something that is big enough that people care about it; but not a big enough problem that everyone cares
• Make a start
Give yourself 30 days to do some research & analysis; and make recommendations on change or next steps
• Think about your people and what basic tools already exist
A lot can be achieved using Excel pivot tables. You likely don’t need a shiny new expensive platform.
• Keep going
Once you've solved one issue, find another issue to investigate, and repeat. If you keep doing that, you will eventually become data driven
Often it really is as simple as just making a start! Sometimes it requires culture change.
The culture of your organisation is set by your people, by what they do every day with their peers & colleagues & service users.
If you want your organisation to be more data driven, you need to find a way to include data in everyday decisions. You need to create a culture of sharing, of data champions, and of change.
Choosing how to display your data can be a creative journey into infographics. To get started, keep it simple.
Steve recommends using a bullet chart. This is a simple chart which summarises targets and progress. It is an effective way to show whether projects are on target.
For example a project which has a target of delivering 5 sessions and reaching 50 users might look like this after 2 sessions.
If the "users reached" bar looked the same after 4 sessions, you would have a quick visual highlighting the issue. Displaying this prominently, where all staff can see it, keeps them informed and encourages them to be proactive in seeking out solutions. If the "users reached" bar was already at 50 after 2 sessions, all your staff could see their achievement and gain a sense of pride and accomplishment.
There are multiple ways to display data and NPC have produced an excellent guide Data visualisation: What’s it all about?
You may even want to create a dashboard to display your data like the Citizens Advice live dashboard of searches by general public on their website or Street League’s interactive impact dashboard showing how they have helped young people from disadvantaged communities.
Responsible use of data should be at the heart of this. There are data protection laws and rules you must follow.
This can feel overwhelming but it is mostly common sense:
• have consent
• tell people how and where you will store their data
• only share anonymised data
You should also think about the repercussions of your data collection and underpin everything with ethics. A good rule of thumb is that you shouldn't collect it unless you plan on doing something with it.
"Data leads to information, which should lead to action.Steve MacLaughlin, Blackbaud
Imagine you had the information – what would you do with it?
If you don’t know, don’t collect it."
Eddie Copeland’s four-step method will help you figure out what questions you want to ask and prioritise the data you need to collect.
Often a data champion, with knowledge of Excel, will be all that you need. If you need more, reach out! You are not alone - there is a lot of free support on offer to build your data capacity.
Once you know what you want to do, find an organisation that has already done it. They will help you! Ask in your networks, ask SCVO or ask Data Lab Scotland.