Adult Social Care Reporting: 6 week Discovery

Peak Indicators Limited

Adult Social Care reporting using Power BI and Azure Data Factory orchestration to create automated reporting and analytics insights

Peak Indicators (now TPXimpact Data & Insights) is a part of a digital transformation company on a mission to build a future where people, places and the planet are supported to thrive. This solution improves Adult Social Care reporting, using automation to give strategic, insightful view of performance management, referrals and caseloads.

What's the problem?

  • Reporting on Adult Social Care is challenging. We are seeing an increase in the number of councils and Local Government Associations asking for help, as pressure mounts and internal teams are stretched to the limit.
  • The Adult Social Care team noticed that supported living referrals were taking longer to place than they would expect and they were struggling to understand why the delays were occurring because they couldn’t access the relevant data in time.
  • This lack of access to the right data at the right time for the Adult Social Care team meant ongoing difficulty in predicting how long referrals would take and lack insight into why shortlist refusals were occurring, resulting in issues around planning, forecasting and budgeting.
  • The manual effort and costs involved with residential placements, combined with the inability to make quick data driven decisions puts strain on both the teams within the councils, and the vulnerable people they are trying to help.

To solve these key challenges, our priority was to ensure the Adult Social Care team could easily and securely access the right data they needed at the right time to make the important decisions quickly. The solution therefore needed to link together different back-end systems, ensure sensitive data was only available to authorised users and reduce manual processes wherever possible to speed up the decision making process.

Here’s how it works:

  • We worked in collaboration with the Adult Social Care team, creating an end-to-end solution, allowing authorised individuals to access the sensitive data they need.
  • We built a Data Lake in Azure, which connected to CareFirst / Mosaic / LiquidLogic and automated the extraction & transformation of data using our Azure Data Factory Framework which is then visualised in secure Power BI reports & dashboards.
  • We leveraged our User Centred Design approach to design dashboards with different personas in mind. We wanted to ensure that users were comfortable using the Power BI reports and dashboards after training.

What's the impact?

  • With this solution, teams now have the ability to drill down into their placement request data and understand the root cause - enabling them to take action to help improve the referral process.
  • Due to the collaborative approach in designing and building the Power BI dashboards with the users in mind, user adoption was high across the council - improving data access to those who need it most
  • This package was completed on a single platform, with security and governance inbuilt - meaning data is only available to authorised users
  • The in-built automation removes manual processes and empowers the in-house teams to focus on making the right data-driven decisions - increasing the capacity of the team whilst saving both time and cost

This solution is perfect for:

  • Adult Social Care leads – core role requirement
  • Adult Social Care service delivery – core role requirement
  • Council Leadership – financial/accurate performance rating
  • Any role responsible for statutory reporting

Products Responsible:

  • Power BI (Premium)
  • Azure Data Factory/Synapse Pipelines
  • Azure Data Lake
  • Azure SQL DB
https://store-images.s-microsoft.com/image/apps.61883.5717ac6b-d812-4e79-9978-5c8945527ef5.c6a08cc5-f8af-4496-8ae1-2d5b2b1cf9e8.33e92855-c095-4a4a-9bde-a095aec538ed
/staticstorage/8165fe0/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.61883.5717ac6b-d812-4e79-9978-5c8945527ef5.c6a08cc5-f8af-4496-8ae1-2d5b2b1cf9e8.33e92855-c095-4a4a-9bde-a095aec538ed
/staticstorage/8165fe0/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.53208.5717ac6b-d812-4e79-9978-5c8945527ef5.9c69ff1d-d6fb-43b0-aa8e-fcb074244c40.74c73e56-fc78-428e-b18b-59930d036f79
https://store-images.s-microsoft.com/image/apps.7031.5717ac6b-d812-4e79-9978-5c8945527ef5.9c69ff1d-d6fb-43b0-aa8e-fcb074244c40.58e2e457-6af5-4549-b22f-044fd1574d23
https://store-images.s-microsoft.com/image/apps.65504.5717ac6b-d812-4e79-9978-5c8945527ef5.9c69ff1d-d6fb-43b0-aa8e-fcb074244c40.7a0a4c29-feee-405f-888b-9ed0dfd209cf
https://store-images.s-microsoft.com/image/apps.24086.5717ac6b-d812-4e79-9978-5c8945527ef5.9c69ff1d-d6fb-43b0-aa8e-fcb074244c40.518117ef-01f0-4aaf-986e-fc488b60b7ba
https://store-images.s-microsoft.com/image/apps.39760.5717ac6b-d812-4e79-9978-5c8945527ef5.9c69ff1d-d6fb-43b0-aa8e-fcb074244c40.31308b39-4121-4bb4-bcb3-f643b0a30111