Source: https://tendernation.io/opportunities/01a13c01-f7a6-70a5-8459-4f2e9bd0b66d/insight-team-sql-data-warehouse

[Skip to main content](#main-content)

awardedGBopen procedureSuitable for SMEs

# Insight Team SQL Data Warehouse

[Staffordshire County Council](https://tendernation.io/buyers/staffordshire-county-council)

Estimated value

£66,949

Published

18 Nov 2016

Deadline

Closed

10 Jul 2015

## Who can bid

- Buyer says suitable for SMEs

    The buyer ticked “suitable for SMEs” on the notice. Anyone can still bid.
- Small contract value

    Valued under £135,018 including VAT, the lowest Procurement Act threshold for goods and services.
- Open procedure

    Anyone can submit a full tender; there is no shortlisting stage.

[More contracts for small businesses and VCSEs](/opportunities/for-small-businesses)## About this tender

This procurement was run via the Digital Market Place / G-Cloud

Staffordshireâ&#128;&#153;s Customer Insight team conducted a review of their function with a view to understanding how the function is operating and where / how efficiencies could be derived.

They identified that a significant amount of effort within the Customer Insight Team is associated with gathering, cleansing and producing datasets for research work and report production. In addition a disproportionate amount of time is spent searching for data. Data is requested from business units, systems, and both licenced &amp; open data sources. Data is either duplicated numerous times or awaiting responses from already busy colleagues across the organisation.

To operate efficiently the Customer Insight team has identified a need to develop a centralised data store on which they can overlay their existing BI tools e.g. a data warehouse, or data mart which provides:-

â&#128;¢ Researchers can easily access data that has originated from multiple data sources, with the aspiration to link them together with historical reference.

â&#128;¢ The Customer Insight data management team can create a single point of access to data.

â&#128;¢ Geographical data should be included with all data domains (or other appropriate geo-coding methodologies) to enable the ease in which software can be used to generate outputs.

â&#128;¢ Data requests could be automated to support the organisational needs for data reports and standard outputs.

â&#128;¢ Data maintenance can be done in a more systematic and efficient manner.

â&#128;¢ Fast and efficient modifications can be made to extracted data and the structure of attributes (either columns or lookup tables) in support of customer requests.

â&#128;¢ There is a flexible solution that allows for â&#128;&#152;staging dataâ&#128;&#153; whereby data is required but has not yet been formally introduced into the data warehouse / domain structure.

â&#128;¢ Quickly and efficiently share data between departments and partner organisations.

Read full description

## CPV classification

Information systems and servers

Source

Contracts Finder (UK)

[View official notice ](https://www.contractsfinder.service.gov.uk/notice/c2298725-adc8-11e6-9901-0019b9f3037b)

 Never miss a tender like this again

Get AI summaries, deadline alerts and a bid pipeline for tenders matched to your business. Free to start.

[Track tenders free ](/register)

[Buyer profileStaffordshire County Council: past awards and live tenders](https://tendernation.io/buyers/staffordshire-county-council)[SectorMore Software packages &amp; information systems tenders](https://tendernation.io/sectors/software-information-systems)

## More tenders like this

[Registration Services Booking and Management System

Herefordshire Council

27 days left

13 Nov 2026](https://tendernation.io/opportunities/01a14571-36b1-7388-87a9-27c78a201aee/registration-services-booking-and-management-system)[Fleet Management System

North East Derbyshire District Council

27 days left

13 Nov 2026](https://tendernation.io/opportunities/01a14495-83e7-7347-bd5f-302d644ecdf8/fleet-management-system)[The People's Network E-bikes - Customer Subscription, Service, Technology and Fleet Management Platform Provider

South Yorkshire Mayoral Combined Authority

30 days left

16 Nov 2026](https://tendernation.io/opportunities/01a14427-96da-72c9-813b-873ea7454e67/the-peoples-network-e-bikes-customer-subscription-service-technology-and-fl)[Software package and information systems – mixto de suministro suscripción Plataforma tecnológica de gestión de contenidos para gestión centralizada portales y páginas web para la Red Provincial de Comunicaciones de la Diputación de Almería, en modalidad de SAAS, con hosting y mantenimiento

Junta de Gobierno de la Diputación Provincial de Almería

27 days left

13 Nov 2026](https://tendernation.io/opportunities/01a1420f-fe17-71a2-baf7-3a729fddc417/spain-software-package-and-information-systems-mixto-de-suministro-suscripci)[Medical software package – Zakup oprogramowania do zarządzania Zakładem Patomorfologii Katowickiego Centrum Onkologii

Katowickie Centrum Onkologii

6 days left

23 Oct 2026](https://tendernation.io/opportunities/01a1420f-ff10-711e-b196-4735827541f2/poland-medical-software-package-zakup-oprogramowania-do-zarzadzania-zakladem)[Software package and information systems – UEM OSS/MPC

Dataport AöR

9 days left

26 Oct 2026](https://tendernation.io/opportunities/01a1420f-ff26-70c5-b28c-5fc6d67ab499/germany-software-package-and-information-systems-uem-ossmpc)
