Insight Team SQL Data Warehouse
Staffordshire County Council · West Midlands
Key facts
- Contract value
- £66,949
- Awarded
- 16 Aug 2015
- Contract starts
- 13 Sep 2015
- Contract ends
- 14 Sep 2016
- Procedure
- Other -
- Buyer type
- Local government
Awarded to
| Supplier | Value |
|---|---|
| Risual Ltd | £66,949 |
Description
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.
Categories (CPV)
- 48800000 Information systems and servers
Similar open tenders
System Adnoddau Dynol Chwaraeon Cymru / Sport Wales Human Resources System
Location: WalesBuyer: Sport Wales
Open tenderCloses 4 Dec, 202630 daysValue £225.00kSource Find a TenderMae Chwaraeon Cymru yn chwilio am blatfform Adnoddau Dynol modern, sy'n canolbwyntio ar y defnyddiwr, i gefnogi cylch bywyd llawn cyflogeion, o recriwtio hyd at gyflogaeth, datblygu a rheoli'r gweithlu. Mae Chwaraeon Cymru yn dymuno caffael datrysiadau sy'n cyflawni’r canlynol: • Darparu profiad defnyddiwr modern a gre
The Spencer Academy Trusts Microsoft Licensing & Support Services
Location: East MidlandsBuyer: THE SPENCER ACADEMIES TRUST
Open tenderCloses 23 Nov, 202619 daysValue £525.00kSource Find a TenderSpencer Academies Trust is seeking a suitably qualified supplier to provide Microsoft Licensing and Support Services. The contract will include the provision, management and support of the Trust's Microsoft licensing estate, including Microsoft 365 A3 and Microsoft 365 A5 licensing, licence administration, subscription
Global Travel, Accommodation and Venue Management Services
Location: North WestBuyer: Government Commercial Agency
Open tenderCloses 8 Dec, 202634 daysValue £36.25bnSource Find a TenderA framework providing comprehensive booking solutions for all UK Public Sector Travel needs, including air, rail, taxis, coaches, car hire, accommodation and venues for meetings, conferences and events, as well as emergency travel and accommodation solutions, including for civilian cohorts under the care of a UK Public
The Provision of Work Planning Software Application [642]
Location: IrelandBuyer: Commission for Regulation of Utilities
Open tenderCloses 30 Nov, 202626 daysValue €210.00KSource TEDThe CRU prepares a Strategic Plan on a three-year cycle and develops annual Work Plans to support delivery of its priorities, objectives and outcomes. Progress is monitored quarterly through Work Plan review reports and monthly through Focus Area Reports for selected highpriority programmes, projects and organisational
LEGO299 End-to-End Reporting, Budgeting, Forecasting and Financial Reporting Solution
Location: West MidlandsBuyer: The Office for Legal Complaints
Open tenderCloses 30 Nov, 202626 daysValue £100.00kSource Find a TenderA fit-for-purpose budgeting, forecasting and financial reporting solution that automates LeO's existing Finance processes, integrates with relevant source systems and can be operated by Finance following implementation.
Performance Development Software
Location: IrelandBuyer: Irish Blood Transfusion Service
Open tenderCloses 9 Dec, 202635 daysSource TEDThe IBTS is seeking the provision of a configurable software solution that can facilitate our Performance Development (PD) process. The IBTS Performance Development (PD) process is a broad term that includes ongoing performance management and employee development. It involves both assessing and managing the work that n