Redesigning Liquidlogic Workflows and Power BI Reporting for Swindon Borough Council

Description

PCH is offering support to all councils rated Requires Improvement by the Care Quality Commission on baseline assessments in 2025/6 which request it. Swindon Borough Council (SBC)’s Care Quality Commission Report was published in Oct 2025. CQC highlighted waiting lists and waiting times as a key area of improvement for SBC; bringing down these waiting times is a key focus for the council. CQC quote: “There were also significant numbers of people waiting for a Deprivation of Liberty Safeguards (DoLS) assessment, which could have an impact on them. We saw some evidence of an impact of long waits for occupational therapy assessments. Risk mitigation measures were in place, and the local authority had taken steps to improve these areas around assessment and review. There had been significant waiting times in assessing a variety of needs, including Care Act, occupational therapy, DoLS and financial assessments, although more recent efforts, over the last few months, had brought these waiting periods down. “Governance, accountability and risk management processes were in place; however the local authority had experienced significant delays in some of its work which had an impact on people. This included delays in assessments, reviews, waits for equipment and Deprivation of Liberty Safeguards (DoLS).” Swindon believe that their lack of access to timely data and insight is limiting strategic oversight and effective management. To test this assumption, they undertook an internal deep dive review into one of the areas that requires improvement - Care Act Review completion and timeliness. Finding of this work can be made available to successful bidders. From the above work, and after discussion with the CHIA, the following areas have been identified. These will require system configuration: • Review and reassessment forms and workflows • Needs assessment and support plan forms and workflows • The contact form is out of scope (not important for process efficiency); however, adjustments to the contact form will be considered if they resolve the issue of unplanned review requests not appearing on waiting lists SBC lacks the specialist expertise in-house to deliver the comprehensive redesign, development and implementation of the assessment, support plan, review, and reassessment process within Liquidlogic and associated PowerBI reporting suite. We are seeking a suitably skilled and experienced contractor to support with report development as well as system configuration in order to deliver meaningful versions of the required reports: • Waiting lists, for all waiting work, at service and team level, including CQC measures • Performance reports, at service, team and individual level, including CQC measures • Fully reportable review process. Including authorisation stage, allocations, and review completion rate at service and team level, for people with a long-term service (the statutory D40)