Data warehouse

Supporting CSSC to develop their data management

"I have been truly impressed with the level of professionalism and expertise that Entec Si have shown during the development of this project. From the very early days of engagement through to the current position they have shown a level of understanding and range of skills that have contributed to the undoubted success of this project. "

Andy Shaw, Director of Volunteering and Business Delivery.

Objective

CSSC Sports & Leisure is an organisation that promotes healthy living by providing sport and leisure opportunities to its members. Historically they held a great deal of complex information across a range of disparate sources within the business. To address this we were engaged by CSSC to build a Data Warehouse (DW).

Approach

A DW has been built using the latest SQL Server (2016) functionality. This manages the end-to-end journey, taking data from sources, importing it into the DW and providing managed outputs to various recipients.

Development is being undertaken in several stages, using agile methodology and sprints. Stages 1 and 2 dealt with data sources in many formats. These were cleansed where required, prior to being imported, and regular imports were setup to ensure that quality data is available in a timely and consistent manner.

Stage 1
Involved analysis and a full understanding of the information available in the main members’ database.

Stage 2
Involved analysis of other sources across the business that hold data on the various products and services that members use.

Stage 3 (in 2018)
This will involve joining up all the data sources to build a rounded member view, including all the products and services used (or not used).

Outcomes

This solution has fundamentally changed the depth and breadth of data and analytics available to CSSC. From a single source they can now obtain a picture of each member’s engagement with the organisation.

The interrogation of the data in the DW is also providing a better understanding of CSSC members at levels not previously achieved.

This allows products and services to be better targeted to what members use or demand. It has also meant that senior leaders and managers are able to make decisions based on the actual information that is available to them.

In addition, the project has provided fundamental business improvements for the organisation. These include the ability to define the basic concepts of active or inactive members, improve the data capture process and help to clean the data stored across the business.

Related

Let's start a conversation!

Contact us at info@entecsi.com