Awarded to Actica Consulting

Start date: Monday 13 July 2020
Value: £30,000
Company size: SME
Hackney Council

Assessment of business intelligence software options

13 Incomplete applications

11 SME, 2 large

30 Completed applications

28 SME, 2 large

Important dates

Saturday 9 November 2019
Deadline for asking questions
Friday 15 November 2019 at 11:59pm GMT
Closing date for applications
Saturday 23 November 2019 at 11:59pm GMT


Summary of the work
A review of the effectiveness of our current business intelligence infrastructure and governance to help us understand whether our current software, its implementation and the supporting processes are future proofed and flexible, and what investment is required if not.
Latest start date
Monday 6 January 2020
Expected contract length
3 months
Organisation the work is for
Hackney Council
Budget range
We expect this consultancy to cost c. £30,000 but are procuring to a value of £40,000 to allow contingency and suppliers to suggest value-add activities.

About the work

Why the work is being done
In 2015, Hackney invested in QlikView and QlikSense as our business intelligence tools. The data we hold is fragmented across multiple systems and the Qlik products have enabled us to join large, complex datasets in single views to carry out advanced analysis. This contract is due to expire in July 2021 and we want to ensure that we understand what business intelligence tools the organisation needs and how we best organise our data layer to give us maximum flexibility to meet them in line with our emerging cloud first strategy.
Problem to be solved
We are looking to work with an external specialist who can embed with the team for a short, focussed review to understand the following:
The strengths and weaknesses of our existing set up (infrastructure/data management/skills spread and resilience
Validate our assumed user needs
How easy it would be to decouple from our existing provider / how they could integrate with GSuite and our increased desire for advanced analytics include machine learning
Future options, either within the Qlik offer or amongst other BI providers, and their suitability to Hackney
The optimum support arrangements for any BI solutions that follow
Who the users are and what they need to do
As a Data & Insight Analyst, I need to spend less time on managing our BI infrastructure and more on interpretation/analysis so that I can support evidence-led decision making

As a data analyst in the Council, I need access to intuitive tools that help me maximise the benefit of my data so that I can deliver informed analysis

As a contract manager, I need to ensure we’re investing taxpayers’ money effectively so that we’re getting best value for money

As a senior manager at Hackney Council, I need access to current data so that I can plan effective services
Early market engagement
Any work that’s already been done
The team have developed circa 100 dashboards within QlikSense and QlikView and as well as 3 expert BI developers based in ICT, there are around 10-12 analysts across the organisation who are developing Qlik Sense dashboards with intermediate functionality. Support from Qlik software is available via a third party reseller but much of the day to day support and maintenance is being managed by the Data & Insight team itself. The team is experimenting with other tools for advanced analytics / data presentation including GCP, BigQuery (in line with our business GSuite deployment), Dash, Datasette and Python.
Existing team
The existing core team is entirely in-house and consists of a Data Analytics Lead, Business Intelligence Developer and a Data Engineer.

Key stakeholders include:
- 10-12 data analysts across different services in the organisation who develop Qlik Sense dashboards with intermediate functionality
- Data & Insight team members
- ICT technical architecture and infrastructure teams

We want to be confident that we can run an efficient BI offer that complements the other functions of the team, requires minimum upkeep and allows us to focus our efforts on supporting the organisation to make the most of our information as an asset.
Current phase

Work setup

Address where the work will take place
Hackney Council offices in Mare Street, E8
Working arrangements
Some onsite required for shadowing, face to face meetings and workshops with key teams and stakeholders. Some remote working for planning. preparation and/or telephone meetings. Exact arrangements to be agreed with supplier.
Security clearance

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
  • Knowledge of leading business intelligence tools and cloud hosted analytical platforms
  • Knowledge of options around different data repositories e.g. data marts, data lakes
  • Knowledge of modern analytical and data science approaches using open source tools and languages including Python
  • Commercial independence from any single vendor (relationships or accreditations with multiple vendors is acceptable)
  • Experience of taking a user-centred approach to informing requirements for software use
  • Have experience designing services for a wide range of digital skills and confidence
Nice-to-have skills and experience
  • Be prepared to share risk and/or reward with the council if the service is attractive to other authorities
  • Provide opportunities for people seeking ways into work in Hackney (e.g. through an apprentice working on the project)

How suppliers will be evaluated

All suppliers will be asked to provide a written proposal.

How many suppliers to evaluate
Proposal criteria
  • Clarity of the approach and methodology
  • Experience from a similar project
  • Team structure, including skills, experiences and relevance of individuals
  • Identification of risks and plan to mitigate them
  • Technical understanding
Cultural fit criteria
  • Work as a team with our organisation and other suppliers
  • Be transparent and collaborative when making decisions
  • Share knowledge and experience with team members and the wider service
  • Hackney Council is a diverse organisation, reflecting the diversity of our borough. Describe how you would successfully work as a team with Hackney and other suppliers in a diverse environment.
Payment approach
Time and materials
Additional assessment methods
  • Case study
  • Presentation
Evaluation weighting

Technical competence


Cultural fit




Questions asked by suppliers

1. Does the budget include VAT?
2. Is it possible to clarify what is meant by the risks and rewards in the "nice-to-have" requirement of sharing the risk and/or reward with the council if the service is attractive to other authorities?
We would like to publish the findings in the open, if possible. If other local authorities benefit from the recommendations (for example, through seeking a joint procurement) then we would be willing to consider different commercial models for promoting collaboration.
3. Can you define what you mean by "Commercial independence from any single vendor". IE single vendor of what technologies?
Vendors of business intelligence software - eg Qlik, PowerBI, Tableau. We would be content with working with a partner that has relationships with all of the major vendors but would prefer not to work with a partner that has a single affiliate or re-seller arrangement.
4. Could you please clarify the example following "nice to have" requirement: 'Provide opportunities for people seeking ways into work in Hackney (e.g. through an apprentice working on the project)'.
Would the supplier be invited to onboard apprentices currently employed by Hackney Council to work the project?
Or is the question asking whether the supplier already employs apprentices who may work on the project?
The latter - we're looking to work with suppliers who already employ apprentices and to stimulate the hiring of Hackney-based apprentices amongst our supplier base. We also encourage employers to sign-up to the Hackney 100 programme