---
title: "SPC charts in Power BI"
ocid: "ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632"
canonical_url: "https://d3tenders.com/contract/?ocid=ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632"
markdown_url: "https://d3tenders.com/contract/ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632.md"
json_url: "https://d3tenders.com/contract/ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632.json"
source: "Contracts Finder"
current_stage: "Award"
buyer: "SURREY AND BORDERS PARTNERSHIP NHS FOUNDATION TRUST"
published: "2024-09-16"
---

# SPC charts in Power BI

Buyer: SURREY AND BORDERS PARTNERSHIP NHS FOUNDATION TRUST  
Current stage: Award  
OCID: ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632

[View canonical contract page](https://d3tenders.com/contract/?ocid=ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632)  
[Download OCDS JSON](https://d3tenders.com/contract/ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632.json)

## Summary

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.

## Notice

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

## Key Details

| Field | Value |
| --- | --- |
| Publication source | Contracts Finder |
| Latest notice | https://www.contractsfinder.service.gov.uk/Notice/1e2fa3fa-1329-41b2-91af-30ebca104187 |
| 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 |
| All stages | Award |

## Dates

| Field | Value |
| --- | --- |
| Publication date | 16 Sep 2024 |
| Submission deadline | 29 Jun 2022 |
| Future notice date | Not specified |
| Award date | 29 Jun 2022 |
| Contract period | 30 Jun 2022 - 30 Jun 2023 |
| Recurrence | Not specified |

## Values

| Field | Value |
| --- | --- |
| Tender value | £18,000 |
| Lots value | Not specified |
| Awards value | £18,000 |
| Contracts value | Not specified |

## Status

| Field | Value |
| --- | --- |
| Tender status | Complete |
| Lots status | Not specified |
| Awards status | Active |
| Contracts status | Not specified |

## Buyer

| Field | Value |
| --- | --- |
| Main buyer | SURREY AND BORDERS PARTNERSHIP NHS FOUNDATION TRUST |
| Locality | LEATHERHEAD |
| Post town | Kingston upon Thames |
| Postcode | KT22 7AD |
| Country | England |
| ITL 1 | TLJ South East (England) |
| ITL 2 | TLJ2 Surrey, East and West Sussex |
| ITL 3 | TLJ26 East Surrey |
| Local authority | Mole Valley |
| Electoral ward | Leatherhead North |
| Westminster constituency | Epsom and Ewell |
| Delivery location | Not specified |

## Supplier

| Field | Value |
| --- | --- |
| Number of suppliers | 1 |
| Supplier names | BCN GROUP |

## CPV Codes

### Divisions

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

### Codes

- 72268000 - Software supply services

## Release History

- 16 Sep 2024 at 13:39 - AwardUpdate - Award Notice - https://www.contractsfinder.service.gov.uk/Notice/1e2fa3fa-1329-41b2-91af-30ebca104187
- 30 Jun 2022 at 14:22 - Award - Award Notice - https://www.contractsfinder.service.gov.uk/Notice/1e2fa3fa-1329-41b2-91af-30ebca104187

## Documents

- https://www.contractsfinder.service.gov.uk/Notice/1e2fa3fa-1329-41b2-91af-30ebca104187
  16th September 2024 - Awarded contract notice on Contracts Finder
- https://www.contractsfinder.service.gov.uk/Notice/Attachment/93af4a23-caf7-4d59-9ae8-8443caac8ab8

## Provenance

This Markdown file is an alternate public rendering of the D3 Tenders contract record. The canonical page is https://d3tenders.com/contract/?ocid=ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632. The underlying structured data is available as OCDS JSON at https://d3tenders.com/contract/ocds-b5fd17-e2c3afd8-a87a-4029-bcdf-fac3e10bc632.json.