Redesigning Liquidlogic Workflows and Power BI Reporting for Swindon Borough Council

{
  "buyer": {
    "id": "GB-COH-03675577",
    "name": "Improvement and Development Agency for Local Government (IDeA)"
  },
  "date": "2026-01-14T15:40:39Z",
  "id": "003193-2026",
  "initiationType": "tender",
  "language": "en",
  "ocid": "ocds-h6vhtk-0605e7",
  "parties": [
    {
      "address": {
        "country": "GB",
        "countryName": "United Kingdom",
        "locality": "london",
        "postalCode": "sw1p 3hz",
        "region": "UKI32",
        "streetAddress": "18 smith square"
      },
      "contactPoint": {
        "email": "Kulsuma.Haque@local.gov.uk",
        "name": "Kulsuma Haque"
      },
      "details": {
        "classifications": [
          {
            "description": "Public undertaking",
            "id": "publicUndertaking",
            "scheme": "UK_CA_TYPE"
          }
        ]
      },
      "id": "GB-COH-03675577",
      "identifier": {
        "id": "03675577",
        "scheme": "GB-COH"
      },
      "name": "Improvement and Development Agency for Local Government (IDeA)",
      "roles": [
        "buyer"
      ]
    }
  ],
  "tag": [
    "tender"
  ],
  "tender": {
    "aboveThreshold": false,
    "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 \u2018deep dive\u2019 identified opportunities to streamline processes and improve timeliness and access to data.\nPCH 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:\n\u2022\tWaiting lists, for all waiting work, at service and team level, including CQC measures\n\u2022\tPerformance reports, at service, team and individual level, including CQC measures\n\u2022\tFully 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)\nHowever, 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.\nPCH is offering support to all councils rated Requires Improvement by the Care Quality Commission on baseline assessments in 2025/6 which request it.\nSwindon Borough Council (SBC)\u2019s Care Quality Commission Report was published in Oct 2025.\nCQC 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.\nCQC quote: \u201cThere 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.\n\u201cGovernance, 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).\u201d\nSwindon 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.\nFrom the above work, and after discussion with the CHIA, the following areas have been identified.\nThese will require system configuration:\n\u2022\tReview and reassessment forms and workflows\n\u2022\tNeeds assessment and support plan forms and workflows\n\u2022\tThe 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\nSBC 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:\n\u2022\tWaiting lists, for all waiting work, at service and team level, including CQC measures\n\u2022\tPerformance reports, at service, team and individual level, including CQC measures\n\u2022\tFully 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)",
    "documents": [
      {
        "datePublished": "2026-01-14T15:40:39Z",
        "description": "Tender notice on Find a Tender",
        "documentType": "tenderNotice",
        "format": "text/html",
        "id": "003193-2026",
        "noticeType": "UK4",
        "url": "https://www.find-tender.service.gov.uk/Notice/003193-2026"
      }
    ],
    "enquiryPeriod": {
      "endDate": "2026-01-26T17:00:00Z"
    },
    "id": "LG-04670",
    "items": [
      {
        "additionalClassifications": [
          {
            "description": "Social work and related services",
            "id": "85300000",
            "scheme": "CPV"
          },
          {
            "description": "Health services",
            "id": "85100000",
            "scheme": "CPV"
          }
        ],
        "deliveryAddresses": [
          {
            "country": "GB",
            "countryName": "United Kingdom",
            "region": "UKK"
          },
          {
            "country": "GB",
            "countryName": "United Kingdom",
            "region": "UKJ"
          },
          {
            "country": "GB",
            "countryName": "United Kingdom",
            "region": "UKI"
          },
          {
            "country": "GB",
            "countryName": "United Kingdom",
            "region": "UKH"
          },
          {
            "country": "GB",
            "countryName": "United Kingdom",
            "region": "UKG"
          },
          {
            "country": "GB",
            "countryName": "United Kingdom",
            "region": "UKF"
          },
          {
            "country": "GB",
            "countryName": "United Kingdom",
            "region": "UKE"
          },
          {
            "country": "GB",
            "countryName": "United Kingdom",
            "region": "UKD"
          },
          {
            "country": "GB",
            "countryName": "United Kingdom",
            "region": "UKC"
          }
        ],
        "id": "1",
        "relatedLot": "1"
      }
    ],
    "legalBasis": {
      "id": "2023/54",
      "scheme": "UKPGA",
      "uri": "https://www.legislation.gov.uk/ukpga/2023/54/contents"
    },
    "lots": [
      {
        "awardCriteria": {
          "criteria": [
            {
              "name": "Price",
              "numbers": [
                {
                  "number": 10,
                  "weight": "percentageExact"
                }
              ],
              "type": "price"
            },
            {
              "description": "Sub criteria\nCapability - 20%\nRelevant skills \u0026 Experience - 30%\nDelivery Methodology - 20%\nAbility to deliver within the set timescale - 20%\nQuality assurance - 10%",
              "name": "Quality",
              "numbers": [
                {
                  "number": 90,
                  "weight": "percentageExact"
                }
              ],
              "type": "quality"
            }
          ]
        },
        "contractPeriod": {
          "endDate": "2027-02-26T23:59:59Z",
          "maxExtentDate": "2027-08-25T23:59:59Z",
          "startDate": "2026-02-09T00:00:00Z"
        },
        "hasRenewal": true,
        "id": "1",
        "renewal": {
          "description": "Funding for the Services is guaranteed up to 31 March 2026 pursuant to a contract between the IDeA and the Department of Health and Social Care (DHSC).\nThe IDeA has been advised that funding from 1 April 2026 is expected to be provided by DHSC by way of grant funding. However, the terms of that grant have not yet been finalised.  Services to be delivered from 1 April 2026 will therefore be conditional upon the IDeA receiving grant funding.\nWhere grant funding is confirmed, the IDeA reserves the right to amend the contract as reasonably necessary to reflect any requirements flowing down from the grant conditions. Any such amendments will be limited to those necessary to ensure compliance with the grant conditions and will not materially alter the nature of the Services.\nIf grant funding is not secured or is materially varied, the IDeA reserves the right to vary the scope of the Services, suspend performance, or terminate the contract in respect of services to be delivered from 1 April 2026, without liability\nThe buyer is entitled at its absolute discretion to extend the contract dependant on securing funding as detailed above in project timescales. Please note extension is not bound by geographical location."
        },
        "status": "active",
        "suitability": {
          "sme": true,
          "vcse": true
        },
        "value": {
          "amount": 39000.0,
          "amountGross": 46800.0,
          "currency": "GBP"
        }
      }
    ],
    "mainProcurementCategory": "services",
    "procurementMethod": "open",
    "procurementMethodDetails": "Below threshold - open competition",
    "status": "active",
    "submissionMethodDetails": "https://app.panacea-software.com/LGA-Sourcing/eRFX-Suppliers/Open.aspx?requirementId=0d18d2e2-acfd-4b39-abbd-0e34d9bd2bcb",
    "submissionTerms": {
      "electronicSubmissionPolicy": "allowed"
    },
    "tenderPeriod": {
      "endDate": "2026-02-02T12:00:00Z"
    },
    "title": "Redesigning Liquidlogic Workflows and Power BI Reporting for Swindon Borough Council",
    "value": {
      "amount": 39000.0,
      "amountGross": 46800.0,
      "currency": "GBP"
    }
  }
}