RM1043.8-1-The Dudley Group NHS Foundation Trust -Provision of Power BI Premium Service and Power BI Mobile Reporting

Description

Summary of work The Trust is looking to provision a reporting platform in Power BI Premium to host a number of reports to allow desktop and mobile reporting to end-users within the Trust and in the wider NHS. The Trust currently hosts a number of Power BI and SSRS reports in Power BI Server and Report Manager respectively. Both reporting platforms reside on-premise. The following is a list of requirements: 1) Assist in provisioning of the Power BI Premium Service platform - Liaise with the Microsoft Partner to obtain licenses and provision the Power BI Premium platform - Configure all aspects of the Power BI platform to allow for easy administration of content, user management, security - Configure and deploy the required resources within the existing Data Platform in Azure and On-premise, to allow the content deployed to Power BI Service to securely connect and transfer data from a variety of data sources in a timely manner - Advise which Azure Active Directory the Power BI Premium Service would be best suited to be deployed to (Trust’s AAD vs NHS AAD), taking into account the Trust’s accessibility and other systems integration requirements, and deploy the Power BI Premium platform implementing the agreed approach - Advise and implement the appropriate approach to arrange Workspaces and Apps to allow for easy development\testing of new content and to associate the existing content on-premise with Workspaces for end-user access - Advise on the best approach to the full development cycle of the content (Azure DevOps Pipelines, Power BI Automation Tools Extension, etc) and provide real-life examples within the Trust’s existing Azure DevOps Organization - Configure any other aspects of the Power BI Premium Service to ensure successful deployment of the platform in an enterprise setting - Provide training sessions to the Trust members, which cover the following areas: a) Power BI administration, maintenance, monitoring, troubleshooting b) Development and deployment of Power BI content (paginated reports, dashboards, datasets, dataflows) c) Version control of the Power BI content - Provide the documentation for the Platform 2) Deliver a number of Power BI mobile-friendly dashboards - Create a number of new, mobile-friendly dashboards based on existing dashboards, so that the information contained in them is clear and easy to read on mobile devices, taking into account all the principles of visual communication - Create report templates for both desktop and mobile reports for the Trust to reuse in the future developments, according to Trust’s specification - Create shared datasets for the mobile reports Where the supplied staff will work No specific location (for example they can work remotely) Who the organisation using the products or services is Dudley Group NHS Foundation Trust Why the work is being done Securely provision desktop and mobile reporting to end-users within the Trust and in the wider NHS The business problem Access to Power BI reports from anywhere on any device at any time by provisioning, configuring secure role based access via active directory, full lifecycle development and testing of mobile friendly dashboards including template set-up for re-use and data modelling . The people who will use the product or service User type: Staff detailed below Definition: IT Operations IT Governance and Cyber Security IT Strategy and Design Any pre-market engagement done None Work done so far DGFT have migrated our two data warehouses to the Azure cloud. The Trust currently hosts a number of Power BI and SSRS reports in Power BI Server and Report Manager respectively. Both reporting platforms reside on-premise. Which phase the project is in Discovery Existing team DGFT has an Analytics and Insight (Informatics) Team that would direct the preferred supplier to deliver the solution with input from IT (Operations, Governance and Cyber Security) and business users. Address where the work will be done Remote. Working arrangements Remote. Security and vetting requirements No security clearance needed Latest start date 27 March 2023 Expected contract length Contract length: 0 years 3 months 0 days Optional extension: 0 years 1 months 15 days Special terms and conditions special term or condition: None Budget Indicative maximum: £45000 Indicative minimum: The contract value is not specified by the buyer Contracted out service or supply of resource? Supply of resource: the off-payroll rules may apply Terms and acronyms Term or acronym: DGFT Definition: Dudley Group NHS Foundation Trust Term or acronym: IT Definition: Information Technology Questions and Clarifications 1. Are you able to provide an approximate list of these 20 reports and how many pages are contained within each one? Mix of acute and community services, cyber, and digital, data and technology.  Nu, of pages will be determined during final selection of 20 reports and how they would be best optimised for mobile." Last Updated : <strong>14/03/2023</strong> 2. Can you please advise on the below clarification questions: Can you please advise if the only questions which are required to be filled out are the ones listed in the spreadsheet? All questions are in the Techinical Spreadhseet which you need to fill on the portal. Last Updated : <strong>14/03/2023</strong> 3. In the attachment 3, there is a nice to have section but there is no space allocated to answer this question within the spreadsheet. Can you advise if this needs to be completed at this stage? Additionally, it refers to pricing in this section but there is no question allocated to pricing in the spreadsheet, is this required at this stage or can we add this into the spreadsheet? The nice to have section is for information only. We have informed you of the price cap ie the total budget which is £45k + VAT, Suppliers can submit a proposal in your own format. Please donot include any Terms or Conditions which would conflict with the framework.Bids will automatically be rejected if over stated budget. Last Updated : <strong>14/03/2023</strong> 4. Can we submit an additional document with further information on please? Yes , as long as the documentations is supported a question/answer response. Last Updated : <strong>14/03/2023</strong> 5. What is the total number of expected users that will need access to Power BI Service? Initial phase will be up to 250. Last Updated : <strong>14/03/2023</strong> 6. Will all these users be in internal? Or a mix of internal and some external to the Dudley Group? Mix of internal and external Last Updated : <strong>14/03/2023</strong> 7. Power BI Premium is based on a dedicated capacity nodes that differ in price by core/GB spec - Does Dudley know which SKU (stock keeping unit) of P1, P2, P3 they would like to utilise at this present time? Not yet and not needed for response Last Updated : <strong>14/03/2023</strong> 8. What is the monthly budget allocated by Dudley for a Premium subscription? DGFT will cover costs of premium subscription Last Updated : <strong>14/03/2023</strong> 9. How many Pro licenses will be required on top of the Premium subscription? (Pro licenses would be required for report authors/curators to publish new/amend Power BI Reports on the Premium capacity – at an additional monthly cost per user (beyond the monthly Premium subscription) What are the data sources currently used by Dudley Group? (Can you list or say how many) What are the data sizes of the datasets to be included? Not needed for response.DGFT will cover costs of premium subscription. Last Updated : <strong>14/03/2023</strong> 10. Where are the existing data sources (On premises/cloud/both)? Both. Last Updated : <strong>14/03/2023</strong> 11. What is the expected refresh schedule/rate of the above data sources in Power BI? To be confirmed as part of implementation Last Updated : <strong>14/03/2023</strong> 12. How many new Power BI reports are required to be built? Of these new Power BI reports to be built - how many will need to be optimised and have a mobile friendly UI/Layout? Question 7 in Technical Criteria ‘Please demonstrate how DGFT would obtain a fully provisioned Power BI Premium Service and Mobile Reporting for 20 existing key reports’ ¬– these reports would be migrated to the Premium capacity workspace(s) would all these 20 reports require mobile device optimisation or just a select few? 20 of which most already exist Of these new Power BI reports to be built - how many will need to be optimised and have a mobile friendly UI/Layout?  All 20.  Note that optimisation of existing code for these 20 dashboards to make queries more efficient is also specified. "these reports would be migrated to the Premium capacity workspace(s) would all these 20 reports require mobile device optimisation or just a select few? All 20.  Note that optimisation of existing code for these 20 dashboards to make queries more efficient is also specified." Last Updated : <strong>14/03/2023</strong> 13. The current phase is listed as Discovery and the indicative budget is £45k. Please can you confirm if this is the budget for the Discovery phase only or the implementation as well ? Budget includes full implementation of scope Last Updated : <strong>15/03/2023</strong> 14. Please confirm what potential suppliers must respond to. It is usual with DOS to respond to the "Essential" and "Nice-To-Have" requirements with an example upto 750 characters following which shortlisting occurs. Under Nice-to-have is states that this is a single stage process. Therefore do you require potential suppliers to respond to all of the elements at this stage. Yes, respond to all questions for a single stage process Last Updated : <strong>15/03/2023</strong> 15. Please confirm what potential suppliers must respond to. It is usual with DOS to respond to the "Essential" and "Nice-To-Have" requirements with an example upto 750 characters following which shortlisting occurs. Under Nice-to-have is states that this is a single stage process. Therefore do you require potential suppliers to respond to all of the elements at this stage. Yes, respond to all questions for a single stage process Last Updated : <strong>15/03/2023</strong> 16. It is exceptionally difficult to price the actual implementation without first performing a Discovery phase and analysing the existing reports. May suppliers submit estimated costings, based upon information within this pack, with this cost being validated via a Discovery phase? no Last Updated : <strong>15/03/2023</strong>