Insight Team SQL Data Warehouse
This is a contract result notice, not an open opportunity. Details from the official award data.
This sits in the lower-middle of the Software & IT Systems band — a mid-scale opportunity. Based on 30,286 valued Software & IT Systems tenders in our corpus.
This procurement was run via the Digital Market Place / G-Cloud Staffordshire’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 & 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:- • Researchers can easily access data that has originated from multiple data sources, with the aspiration to link them together with historical reference. • The Customer Insight data management team can create a single point of access to data. • 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. • Data requests could be automated to support the organisational needs for data reports and standard outputs. • Data maintenance can be done in a more systematic and efficient manner. • 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. • There is a flexible solution that allows for ‘staging data’ whereby data is required but has not yet been formally introduced into the data warehouse / domain structure. • Quickly and efficiently share data between departments and partner organisations.
What the supplier must deliver
To operate efficiently the Customer Insight team
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:-.
Geographical data should be included with all
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.
Data requests could be automated to support
Data requests could be automated to support the organisational needs for data reports and standard outputs.
Fast and efficient modifications can be made
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.
Derived from the notice text — always confirm against the original documents.
Skills, tools & certifications
Detected from the notice — the capabilities and credentials this bid calls for. Click one to see who wins that work.
Make the case to bid
Reveal who to approach at STAFFORDSHIRE COUNTY COUNCIL, and generate a go-to-market strategy from their news, accounts and people.
Ask me about this tender, the buyer, who wins their work, or whether you should bid.
- OCID
- b14b1783-9377-4a6a-95ba-88f18d32d2fa
- Stage
- contract · Contract
- Source
- Contracts Finder
- Buyer ref
- DM0001
Contains public sector information licensed under the Open Government Licence v3.0. Source data © Crown copyright.
Who wins this kind of work
The suppliers and buyers around this opportunity — drawn from official award data. Drag to orbit; click a node to explore.
Top suppliers & buyers in Software & IT Systems
STAFFORDSHIRE COUNTY COUNCIL’s tender network
Assembling the network…