Running DataDives is part of DataKind’s DNA. However, over the years, we have experimented with different formats and formulas. At DataKind UK, we’ve been partnering with Marks & Spencer, a UK food and clothing retailer, to run internal DataDives with them for three years running.
Similar to other DataDives, the event involves bringing together groups of volunteer data scientists and selected charities to work on data-for-good projects. Unlike other DataDives though, the events are not open to the public. Rather, they are attended by M&S’s internal data analyst community and invitations are extended to some of their suppliers.
On Thursday, October 27th and Friday, October 28th this year, 40 Marks & Spencer data analysts came together to help three fantastic charities: Oasis Community Learning, Shelter, and the Welcome Centre. After much coffee and number crunching, the assembled brain power produced some spectacular results.
Check out highlights of findings from each project below!
Oasis Community Learning
"...It is the best level of human resources analytics that Oasis Community Learning has ever had and it is great to see the educational impact being clearly mapped to the turnover of our staff."
John Barnaby, Chief Operating Officer, Oasis Community Learning
Oasis Community Learning is one of the top three Academy providers in the UK with 47 schools across primary, secondary and 6th form serving 22,000 students with 4,300 teachers. Oasis wanted to look at their human resources data to understand staff turnover and absence, and what this means for pupil performance.
The volunteer analysts found that staff turnover was higher in schools with students that have special educational needs and English as an additional language. They found that primary schools spend twice the amount per day to cover staff absence compared to secondary schools. The analysts also found that primary schools tend to underestimate these absence costs. While these are all provisional findings that require further analysis, the DataDive enabled Oasis to see these patterns in their HR data for the first time and Oasis has accelerated their plans to become more data-driven.
“…The DataDive has equipped us with a set of ideas and insights that has helped to clarify which direction to head in to develop a deeper understanding of our clients...”
Dean Robinson, Business Systems & Analysis Manager, Shelter
Shelter helps millions of people every year struggling with bad housing or homelessness through advice, support and legal services. They wanted to dig into their outcomes data to understand what happened to their clients. What is the result of their help? What are the changes for the client? How do these changes compare for different people accessing different services around the country?
The M&S analysts dived in and, in no time at all, whipped up an interactive dashboard to enable Shelter staff to explore these very questions. The volunteers looked at the number of hours Shelter staff spend delivering services in different parts of the country. They also explored the rate at which cases were dealt with. For example, those over age 65 are more likely to have their cases resolved than those aged between 25 to 34. Shelter’s business systems team was thrilled, and they have even started learning R, a data analytics programming language!
The Welcome Centre
“A very well organised and structured event, the outcomes of which will make a genuine difference to our organisation's business processes...”
Andrew Tomlinson, Trustee, The Welcome Centre
The Welcome Centre is a food bank in Huddersfield and South Kirklees that supports people experiencing crisis through practical help. They wanted to understand their clients better and identify those who would benefit from additional support, advice and referral to other services. In particular, the Welcome Centre wanted to know who is most likely to become a repeat user of the food bank, as those individuals tend to need extra support.
The all-star team of pro bono analysts got to work and were able to find factors that predicted how likely it was that someone would need extra support. Based on a person’s age, their number of dependents, and the reason for their referral to the foodbank, we can begin to predict the kind of support they will need. The Welcome Centre is looking to develop the model further so they can identify who needs support earlier, what future demand for the service might be, and to test hypotheses for which interventions work best with which clients.
A huge thank you to Marks & Spencer’s Plan A team and to Pete Williams, Head of Enterprise Analytics at M&S, for driving another successful DataDive. We look forward to next year’s!