West London Mental Health NHS Trust

West London Mental Health Trust Business Intelligence Platform

Incomplete applications

7
Incomplete applications
4 SME, 3 large

Completed applications

6
Completed applications
6 SME, 0 large
Important dates
Opportunity attribute name Opportunity attribute value
Published Wednesday 7 June 2017
Deadline for asking questions Wednesday 14 June 2017 at 11:59pm GMT
Closing date for applications Wednesday 21 June 2017 at 11:59pm GMT

Overview

Overview
Opportunity attribute name Opportunity attribute value
Summary of the work The Trust wishes to procure a self-service Business Intelligence solution to meet the requirements further detailed in this document, including support, maintenance and a partner organisation.
Latest start date Monday 17 July 2017
Expected contract length 1 year initially plus options to extend further for one year
Location London
Organisation the work is for West London Mental Health NHS Trust
Budget range Live only Server Software License
Capabilities to support a Live environment only
Staff Developer Licenses
20 x developer licenses to support staff to Subject Matter Expert Level
End user licenses
500 x end user licenses. To support easy scalability and future staffing requirements.
Maintenance
Annual Maintenance Costs
Training
Training costs as detailed in section 10
Miscellaneous Costs
Any additional costs which cannot be allocated as above. With a detailed breakdown
Development Server Software License
Capabilities to support a Development environment for up to 20 developers

About the work

About the work
Opportunity attribute name Opportunity attribute value
Why the work is being done West London Mental Health Trust requires a Business Intelligence Platform to help centralise and modernise their Business Intelligence Capabilities.
The Trust’s immediate vision for business intelligence is to effectively utilise data and information to:
better support front line staff in the delivery of safe, effective and client-centred care
help improve the performance of individual staff members, team(s) and in turn the entire organisation by ensuring that “right information” is available at “right time” to “right individuals” in “right format” to facilitate “right decision” making
support the Trust in its drive towards improving proactive working culture as against reactive approach
Problem to be solved The Trusts Informatics Solutions are based on outdated bespoke technologies including:
Microsoft SQL 2008R2
Microsoft SQL 2012
Microsoft SSRS
Microsoft SSAS
Microsoft SSIS
Qlikview
ASP.net developments
.Net developments
Microsoft Excel
Microsoft Access
Data is distributed in siloes without commonality and no single point of the truth exists. The Trust has limited self-service dashboards and no real time analytical capabilities. Work has commenced to create a validated and assured data warehouse, West London Business Intelligence (WLBI), using the principles of Kimball Fact and Dimensional Modelling utilising the latest technologies in SQL Server 2016.
Who the users are and what they need to do A Business Intelligence and Analytical Platform
A scalable, changeable and flexible licensing model
Support for twenty power users\developers
An immediate requirement for 500 end users scalable but not limited up to 4000 users
Native and intelligent support for NHS datasets
Native and intelligent support for geographical and spatial systems
Native and intelligent support for predictive data modelling and statistical analytics
On-going support, maintenance, warranties and upgrades
Training to support an initial workforce to become subject matter experts
Training literature, materials and support for end users
Early market engagement Integration with Microsoft SQL Server 2008R2, 2012, 2016 and scalable to support newer versions of Microsoft SQL Server when available
Support for Kimball Dimensional Modelling
Support for Columnstore Indexes
Integration with several data sources across T-SQL, Flat files and other database technologies
Support for OLTP and OLAP databases
Live and Development Environment capabilities
Capability to link to Source Control and repository tools like Redgate Tools and MS Team Foundation Server
Any work that’s already been done The scope of this procurement does not include:
Physical onsite hardware requirements
Data warehouse development
Existing team Integration with Microsoft Internet Explorer 11.0 and Google Chrome
Agile and future proof support in a mobile capacity for iOS, Android and Windows 10 without limitations on future OS versions
Both onsite and offsite deployment models within the boundaries of the NHS Information Governance requirements and seamless support for transition between both models
Integration with Microsoft SQL Server 2008R2, 2012, 2016 and scalable to support newer versions of Microsoft SQL Server when available
Support for Kimball Dimensional Modelling
Support for Columnstore Indexes
Integration with several data sources across T-SQL, Flat files and other database technologies
Support for OLTP and OLAP
Current phase Discovery

