Business Reporting & Management Information (BRMI) Phase 3

Tender description

Why the Work is Being Done Provision of a bespoke data warehouse containing key Council data, together with associated reporting and analysis capability, is a critical part of the Council’s approach to business intelligence. The warehouse has gone live with social care data, reporting and analysis and will now be enhanced and expanded with additional data and capabilities, including reports, ad-hoc queries and dashboards. Problem to Be Solved Council staff at all levels require effective data analysis and reporting capabilities to inform and improve decision making and day-to-day management. This work will develop the existing data warehouse capabilities and also identify and agree the priorities for other data and capability to be included in it. Who Are the Users "The primary users (c.3000) are members of the Childrens, Families & Cultural Services (CFCS) and Adults, Social Care & Health (ASCH) departments. User levels range from department heads down to team member. These users run pre-defined but parameterised reports against the data warehouse on a regular basis. Other users include the Council’s Corporate Leadership team, certain areas of Finance (similar usage to above) and the Performance, Intelligence & Policy team (in addition to usage above ad-hoc queries, data manipulation and analysis)." Early Market Engagement No early market engagement Work Already Done Phase One of the project went live in May 2017, delivering the data warehouse populated with the Council’s social care data and some 220 reports. Phase Two of the project is in progress (completion October 2017) and is providing additional capability, including adding data to the warehouse, development of further reports and dashboards, technical enhancements and knowledge transfer. This work is being carried out by the same project team. Existing Team A project team exists that has successfully delivered Phase One of the project and is currently working on Phase Two. This is a joint team consisting of Council staff and staff from the Council's technical partner/solution provider. The technical partner successfully bid for the work in late 2015. The successful bidder from this Procurement will form a joint team with Council staff to deliver Phase Three. Current Phase Live Work Location Nottinghamshire County Council, County Hall, West Bridgford NG2 7QP Working Arrangments "Supplier staff will work on-site five days per week as part of a joint team with Council staff. The team will be managed jointly by a Council project manager and a supplier project manager and report to a project board. Supplier staff will be expected to engage with council staff beyond the immediate project team (e.g. users, IT department) as required. Supplier staff will be responsible for travel and expenses to County Hall. Agreed reasonable expenses will be reimbursed for any work on Council sites other than County Hall." Security Clearance Not required Additional T&Cs Suppliers shall provide transparency to the Council on the rates paid to resources. Skills & Experience Have demonstrable experience of Agile development Have demonstrable experience of data warehouse design, development, implementation enhancement and maintenance Have demonstrable experience of successful delivery working in complex and regulatory environments Have demonstrable experience of unit, system and integration testing Have demonstrable experience of the Microsoft stack, including Power BI Have demonstrable experience of report development Be Capable of deploying upwards of 10 resources with the above skills and experience Have demonstrable experience of working collaboratively, including training and knowledge transfer Be a minimum of a Microsoft Silver Partner demonstrable experience ofusing MSSQL Server2014 Enterprise Edition, SSIS,SQL Server Datatools, SSAS - Tabular, SQL ServerMDS, SSRS, ReportBuilder3.0, SQL Server DataTools 2013&2015, Power BI Enterprise Gateway, CDC by Attunity for Oracle Nice to Haves Have previous experience in local government No. of Suppliers to Evaluate 6 Proposal Criteria Approach and methodology Evidence of relevant past work as detailed in case study, references and proposal Evidence of successful delivery of similar work in similar environments as detailed in case study, references and proposal Demonstration of in-depth understanding of requirement as reflected in proposal Identification of potential risks and issues and approach to managing them Team structure and proposed resources, including approach to adding, replacing or rotating team members How the proposed approach meets the Council’s requirements and goal Cultural Fit Criteria Work as one team with the Council and Council staff Share knowledge and experience with other team members Be Agile and flexible in order to manage changing and uncertain requirements Be Transparent and collaborative when making decisions Challenge the status quo Be Innovative and promote ideas and new approaches as appropriate Achieve value for money in all activities Have Excellent communication skills at all levels Payment Approach Fixed price Assessment Method Written proposal Case study Reference Presentation Evaluation Weighting Technical competence 60% Cultural fit 20% Price 20% Questions from Suppliers Budget range max £500k. no bids will be considered that exceed this amount.