Since 2020 we have built and supported a community of children‘s services analysts to bring Python data analysis tools to more than 50 local authorities across the UK.
Children’s services analysts have a wealth of data available to them to improve their services, but existing tools, such as Excel, that they have available to utilise this data are limited.
Whilst useful for some types of analysis – for example, the number of children using a service – more advanced functions, such as demand forecasting or data validation, can prove difficult.
Over the past two years, we have collaborated with Data to Insight, a community of local authority data professionals, to make Python-based analytical tools available to a wider audience.
To do so has meant applying the multidisciplinary skillsets in Social Finance’s Data + Digital Labs Team – including our technical expertise, community-building experience, and user research methodology – to overcome a number of challenges, as detailed below.
The challenge: How can we deploy a Python-based tool to all 152 local authorities?
These more advanced analytical tools need to be code-based (rather than built in Excel), which has limited the scalability of tools as they require local authorities to either:
Our solution: Using a software package called Pyodide, we were able to load Python and run code in-browser, but working entirely locally, focusing on standard datasets. This means analysts can access the tool in seconds, like a website, but that no data leaves their machine.
The challenge: How can we ensure ongoing sustainability?
Tools need maintenance and updates (for example when data validation rules are updated, or when bugs are identified). We needed to identify a way to do this which was sustainable within existing local authority funding structures.
Our solution: We upskilled a community of children’s social care data analysts in Python, coached them to be able to code up rules, and built the infrastructure so they can edit and update in future.
The challenge: How do we ensure the tool is responsive to the needs of all 152 local authorities?
Each local authority will have their data stored in slightly different ways, and have different capabilities in accessing and engaging tools. Additionally, each will have different preferences around the analysis and functionality they would find most valuable.
Our solution: We established a replicable four-tier user research methodology to be used to develop and iterate upon new tools:
I’ve been using the new 903 data tool, and I just want to say that I think this will be a game changer in terms of data cleaning! Thanks so much to everyone involved in developing it.
Through this process, we have thus far created two tools that are accessible to all 152 local authorities. We are currently developing more tools.
A free, web-based tool which allows children‘s services analysts to quickly see estimates of demand for residential, fostering, and supported accommodation placements up to three years out, and model changes they are considering – such as the creation of in-house provision, or a step-down service
The placement demand modelling tool:
A free, web-based tool which allows analysts to check their SSDA 903 data (the statutory return used to report on looked after children) throughout the year and fix errors as they arise.
The cleaning tool:
To find out more about how we‘re transforming children’s services data, get in touch with our Data + Digital Labs team.
Get in touch
We’re helping to transform and scale employment services for people with severe mental illness, addiction and other health issues, by working in partnership with the NHS, the DWP and the OHID.
Our experience shows us that the next government can make meaningful change happen in three key areas: employment & skills, children & young people and health & social care.
Everything you need to know about social investment in the Health and Social Care sector. Find FAQs, reports & case studies – all in one place.
