Awarded to Acuma Solutions Limited

Start date: Friday 1 June 2018
Value: £740,000
Company size: SME
Nottinghamshire County Council

Business Reporting & Management Information (BRMI) Phase 4

2 Incomplete applications

1 SME, 1 large

2 Completed applications

2 SME, 0 large

Important dates

Published
Wednesday 2 May 2018
Deadline for asking questions
Wednesday 9 May 2018 at 11:59pm GMT
Closing date for applications
Wednesday 16 May 2018 at 11:59pm GMT

Overview

Summary of the work
Project co-management, BI design and architecture
Training and knowledge transfer
Delivery of cubes and dashboards
Expanding Unit Cost and Service User Journey analysis functionality to cover Childrens services
Delivery of Homecare project functionality, including reports and dashboards
Delivery of pilot contract management functionality
Integrating additional system data into the warehouse
Latest start date
Monday 25 June 2018
Expected contract length
Initial period will not exceed 10mths. If subsequent work is approved, max period of 2yrs will apply
Location
East Midlands
Organisation the work is for
Nottinghamshire County Council
Budget range
The indicative overall budget is £1.8m. Within that the budget approved for the defined work outlined in section 19 is £740K. £100K of the £740K is ring-fenced for the provision of the Homecare functionality. Any other work and budget beyond £740K would have to be approved by the relevant Council committee. No bid will be considered that exceeds the currently approved budget of £740k.

About the work

Why the work is being done
Provision of a bespoke data warehouse containing key Council data, together with associated reporting, visualisation and analytical capability, is a critical part of the Council’s approach to business intelligence. The warehouse went live in 2017 with social care data, reporting and analysis and has since been enhanced and expanded with additional data and capabilities, including reports, ad-hoc queries and dashboards. Further enhancements and expansions will be delivered during the next phase of the project.
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 the users are and what they need to do
"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
Any work that’s already been 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. Phases Two and Three of the project provided 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 the first three phases of the project. 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 initial work in late 2015 and the subsequent phases in 2017. The successful bidder will form a joint team with Council staff to deliver Phase Four.
Current phase
Live

Work setup

Address where the work will take place
Nottinghamshire County Council, County Hall, West Bridgford Nottingham NG2 7QP
Working arrangements
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.
Security clearance
Not required

Additional information

Additional terms and conditions
Suppliers shall provide transparency to the Council on the rates paid to resources.

Skills and experience

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

Essential skills and experience
  • Have demonstrable experience of Agile
  • 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
  • Have demonstrable experience of dashboard development using Power BI (10-20 likely to be required)
  • Have demonstrable experience of cube development (coverage of 90% of the warehouse likely to be required)
  • Have demonstrable experience of developing and delivering unit cost analytical functionality for social care data
  • Have demonstrable experience of developing and delivering service user journey analytical functionality for social care data
  • Have demonstrable experience of developing and delivering contract data management functionality for social care data
  • Have demonstrable experience of developing and delivering functionality to support Homecare provision
  • Have demonstrable experience of developing organisational structure models based on a data warehouse
  • Have demonstrable experience of developing complex contract data management functionality, ideally for social care data
  • Have demonstrable experience of report development
  • Have demonstrable experience of working collaboratively
  • Have demonstrable experience delivering training and knowledge transfer to customer staff
  • Be a minimum of a Microsoft Silver Partner
  • Demonstrable experience of SQL Server 2014 Enterprise, SSIS, SQL Server Data tools, SSAS - Tabular, SQL Server MDS, SSRS, Report Builder, SQL Server Data Tools, Power BI, CDC by Attunity
  • Capable of deploying a minimum of ten resources with the above skills and experience.
Nice-to-have skills and experience
Have previous experience in local government

How suppliers will be evaluated

How many suppliers to evaluate
6
Proposal criteria
  • - Approach and methodology
  • - Evidence of relevant past work as detailed 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 including those from the Council and the BAU team
  • Agile and flexible in order to manage changing and uncertain requirements
  • Transparent and collaborative when making decisions
  • Challenge the status quo
  • Innovative and promote ideas and new approaches as appropriate
  • Achieve value for money in all activities
  • Excellent communication skills at all levels
Payment approach
Fixed price
Assessment methods
  • Written proposal
  • Reference
  • Presentation
Evaluation weighting

Technical competence

70%

Cultural fit

10%

Price

20%

Questions asked by suppliers

1. We are currently a Microsoft Partner and are working towards Silver Partner status in 2018. We have all of the other essential and nice-to-have experience, plus we have previously worked with your organisation. Would you accept a bid from our organisation?
As per the criteria we will not accept a bid from any organisation that is not currently a Microsoft Silver Partner. Those who do not meet the essential skills and experience will not be eligible
2. We notice that there are two questions that are very similar - one relating to "contract data management" and one relating to "complex contract data management". Please could you elaborate on what you see as the key differences between these two?
Unfortunately this is an error. Please respond to 'Have demonstrable experience of developing complex contract data management functionality, ideally for social care data'
We do not require any response to 'Have demonstrable experience of developing and delivering contract data management functionality for social care data'
3. We note that the Proposal Criteria asks for “Evidence of relevant past work as detailed in references and proposal” and, separately, “Evidence of successful delivery of similar work in similar environments as detailed in case study, references and proposal.” Please can you clarify the difference between these two criteria in terms of what our responses should include?
Our apologies, we recognise the similar nature of these criteria. Please respond to the latter ‘Evidence of successful delivery of similar work in similar environments as detailed in case study, references and proposal’. We do not require a separate response to ‘Evidence of relevant past work as detailed in references and proposal’