Villages Clubs du Soleil

Optimization of Strategic Decisions with Data Integration Hub (DiH)

Implementation of a Centralized Data Warehouse and Dedicated Datamarts for Advanced BI

Villages Clubs du Soleil is a French company specializing in the management and ownership of holiday villages.

Faced with heterogeneous data sources and the need for consolidated key indicators to optimize the management of its activities, VCS needed an effective solution to centralize its data and improve its analytical capabilities.

Coexya, an expert in data integration and business intelligence, was chosen for its ability to provide tailored solutions adapted to the complex needs of companies, as well as its proven expertise in setting up Data warehouses and Datamarts.

Solution provided by Coexya

The Coexya teams deployed a Data warehouse in which VCS’s various heterogeneous data sources are centralized.

This solution allows for the calculation and storage of key indicators in several Datamarts dedicated to different business areas (Finance, Marketing, Sales).

These Datamarts are then used to generate reports via Power BI, thus facilitating analysis and decision-making.

Specifically, here are Coexya’s achievements as part of this project:

  • Needs analysis and design of the architecture of the Data warehouse and Datamarts
  • Ingestion of data sources: centralization of heterogeneous data from different source systems into a unified Data warehouse
  • Development of Datamarts: defining data models and creating specialized Datamarts for different business domains
  • Support in creating Power BI reports
  • Training and support: training and post-deployment support

Technical Environment

  • Azure Synapse
  • Fabric / Power BI
  • DevOps