Work setup

Work setup
Opportunity attribute name Opportunity attribute value
Address where the work will take place West London Mental Health Trust
Knowledge Management
Trust Headquarters
1 Armstrong Way
Southall
Middlesex
UB2 4SA
Working arrangements The supplier shall be fully responsible for all aspects of Health and Safety in relation to their solution(s). The supplier shall be required to adhere to the Trust’s health and safety polices at all times.
The supplier shall be required to work with members of Trust staff, contractors and other 3rd party suppliers to successfully deliver the services to the requirements of the Trust. No additional costs shall be considered for working with others, unless specifically agreed in advance with the Trust.
Security clearance Employees sent to work at the Trust’s sites must enter the premises only via the official entrance and report there each day on arrival.

Employees who work at the Trust’s sites on a regular basis may be required to give their address, photograph to be taken and a criminal check.

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
  • A Business Intelligence and Analytical Platform
  • A scalable, changeable and flexible licensing model
  • Support for twenty power users\developers
  • An immediate requirement for 500 end users scalable but not limited up to 4000 users
  • Native and intelligent support for NHS datasets
  • Native and intelligent support for geographical and spatial systems
  • Native and intelligent support for predictive data modelling and statistical analytics
  • On-going support, maintenance, warranties and upgrades
  • Training to support an initial workforce to become subject matter experts
  • Training literature, materials and support for end users
  • Integration with Microsoft Internet Explorer 11.0 and Google Chrome
  • Agile and future proof support in a mobile capacity for iOS, Android and Windows 10 without limitations on future OS versions
  • Both onsite and offsite deployment models within the boundaries of the NHS Information Governance requirements and seamless support for transition between both models
  • Integration with Microsoft SQL Server 2008R2, 2012, 2016 and scalable to support newer versions of Microsoft SQL Server when available
  • Support for Kimball Dimensional Modelling
  • Support for Columnstore Indexes
  • Integration with several data sources across T-SQL, Flat files and other database technologies
  • Support for OLTP and OLAP databases
  • Live and Development Environment capabilities
  • Capability to link to Source Control and repository tools like Redgate Tools and MS Team Foundation Server
Nice-to-have skills and experience
  • The supplier is requested to provide to references / case studies for similar existing customers / contracts.
  • The proposed references / case studies should meet the Trust’s requirements as detailed in Section 2.
  • The supplier acknowledges that the Trust may contact these reference customers for formal references.

How suppliers will be evaluated

How suppliers will be evaluated
Opportunity attribute name Opportunity attribute value
How many suppliers to evaluate 3
Proposal criteria
  • As part of the procurement phase suppliers will be invited to design a Proof of Concept dashboard within their chosen BI Platform within a controlled environment. The design shall include:
  • How the proposed solution will be configured to meet The Trust’s requirements
  • How the proposed solution will integrate with the existing BI Development infrastructures
  • How the proposed solution will integrate with the existing ICT infrastructures
  • 8 physical cores, 2.6 GHz or higher CPU
  • 64-bit processor
  • 256 GB system memory
  • How the proposed solution will integrate with the existing ICT virtualised infrastructures
  • How the proposed solution can be migrated from an onsite to offsite hosted location
  • A detailed bespoke anonymised NHS Mental Health dataset will be provided during a timed workshop session.
Cultural fit criteria
  • The Trust requires high quality training for all power users\developers to ensure they become internal Subject Matter Experts in supplier’s platform.
  • The training is required to cover all aspects of the platform in structured training sessions that have been specifically tailored to the Trust’s requirements.
  • The supplier shall confirm how training will be provided and describe how they will work with the Trust to agree the most appropriate training methods to be used.
  • The supplier shall provide literature, materials and support to train end users in house to ensure staff are skilled at a required level for end user purposes.
  • The supplier shall support future iterations of the BI Platform and develop and enhance training and ensure the Trust can maintain a suitably educated workforce.
Payment approach Fixed price
Assessment methods
  • Written proposal
  • Reference
  • Presentation
Evaluation weighting

Technical competence

35%

Cultural fit

5%

Price

60%

