Award

SPC charts in Power BI

SURREY AND BORDERS PARTNERSHIP NHS FOUNDATION TRUST

This public procurement record has 2 releases in its history.

AwardUpdate

16 Sep 2024 at 13:39

Award Notice
Award

30 Jun 2022 at 14:22

Award Notice
Summary of the contracting process

The procurement process for the project titled "SPC Charts in Power BI" was spearheaded by the Surrey and Borders Partnership NHS Foundation Trust, located in Leatherhead, England. The contract, categorised under "Software supply services" (CPV 72268000), involved a call-off from a framework agreement and was conducted through a selective procurement method. The award stage was completed on 30th June 2022, with the contract running from 1st July 2022 until 30th June 2023. The total contract value is £18,000, and the successful supplier is BCN Group Ltd., based in Manchester, England.

This tender provides substantial opportunities for businesses specialising in software supply, particularly those adept in developing or implementing business intelligence solutions. Companies with experience in creating dynamic and interactive analytics tools using platforms like Microsoft Power BI will find this project particularly relevant. The involvement of compliance with NHS Improvement and Institute for Healthcare Improvement SPC rules and functionalities, such as automated recalculations and near real-time data analysis, makes it an attractive endeavour for large-scale suppliers who can deliver comprehensive and innovative software solutions tailored to healthcare settings.

Find more tenders on our Open Data Platform.
How relevant is this notice?

D3 Tenders Premium

Win More Public Sector Contracts

AI-powered tender discovery, pipeline management, and market intelligence — everything you need to grow your public sector business.

Start Free Trial Book a Demo
All Features Pricing

Notice Information

Notice Title

SPC charts in Power BI

Notice Description

SPC Charts - Standard Access to 5 chart types (Run, C U, P I) Benefits 1. NHS Improvement and Institute for Healthcare Improvement SPC rules compliant 2. Enables users to easily recalculate limits and add annotations 3. Enables control charts for all levels across an entire organisational structure 4. Dynamically drilldown into directorate and service areas 5. Automatically highlights the rules of non-random variation/special cause variation. 6. Enables business users to easily and quickly set/reset baselines 7. Delivers run chart and all 9 industry standard control charts 8. 'Near real time' data analysis to support forward planning 9. Reduces technical resource requirements by automating the SPC recalculation process 10. Quick to implement Power BI custom visuals approach 11. Built with the leading industry standard analytics tool, Microsoft Power BI Features 1. Interactive user-friendly chart wizard for setting/resetting baselines 2. Interactive user-friendly chart wizard for recalculating limits 3. Interactive user-friendly chart wizard for adding annotations 4. Create Run, C, U, P, I charts 5. Automatic highlight of non-random variation, special cause variation 6. Toggle sigma 1 and 2 on or off 7. Customise look and feel of charts (i.e. colouring data points) 8. Add an arrow for the desired direction of travel on the chart 9. Export chart data to create and manipulate in Excel 10. Developed using best practice custom visuals to ensure compatibility

Notice Details

Publication & Lifecycle

Open Contracting ID
ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632
Publication Source
Contracts Finder
Latest Notice
https://www.contractsfinder.service.gov.uk/Notice/1e2fa3fa-1329-41b2-91af-30ebca104187
Current Stage
Award
All Stages
Award

Procurement Classification

Notice Type
Award Notice
Procurement Type
Framework
Procurement Category
Goods
Procurement Method
Selective
Procurement Method Details
Call-off from a framework agreement
Tender Suitability
Not specified
Awardee Scale
Large

Common Procurement Vocabulary (CPV)

CPV Divisions

72 - IT services: consulting, software development, Internet and support

CPV Codes

72268000 - Software supply services

Notice Value(s)

Tender Value
£18,000 Under £100K
Lots Value
Not specified
Awards Value
£18,000 Under £100K
Contracts Value
Not specified

Notice Dates

Publication Date
16 Sep 20241 years ago
Submission Deadline
29 Jun 2022Expired
Future Notice Date
Not specified
Award Date
29 Jun 20223 years ago
Contract Period
30 Jun 2022 - 30 Jun 2023 6-12 months
Recurrence
Not specified

Notice Status

Tender Status
Complete
Lots Status
Not Specified
Awards Status
Active
Contracts Status
Not Specified

Buyer & Supplier

Contracting Authority (Buyer)

Main Buyer
SURREY AND BORDERS PARTNERSHIP NHS FOUNDATION TRUST
Contact Name
Mark Appleton
Contact Email
mark.appleton@sabp.nhs.uk
Contact Phone
07867443500

Buyer Location

Locality
LEATHERHEAD
Postcode
KT22 7AD
Post Town
Kingston upon Thames
Country
England
Major Region (ITL 1)
TLJ South East (England)
Basic Region (ITL 2)
TLJ2 Surrey, East and West Sussex
Small Region (ITL 3)
TLJ26 East Surrey
Delivery Location
Not specified
Local Authority
Mole Valley
Electoral Ward
Leatherhead North
Westminster Constituency
Epsom and Ewell

Supplier Information

Number of Suppliers
1
Supplier Name

BCN GROUP

Further Information

Open Contracting Data Standard (OCDS)

View full OCDS Record for this contracting process

Download

The Open Contracting Data Standard (OCDS) is a framework designed to increase transparency and access to public procurement data in the public sector. It is widely used by governments and organisations worldwide to report on procurement processes and contracts. 

