Mid and South Essex University Hospitals Group

MSE Group Data warehouse

Incomplete applications

26
Incomplete applications
20 SME, 6 large

Completed application

1
Completed application
1 SME, 0 large
Important dates
Opportunity attribute name Opportunity attribute value
Published Tuesday 14 January 2020
Deadline for asking questions Tuesday 21 January 2020 at 11:59pm GMT
Closing date for applications Tuesday 28 January 2020 at 11:59pm GMT

Overview

Overview
Opportunity attribute name Opportunity attribute value
Summary of the work Design, build and deployment of a MS Azure based data warehouse and Power BI reporting solution using data feeds from the existing data warehouses and source systems including Lorenzo, Medway and Somerset Cancer Registry
Latest start date Monday 10 February 2020
Expected contract length approximately three months
Location East of England
Organisation the work is for Mid and South Essex University Hospitals Group
Budget range

About the work

About the work
Opportunity attribute name Opportunity attribute value
Why the work is being done The three Trusts in the Mid and South Essex University hospitals group will be merging into a single Trust in April 2020 and there will be a requirement for the Healthcare Analytics service to be able to report activity and waiting list information at a group level using data from each existing Trust.

Alongside the Trust merger the corporate services including Finance, IT, HR and Healthcare Analytics have restructured from site based operating models to group based versions. These services are now co-located in the corporate hub in Southend.

Part of the Digital Services (formerly IT) strategy is to implement a hybrid cloud solution to implement a MS Azure cloud environment and to refresh the on premise server architecture. The proposed solution to enable group level reporting is to implement a cloud based data warehouse and Power BI reporting.
Problem to be solved Each of the three existing Trusts has a suite of reports available to users in a variety of different reporting tools including Excel, Powerpoint, QlikView, SSRS and web based reports. Data for these reports is sourced from three main data warehouses (one for each site) along with feeds from other clinical systems. Going forward the plan is to implement a group based data warehouse hosted in the cloud and fed from the existing site based data warehouses along with a Power BI reporting environment to enable the deployment of a single suite of dashboards and reports to users across the group. Currently group level reporting can only be provided using Excel and PowerPoint. The existing architecture will remain in place to support site based reporting. As group based reports are deployed the expectation is that site based versions will be phased out.
Who the users are and what they need to do The users of the solution can be split into Healthcare Analytics staff who will act as developers, designing, building and deploying Power BI reports and also using Power BI to interrogate data to provide information and insight. Managers and operational staff will also use the reporting to run the business and operate services effectively.
Early market engagement
Any work that’s already been done A discovery exercise has been completed by Adatis to assess the existing technology and architecture at each of the three Trusts, the requirements of the new data warehouse and scope of work, the required pre-requisites and organisational readiness to implement an Azure cloud environment and Power BI reporting. The discovery work also included a recommended solution.
Existing team The Healthcare Analytics service comprises 40 staff and will be expected to work with the Digital Services team to develop and maintain the existing site data warehouses and the new group one and also to design, build and deploy reporting using Power BI. Members of the team will also act as users of the final reports to interrogate data to provide information, insight and understanding to operational colleagues across the group.
Current phase Live

Work setup

Work setup
Opportunity attribute name Opportunity attribute value
Address where the work will take place MSE Group Corporate Services Hub, Comet Way, Southend-on-Sea, SS2 6GE
Working arrangements There will be a requirement for the supplier to be on site in order to hold face-to-face meetings with members of Healthcare Analytics and to work collaboratively with the team in order to deliver the proposed solution. Off-site and remote working is also expected to complete other elements of the build.
Security clearance Privacy impact assessment forms will need to be completed for this assignment

Additional information

Additional information
Opportunity attribute name Opportunity attribute value
Additional terms and conditions

Skills and experience

Buyers will use the essential and nice-to-have skills and experience to help them evaluate suppliers’ technical competence.

Skills and experience
Opportunity attribute name Opportunity attribute value
Essential skills and experience
  • Supplier must provide evidence that they have implemented a MS Azure environment and Power BI reporting solution using multiple feeds from different systems (5%)
  • Supplier must provide evidence that they have a detailed understanding of the different activity and waiting list data flows within an NHS acute hospital environment (5%)
Nice-to-have skills and experience
  • evidence that they have a thorough understanding of the different components of MS Azure and are able to incorporate the latest developments and products into the final solution (2%)
  • evidence that they have designed, built and deployed Power BI reports to an NHS organisation (3%)
  • demonstrate experience of providing training and knowledge transfer to customer organisations as part of previous customer engagements (3%)
  • evidence providing a range of maintenance agreements and support contracts with customer organisations (2%)

How suppliers will be evaluated

All suppliers will be asked to provide a written proposal.

How suppliers will be evaluated
Opportunity attribute name Opportunity attribute value
How many suppliers to evaluate 3
Proposal criteria
  • response to discovery paper (30%)
  • supporting case study (5%)
Cultural fit criteria Demonstrates the ability to work in a transparent and collaborative manner with the ability to engage and work with end users at all levels (5%)
Payment approach Fixed price
Additional assessment methods Case study
Evaluation weighting

Technical competence

55%

Cultural fit

5%

Price

40%

Questions asked by suppliers

No questions have been answered yet

Log in to ask a question