Questions asked by suppliers

Questions asked by suppliers
Supplier question Buyer answer
1. The payment terms are fixed price, yet there is a significant amount of work to be done to understand the full requirements, even to do the proposal demo. Why does the Trust not ask only for a fixed price Discovery at this stage to permit suppliers to gather all requirements and then be in a better position to commit to a fixed price? We are happy with the approach already detailed in the documentation to date.
2. Our delivery model is a blended on and offsite model, with the majority being undertaken offsite. Is this an acceptable delivery model? More information is required and this will need to be discussed in more detail before we are able to answer this question.
3. Will the incumbent be bidding for this opportunity? There is no incumbent supplier.
4. The proposal requires a demo of a proof of concept, almost an Alpha. Will the Trust pay for this work? Second, what resources will the Trust make available from its own resources for a mini-Discovery to deliver this PoC? Finally, what would be the timescales from being selected to delivering the Proposal with the demo? 1) The Trust will not be paying for the Proof of Concept solution directly.
2) A dataset of patient demographics and activity will be shared in a SQL 2016 database two days before the supplier sessions. Suppliers will then demonstrate the development process and the final dashboard to meet the requirements.
3) 21/06/2017 & 22/06/2017.
5. Is there an incumbent supplier? There is no incumbent supplier.
6. Does the Trust have any idea of budget? Yes a budget is in place based on market research to date.
7. Good Afternoon, Is the scope of the requirements to deliver a data warehouse or is the data warehouse in existence and we will be delivering a BI solution on top of this? If the data warehouse already exists will be required to develop this further? Thank you Data warehouse development is out of scope. The chosen supplier will be required to interface directly with the data warehouse.
8. Good afternoon Is there a requirement to deliver the solution on premises or is the client willing to use a cloud based solution which connects to locally held data? Are there any restrictions in place around using a cloud based solution? Any cloud based solution would need to meet the requirements as specified in ISO 27001. Further considerations would need to be discussed within the Trust to facilitate a move to a cloud based solution and possible storage of data off site in the future.
9. Good Afternoon, 2. Do the department have an ELA with Microsoft? If so what is intended by the criteria: “A scalable, changeable and flexible licensing model” What is meant by “intelligent support for NHS datasets” What is meant by “intelligent support for geographical and spatial systems” What is meant by “intelligent support for predictive data modelling and statistical analytics” Thank you The Trust does not currently have an Enterprise Level Agreement in place with Microsoft for the purpose of Office 365 or an analytical product.
10. Good Morning, Will the trust source required licenses for software tools used to implement the BI solution or will the awarded supplier be responsible for sourcing the required licences? Thank you The awarded supplier will be responsible for sourcing the initial licensing model.
11. The pricing section mentions a requirement for developer licenses. Does the Trust have a preferred BI solution or technical language that they wish to develop on, in line with staff competencies? The Trust does not have a preference at this time providing the supplier's solution can meet the Trust requirements.
12. A Q&A session is stated to be on 23/06/2017 and there is also reference to timed workshop where data is made available for the POC – are these 2 separate events? It is also stated a dataset is to be shared 2 days before the supplier sessions and timelines are 21/06/2017 & 22/06/2017 which wouldn’t give sufficient time from the application closing date? Please can you clarify when the data will be made available and when the workshop will be held? Many thanks The data for the PoC will be shared on 21st June and the PoC session will be on the 23rd June. At the PoC session the supplier will be required to demonstrate their solution and the development process behind it.
13. what is the approximate number of reports and dashboards which needs to be developed and the time frame for the same? We are unable to detail this in full currently. We expect at least 10 dashboards to be made available to the Trust throughout the remainder of 2017/2018.
14. Hi, Under 'nice to have skills' you ask Evidence of The proposed references / case studies should meet the Trust’s requirements as detailed in Section 2. Can you please be specific about where section 2 is as its not apparent? Thanks The requirements related to the sections Skills and experience and How suppliers will be evaluated in section Proposal criteria.
15. considering Qlick view is laready deployed. Would you be looking at enhancing your Qlick implementation or are you open to consider other cloud solutions? A Qlik solution is not currently deployed or in use at the Trust. It has been historically.