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 pages.

ChAT

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)

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

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

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

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

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

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

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

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

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

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

ILACS Child Selector Tool

A tool to analyse Annex A lists and suggest example children for audit / Ofsted preparation.

Disproportionality Calculator

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

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

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

SSDA903 Validation Tool

A browser-based Python data vaildation tool, for in-year SSDA903 data cleaning