{
    "tag": [
        "compiled"
    ],
    "id": "ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632-2024-09-16T14:39:18+01:00",
    "date": "2024-09-16T14:39:18+01:00",
    "ocid": "ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632",
    "language": "en",
    "initiationType": "tender",
    "tender": {
        "id": "SPC charts in Power BI",
        "title": "SPC charts in Power BI",
        "description": "SPC Charts - Standard Access to 5 chart types (Run, C U, P I) Benefits 1. NHS Improvement and Institute for Healthcare Improvement SPC rules compliant 2. Enables users to easily recalculate limits and add annotations 3. Enables control charts for all levels across an entire organisational structure 4. Dynamically drilldown into directorate and service areas 5. Automatically highlights the rules of non-random variation/special cause variation. 6. Enables business users to easily and quickly set/reset baselines 7. Delivers run chart and all 9 industry standard control charts 8. 'Near real time' data analysis to support forward planning 9. Reduces technical resource requirements by automating the SPC recalculation process 10. Quick to implement Power BI custom visuals approach 11. Built with the leading industry standard analytics tool, Microsoft Power BI Features 1. Interactive user-friendly chart wizard for setting/resetting baselines 2. Interactive user-friendly chart wizard for recalculating limits 3. Interactive user-friendly chart wizard for adding annotations 4. Create Run, C, U, P, I charts 5. Automatic highlight of non-random variation, special cause variation 6. Toggle sigma 1 and 2 on or off 7. Customise look and feel of charts (i.e. colouring data points) 8. Add an arrow for the desired direction of travel on the chart 9. Export chart data to create and manipulate in Excel 10. Developed using best practice custom visuals to ensure compatibility",
        "status": "complete",
        "classification": {
            "scheme": "CPV",
            "id": "72268000",
            "description": "Software supply services"
        },
        "items": [
            {
                "id": "1",
                "deliveryAddresses": [
                    {
                        "postalCode": "KT22 7FG"
                    },
                    {
                        "postalCode": "KT22 7FG"
                    }
                ]
            }
        ],
        "value": {
            "amount": 18000,
            "currency": "GBP"
        },
        "procurementMethod": "selective",
        "procurementMethodDetails": "Call-off from a framework agreement",
        "tenderPeriod": {
            "endDate": "2022-06-30T00:00:00+01:00"
        },
        "contractPeriod": {
            "startDate": "2022-07-01T00:00:00+01:00",
            "endDate": "2023-06-30T23:59:59+01:00"
        },
        "suitability": {
            "sme": false,
            "vcse": false
        },
        "mainProcurementCategory": "goods"
    },
    "parties": [
        {
            "id": "GB-SRS-sid4gov.cabinetoffice.gov.uk/JQyH279D",
            "name": "Surrey and Borders Partnership NHS Foundation Trust",
            "identifier": {
                "legalName": "Surrey and Borders Partnership NHS Foundation Trust",
                "scheme": "GB-SRS",
                "id": "sid4gov.cabinetoffice.gov.uk/JQyH279D"
            },
            "address": {
                "streetAddress": "THIRD FLOOR,LEATHERHEAD HOUSE, STATION ROAD",
                "locality": "LEATHERHEAD",
                "postalCode": "KT227AD",
                "countryName": "England"
            },
            "contactPoint": {
                "name": "Mark Appleton",
                "email": "mark.appleton@sabp.nhs.uk",
                "telephone": "07867443500"
            },
            "roles": [
                "buyer"
            ]
        },
        {
            "id": "GB-COH-06893253",
            "name": "BCN GROUP LTD.",
            "identifier": {
                "legalName": "BCN GROUP LTD.",
                "scheme": "GB-COH",
                "id": "06893253"
            },
            "address": {
                "streetAddress": "Trident Two,Styal Road MANCHESTER M22 5XB GB"
            },
            "details": {
                "scale": "large",
                "vcse": false
            },
            "roles": [
                "supplier"
            ]
        }
    ],
    "buyer": {
        "id": "GB-SRS-sid4gov.cabinetoffice.gov.uk/JQyH279D",
        "name": "Surrey and Borders Partnership NHS Foundation Trust"
    },
    "awards": [
        {
            "id": "ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632-1",
            "status": "active",
            "date": "2022-06-30T00:00:00+01:00",
            "datePublished": "2022-06-30T15:22:15+01:00",
            "value": {
                "amount": 18000,
                "currency": "GBP"
            },
            "suppliers": [
                {
                    "id": "GB-COH-06893253",
                    "name": "BCN GROUP LTD."
                }
            ],
            "contractPeriod": {
                "startDate": "2022-07-01T00:00:00+01:00",
                "endDate": "2023-06-30T23:59:59+01:00"
            },
            "description": "cloud 2",
            "documents": [
                {
                    "id": "1",
                    "documentType": "awardNotice",
                    "description": "Awarded contract notice on Contracts Finder",
                    "url": "https://www.contractsfinder.service.gov.uk/Notice/1e2fa3fa-1329-41b2-91af-30ebca104187",
                    "datePublished": "2022-06-30T15:22:15+01:00",
                    "format": "text/html",
                    "language": "en",
                    "dateModified": "2024-09-16T14:39:18+01:00"
                },
                {
                    "id": "2",
                    "documentType": "contractSigned",
                    "url": "https://www.contractsfinder.service.gov.uk/Notice/Attachment/93af4a23-caf7-4d59-9ae8-8443caac8ab8",
                    "format": "application/pdf"
                }
            ]
        }
    ]
}