Our next data analytics monthly virtual forum is happening on Tuesday 6th August 2024

What are you looking for...

Simpson Associates Supporting Families Data Platform

A centralised data, reporting and insights platform to increase a council’s ability to deliver the Supporting Families programme, and in return, help more families, evidence outcomes, and secure more funding.

What is the Simpson Associates Supporting Families Data Platform?

The Supporting Families Data Platform is a robust and reliable data platform that empowers local authorities with powerful insight – enabling them to easily identify the new criteria for the Supporting Families initiative, so they can gain greater funding for families in need.

Supporting Families is a government initiative (previously called Troubled Families) designed to build the resilience of vulnerable families and drive systematic change, with the aim of each area having joined-up and efficient local services that can identify families in need and provide the right support at the right time.

The programme has changed its focus, expanding the criteria from 6 to 10, as well as changing the proof points, which when combined with government investment, provides an opportunity to look at the costs and benefits of an automated approach.

In our experience working with local councils and regional government, we’ve found that many are reliant on manual processes, using spreadsheets to store and process data, which leaves them with limited insights and exploratory analytical capabilities.

Benefits of a Supporting Families Data Platform

Bringing together data from a variety of sources on to a single platform

Developing a single view of the child, household and family

Identify those who qualify for funding and help those in need.


Bringing together data from a variety of sources on to a single platform and identify more families in need of support.

On-time intervention

Timely identification of
families that meet the
criteria and are eligible for

Move towards prevention

Use data to identify the patterns and trends, to proactively prevent issues.

An accurate single view of a child

Data on people is now needing to be pulled from a wide range of sources and a single view is critical in order to view them as a whole.

This innovative solution has the potential to revolutionise how your authority supports vulnerable families, streamlining and optimising the supporting families programme.

Supporting Families deliverables: What you get


Azure Landing Zone and Modern Data Analytics Platform (Data Lake and/or Data Warehouse).


Identifying the different data sources and ETL pipelines to ingest the necessary data.


Power BI solution bespoke to your needs, delivering the insights you need.


The Supporting Families Data Platform will deliver a commissioned service with a bespoke design and governance framework. We will also create an end-to-end template for a given use case, from ingestion to transformation to reporting.

The opportunity to bring together information and data onto a single data platform is revolutionary.

Kate ThackerDetective Chief Superintendent

Simpson Associates demonstrated that they were true experts in the field; within a few weeks they had a solid understanding of our business requirements and turned around an initial solution within an astonishingly quick timescale. From delivering the budget within a tight timeframe to supporting our learning and development, Simpson Associates has allowed us to become genuinely self-sufficient, sharing their knowledge and expertise at every step of our journey.

Gillian TroupGroup Financial Controller

Simpson Associates provided us with the expertise to see us through the design and the implementation phases and potential problems that we hit and got us through those. But they also understood our needs as a charity, the components that make up our data warehouse come partly from Microsoft, partly from other companies like Civica and Simpson Associates provided the glue to help us bring those together and get the best out of them.

Jon FoxAssociate Director of IT

Simpson Associates was dedicated to matching our brief, There was healthy debate of course but they always presented reasoned responses, or accommodated our wishes when needed. It’s a very flexible relationship and the synergy we’ve built is vital to the knowledge transfer process.

Neil Spreadbury Commercial Finance Officer

Why Simpson Associates can help customers on their Supporting Families journey as a Microsoft Partner

Simpson Associates is a Microsoft Partner with over 30 years of data experience. We have the expertise to help councils get the most out of Microsoft technologies. We have a deep understanding of Microsoft Fabric and how it can be used to help build better lives for your citizens.

Next Steps

To learn more about getting started with the Simpson Associates Fabric Accelerator, contact us today!

Your Details