Notice Information
Notice Title
C001940 - NES People Data Platform Data Services Support
Notice Description
NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI.
Lot Information
Lot 1
NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI.. The value of the initial contract period is 39,000 GBP. Should the options to extend (2 x 12 months) be taken then the maximum value over the 3years would not exceed 109,000GBP.
Renewal: NES propose to award the contract for the period from March 2022 to 31st March 2023 with the option to extend by 2 x 12 months, subject to identification of further priorities and associated budget.
Notice Details
Publication & Lifecycle
- Open Contracting ID
- ocds-r6ebe6-0000683727
- Publication Source
- Public Contracts Scotland
- Latest Notice
- https://www.publiccontractsscotland.gov.uk/search/show/search_view.aspx?ID=MAR444179
- Current Stage
- Award
- All Stages
- Tender, Award
Procurement Classification
- Notice Type
- PCS Notice - Website Contract Award Notice
- Procurement Type
- Standard
- Procurement Category
- Services
- Procurement Method
- Open
- Procurement Method Details
- Open procedure
- Tender Suitability
- Not specified
- Awardee Scale
- SME
Common Procurement Vocabulary (CPV)
- CPV Divisions
72 - IT services: consulting, software development, Internet and support
-
- CPV Codes
72222300 - Information technology services
Notice Value(s)
- Tender Value
- Not specified
- Lots Value
- Not specified
- Awards Value
- Not specified
- Contracts Value
- £109,000 £100K-£500K
Notice Dates
- Publication Date
- 23 Mar 20223 years ago
- Submission Deadline
- 9 Mar 2022Expired
- Future Notice Date
- Not specified
- Award Date
- 21 Mar 20223 years ago
- Contract Period
- 21 Mar 2022 - 31 Mar 2023 1-2 years
- Recurrence
- Not specified
Notice Status
- Tender Status
- Complete
- Lots Status
- Complete
- Awards Status
- Not Specified
- Contracts Status
- Active
Buyer & Supplier
Contracting Authority (Buyer)
- Main Buyer
- NHS EDUCATION FOR SCOTLAND
- Contact Name
- Not specified
- Contact Email
- tenders@nes.scot.nhs.uk
- Contact Phone
- +44 1316563200
Buyer Location
- Locality
- EDINBURGH
- Postcode
- EH3 9DN
- Post Town
- Edinburgh
- Country
- Scotland
-
- Major Region (ITL 1)
- TLM Scotland
- Basic Region (ITL 2)
- TLM1 East Central Scotland
- Small Region (ITL 3)
- TLM13 City of Edinburgh
- Delivery Location
- TLM Scotland
-
- Local Authority
- City of Edinburgh
- Electoral Ward
- City Centre
- Westminster Constituency
- Edinburgh East and Musselburgh
Further Information
Notice Documents
-
https://www.publiccontractsscotland.gov.uk/search/show/search_view.aspx?ID=FEB441017
C001940 - NES People Data Platform Data Services Support - NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI. -
https://www.publiccontractsscotland.gov.uk/search/show/search_view.aspx?ID=MAR444179
C001940 - NES People Data Platform Data Services Support - NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI.
Open Contracting Data Standard (OCDS)
View full OCDS Record for this contracting process
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-r6ebe6-0000683727-2022-03-23T00:00:00Z",
"date": "2022-03-23T00:00:00Z",
"ocid": "ocds-r6ebe6-0000683727",
"initiationType": "tender",
"parties": [
{
"id": "org-83",
"name": "NHS Education for Scotland",
"identifier": {
"legalName": "NHS Education for Scotland"
},
"address": {
"streetAddress": "2nd Floor, Westport, 102 Westport",
"locality": "EDINBURGH",
"region": "UKM75",
"postalCode": "EH3 9DN"
},
"contactPoint": {
"email": "tenders@nes.scot.nhs.uk",
"telephone": "+44 1316563200",
"url": "http://www.publictendersscotland.publiccontractsscotland.gov.uk"
},
"roles": [
"buyer",
"centralPurchasingBody"
],
"details": {
"classifications": [
{
"id": "Body governed by public law",
"scheme": "TED_CA_TYPE"
},
{
"id": "07",
"description": "Health",
"scheme": "COFOG"
}
],
"url": "http://www.nes.scot.nhs.uk"
}
},
{
"id": "org-31",
"name": "Edinburgh Sheriff Court",
"identifier": {
"legalName": "Edinburgh Sheriff Court"
},
"address": {
"streetAddress": "27 Chambers Street",
"locality": "Edinburgh"
},
"contactPoint": {
"url": "http://"
},
"roles": [
"reviewBody"
]
},
{
"id": "org-6",
"name": "NHS Education for Scotland",
"identifier": {
"legalName": "NHS Education for Scotland"
},
"address": {
"streetAddress": "2nd Floor, Westport, 102 Westport",
"locality": "EDINBURGH",
"region": "UKM75",
"postalCode": "EH3 9DN"
},
"contactPoint": {
"email": "tenders@nes.scot.nhs.uk",
"telephone": "+44 1316563200",
"url": "http://"
},
"roles": [
"buyer"
],
"details": {
"classifications": [
{
"id": "Body governed by public law",
"scheme": "TED_CA_TYPE"
},
{
"id": "07",
"description": "Health",
"scheme": "COFOG"
}
],
"url": "http://www.nes.scot.nhs.uk"
}
},
{
"id": "org-199",
"name": "Numbertelling ltd",
"identifier": {
"legalName": "Numbertelling ltd"
},
"address": {
"streetAddress": "Codebase, Argyle House, 3 Lady Lawson Street",
"locality": "Edinburgh",
"region": "UKM75",
"postalCode": "EH3 9DR"
},
"contactPoint": {
"telephone": "+44 7707699565"
},
"roles": [
"supplier"
],
"details": {
"scale": "sme",
"url": "http://"
}
},
{
"id": "org-5",
"name": "Edinburgh Sheriff Court",
"identifier": {
"legalName": "Edinburgh Sheriff Court"
},
"address": {
"streetAddress": "Sheriff Court House, 27 Chambers Street",
"locality": "Edinburgh",
"postalCode": "EH1 1LB"
},
"contactPoint": {
"url": "http://"
},
"roles": [
"reviewBody",
"mediationBody",
"reviewContactPoint"
]
}
],
"buyer": {
"name": "NHS Education for Scotland",
"id": "org-6"
},
"tender": {
"id": "C001940",
"title": "C001940 - NES People Data Platform Data Services Support",
"description": "NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI.",
"status": "complete",
"items": [
{
"id": "1",
"additionalClassifications": [
{
"id": "72222300",
"scheme": "CPV"
}
],
"deliveryAddresses": [
{
"region": "UKM"
},
{
"region": "UKM"
}
],
"relatedLot": "1"
}
],
"procurementMethod": "open",
"procurementMethodDetails": "Open procedure",
"mainProcurementCategory": "services",
"submissionMethod": [
"electronicSubmission"
],
"submissionMethodDetails": "http://www.publictendersscotland.publiccontractsscotland.gov.uk",
"tenderPeriod": {
"endDate": "2022-03-09T13:00:00Z"
},
"awardPeriod": {
"startDate": "2022-03-09T13:00:00Z"
},
"documents": [
{
"id": "FEB441017",
"documentType": "contractNotice",
"title": "C001940 - NES People Data Platform Data Services Support",
"description": "NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI.",
"url": "https://www.publiccontractsscotland.gov.uk/search/show/search_view.aspx?ID=FEB441017",
"format": "text/html"
},
{
"id": "economic",
"documentType": "economicSelectionCriteria"
},
{
"id": "technical",
"documentType": "technicalSelectionCriteria"
},
{
"id": "MAR444179",
"documentType": "awardNotice",
"title": "C001940 - NES People Data Platform Data Services Support",
"description": "NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI.",
"url": "https://www.publiccontractsscotland.gov.uk/search/show/search_view.aspx?ID=MAR444179",
"format": "text/html"
}
],
"lots": [
{
"id": "1",
"description": "NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI.. The value of the initial contract period is 39,000 GBP. Should the options to extend (2 x 12 months) be taken then the maximum value over the 3years would not exceed 109,000GBP.",
"status": "complete",
"hasOptions": false,
"submissionTerms": {
"variantPolicy": "notAllowed"
},
"contractPeriod": {
"startDate": "2022-03-21T00:00:00Z",
"endDate": "2023-03-31T00:00:00Z"
},
"hasRenewal": true,
"renewal": {
"description": "NES propose to award the contract for the period from March 2022 to 31st March 2023 with the option to extend by 2 x 12 months, subject to identification of further priorities and associated budget."
}
}
],
"bidOpening": {
"date": "2022-03-09T13:00:00Z"
},
"coveredBy": [
"GPA"
],
"submissionTerms": {
"languages": [
"en"
]
},
"classification": {
"id": "72222300",
"scheme": "CPV"
},
"hasRecurrence": false
},
"language": "EN",
"description": "(SC Ref:687669)",
"links": [
{
"rel": "canonical",
"href": "https://api.publiccontractsscotland.gov.uk/v1/Notice?id=ocds-r6ebe6-0000683727"
},
{
"rel": "canonical",
"href": "https://api.publiccontractsscotland.gov.uk/v1/Notice?id=ocds-r6ebe6-0000683727"
}
],
"noticetype": "PCS Notice - Website Contract Award Notice",
"awards": [
{
"id": "C001940",
"suppliers": [
{
"id": "org-199",
"name": "Numbertelling ltd"
}
],
"relatedLots": [
"1"
]
}
],
"contracts": [
{
"id": "C001940",
"awardID": "C001940",
"status": "active",
"value": {
"amount": 109000,
"currency": "GBP"
},
"dateSigned": "2022-03-21T00:00:00Z"
}
],
"bids": {
"statistics": [
{
"id": "583",
"measure": "bids",
"value": 3,
"relatedLot": "1"
},
{
"id": "584",
"measure": "smeBids",
"value": 3,
"relatedLot": "1"
},
{
"id": "585",
"measure": "foreignBidsFromEU",
"value": 0,
"relatedLot": "1"
},
{
"id": "586",
"measure": "foreignBidsFromNonEU",
"value": 3,
"relatedLot": "1"
},
{
"id": "587",
"measure": "electronicBids",
"value": 3,
"relatedLot": "1"
}
]
}
}