Insight Team SQL Data Warehouse

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.