Insight Team SQL Data Warehouse

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.