Awarded to Aleph Insights Limited

Start date: Thursday 6 September 2018
Value: £19,620
Company size: SME
Civil Contingencies Secretariat, Cabinet Office

Capability data visualisation

3 Incomplete applications

2 SME, 1 large

10 Completed applications

8 SME, 2 large

Important dates

Published
Friday 20 July 2018
Deadline for asking questions
Friday 27 July 2018 at 11:59pm GMT
Closing date for applications
Friday 3 August 2018 at 11:59pm GMT

Overview

Summary of the work
Developing a digital platform to provide a database and data visualisation for a national security capability mapping programme.
Latest start date
Monday 3 September 2018
Expected contract length
12 months
Location
London
Organisation the work is for
Civil Contingencies Secretariat, Cabinet Office
Budget range
Maximum £20,000.

About the work

Why the work is being done
The Resilience Capabilities Programme (RCP) oversees the readiness of the crisis capabilities needed to respond to the common consequences of nationally identified risks and attacks. Any civil emergency calls upon a raft of different response capabilities, and requires them to work together. We provide models for these complex inter-capability relationships. Our purpose is to inform cross-government discussions about capabilities’ strengths or where capabilities could be improved to ensure a successful response to a wide range of risks. It provides an evidence base for strategic decision-making about the use of resources to achieve the best possible impact through targeted capability building.
Problem to be solved
The current process is done manually by filling in interactive PDFs and data visualisation. It is time consuming and often subject to human error. We are looking for a supplier who specialises in data analytical software (for example, Tableau or Microsoft Power BI) to automate the capability mapping process and generate data visualisations which are interactive. The solution must have the ability for the user to easily input data (low/no code), store it locally (or within Cabinet Office hosted environment), automatically generate data visualisations and model the data. This would ideally be accessible across government IT platforms by cross-government stakeholders.
Who the users are and what they need to do
The users are an internal Cabinet Office team, with the potential for cross Whitehall stakeholders to be included.

The solution must be able to:
1) automatically generate data visualisations
2) enable automated data modelling, including route for improvement and cross-capability comparison
3) store data securely
4) have the ability to input and access data and visualisations remotely
5) incorporate qualitative descriptions into visualisations to support interpretation
6) enter mock data to generate scenarios illustrating a 'what if' situation which mustn't affect any live data.
Early market engagement
None
Any work that’s already been done
We have undertaken an initial ‘Discovery’ and have a general idea of software requirements, mock visualisations and technical options. However we require a supplier to show us the ‘art of the possible’.
Existing team
The supplier will be working with the Strategy and Performance Team in CCS to deliver a platform that meets user needs and supports our business objectives, as well as the Cabinet Office Digital and Technology Team.
Current phase
Alpha

Work setup

Address where the work will take place
Split between 35 Great Smith Street and Windsor House, Victoria Street, London. Remote working accepted.
Working arrangements
Although we are happy for the supplier to complete most of the work remotely, we would like them to collaborate with the team in CCS throughout.
Security clearance
SC minimum is essential.

Additional information

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.

Essential skills and experience
  • Strong working knowledge of data analytical tools
  • Experience of working with and automating complex data visualisation
  • Demonstrate a creative and innovative approach to designing solutions that meet user/business needs
  • Take an agile approach to design, with a commitment to ongoing iteration and improvement
  • Experience of working with Official Sensitive data
  • Demonstrable experience in using user research and testing to define and validate user needs
Nice-to-have skills and experience
  • Experience of working with multiple government departments
  • Experience of working with secure government IT platforms

How suppliers will be evaluated

How many suppliers to evaluate
3
Proposal criteria
  • Approach and methodology used
  • How does this approach meet user needs?
  • How does this approach meet our business goals?
  • Estimated time frames for the work
  • Have you identified risks and dependencies and offered approaches to manage them?
  • What is the team structure?
  • Illustrate value for money
Cultural fit criteria
  • Work as a team with our organisation
  • Be transparent and collaborative when making decisions
  • Have a no blame culture and encourage people to learn from their mistakes
  • Take responsibility for their work
  • Share knowledge and experience with other team members
  • Challenge the status quo
  • Be comfortable representing the importance of used centred design in front of key stakeholders, who may be more concerned about commercial priorities
  • Able to explain technical complexities to stakeholders in non-technical language
Payment approach
Capped time and materials
Assessment methods
  • Written proposal
  • Case study
  • Work history
  • Presentation
Evaluation weighting

Technical competence

60%

Cultural fit

10%

Price

30%

Questions asked by suppliers

1. Could you please confirm the budget is £20K for 12 months work.
The maximum budget for the project is £20,000. The contract term of 12 months is the length time we would expect support to be offered post-development (should it be required), and does not reflect development time – which is expected to be considerably shorter.
2. The stated budget of £20,000 appears low for the development of a platform over 12 months. Can you confirm whether the budget is correct please?
The maximum budget for the project is £20,000. The contract term of 12 months is the length time we would expect support to be offered post-development (should it be required), and does not reflect development time – which is expected to be considerably shorter.
3. Can you pls confirm the budget is max £20,000 (i.e. this is not a typo)
The maximum budget for the project is £20,000. The contract term of 12 months is the length time we would expect support to be offered post-development (should it be required), and does not reflect development time – which is expected to be considerably shorter.
4. Can you please confirm the total budget for this opportunity - £20,000 seems incredibly low.
The maximum budget for the project is £20,000. The contract term of 12 months is the length time we would expect support to be offered post-development (should it be required), and does not reflect development time – which is expected to be considerably shorter.
5. Upon reading the opportunity details, there seems to be a misalignment between the ‘Budget Range’ (Maximum £20k) and ‘Expected Contract Length’ (12 months). Please can you confirm these are the correct values.
The maximum budget for the project is £20,000. The contract term of 12 months is the length time we would expect support to be offered post-development (should it be required), and does not reflect development time – which is expected to be considerably shorter.
6. Hi, our questions: 1. Do you have a preference for BI tool out of those mentioned? 2. Would it be possible to see the output of the discovery phase? 3. Where does the data currently reside?
1. We don’t have a preference. We’re very open to suppliers showing us the art of the possible with the tools mentioned, or with others that we may not yet be aware of.

2. Unfortunately this can’t be published publicly. The general gist is a digital database that aggregates the data using a pre-defined methodology and automatically produces sunburst visualisations that show the layers of the data as it is aggregated to a final output.

3. The data is currently collected and stored in individual interactive PDFs and the sunburst charts are generated manually on Adobe Illustrator.
7. We would be interested in responding to the opportunity and have extensive relevant experience in the public sector. However previous projects have not required any Security Clearance. Is it feasible to obtain such clearance for relevant staff in a timeline that would allow you to consider us for the opportunity and are you able to act as our sponsor in that process
Due to the nature of the programme, SC is essential for this job. The estimated time for SC clearance at present is 3 months, although it is possible that it will take longer, which would fail to meet our project timelines. Unfortunately we are not able to act as sponsors.