Data to Insight is not a software supplier in the traditional sense -- we're here to help local authority (LA) colleagues get work done and share it with each other. The best thing about Data to Insight is the community of analysts who are doing and sharing great work through this network.
We recognise that different LAs want different levels of engagement with our work. As such, we offer four key collaboration approaches to suit different users’ information needs.
.png)
Tools
This is the full Data to Insight toolkit. Click through to download current, previous, and beta versions of our tools. For support, or to contribute to development, visit our community spaces.
ChAT
Our flagship Excel tool uses the standard Annex A reports produced by all English local authorities to produce detailed analysis covering every stage of the children's social care pathway.
Benchmarking Tool (BMt)
A comprehensive, frequently updated compendium of national datasets relating to Children's Social Care, with table and chart views, and options to create your own comparator groups.
Cut the ChAT
A simple tool to generate a copy of the ChAT which includes only the tabs you want, to reduce the file size, speed up performance, and keep your inbox happy.
Demand Modelling Tool for CLA Placements
A powerful Excel tool which uses PowerQuery to ingest multiple years of SSDA903 data files, and generates adjustable cost and demand models for different kinds of CLA placements.
Demand Modelling Tool 2021
A reworked version of our 2020 Demand Modelling tool, configured to use an analogous historical reference period to model an expected future period of demand.
Demand Modelling Tool 2020
An easy way into modelling future demand for local services. Paste local Annex A data into the Excel tool, check the suggested parameters against your local understanding, and start modelling the ramifications.
COVID ChAT
Use your Annex A child-level data to quickly track emerging trends through lockdowns, local emergencies, and other time-sensitive situations.
DfE VCYP Survey Tool
Download your LA's data from the DfE portal, add in your latest data submission, and track performance locally.
SSDA903 Statutory Returns Predictor
Load in completed data returns each summer, and get an advance view of local performance, before the DfE share your data with the world.
CIN Census Statutory Returns Predictor
Load in completed data returns each summer, and get an advance view of local performance, before the DfE share your data with the world.
Annex A Loader
A very simple tool to automate loading the 11 Annex A lists into the ChAT, and other tools which use the Annex A data.
ILACS Child Selector Tool
A tool to analyse Annex A lists and suggest example children for audit / Ofsted preparation.
Disproportionality Calculator
The Disproportionality Calculator lets you paste a breakdown by ethnicity of a cohort of your choosing, and compare this to the general population in your area. This helps analysts to explore how proportionately or disproportionately different groups of children are represented in various cohorts
CIN Census Error Validation
A simple error checking tool to help tidy up CIN Census data before uploading it to the DfE's COLLECT site using the XML converter.
Ofsted LA Inspection Dashboard
A Power BI app allowing interactive analysis of published Ofsted inspection outcomes for local authority children's services. Hosted by Walsall Council.
SSDA903 Validation Tool
A browser-based Python data vaildation tool, for in-year SSDA903 data cleaning
RIIA Quarterly Collection Sheet
A template sheet for LAs to collate and submit their RIIA quarterly datasets to regional and national colleagues. Includes guidance and full measure definitions as agreed with ADCS, NPIMG, and DfE.
D2I annual governance reports
Our Annual Report to Colleagues is an open document outlining our work over the previous year and our intentions for the near future. We review our goals and achievements, point out key learning, and gauge overall performance and value for money. We do this so colleagues, whatever their role, can feed back on our strategic direction.