Redesigning Liquidlogic Workflows and Power BI Reporting for Swindon Borough Council

Description

A recent deep dive was undertaken into why people who receive support from Swindon Borough Council (SBC) were having to wait longer than they should for a Review. The ‘deep dive’ identified opportunities to streamline processes and improve timeliness and access to data. PCH are supporting SBC to identify areas for improvement. As part of this work, PCH are seeking help for SBC to design and enable user-friendly, drillable PowerBI reports showing: • 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) However, simply producing more reports will not deliver the impact leaders expect on improving performance (reducing waiting times) because of issues with system processes, unless system processes are also reviewed and optimised. Therefore, PCH are also requiring support for SBC with system configuration in order to deliver meaningful versions of the required reports listed above. 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)