Robinson Club GmbH - time-saving analyses

Together with Qurius Advanced Solutions AG, Robinson Club GmbH has built a new reporting and analysis system. Inflexible reports and time-consuming data collection and editing are now a thing of the past.

Company
Robinson Club GmbH, a subsidiary of World of TUI with its head office in Hanover, is the German quality and market leader in the premium segment for club holidays. Its portfolio currently includes 23 Club centres and a town hall in eleven countries with a capacity of 12,600 beds. A little less than 40 years ago, Robinson laid the foundation for a new type of holiday: in addition to the quality of the holidays offered, the focus was shifted to the individual guests. Thanks to a consistent brand strategy and continuous quality improvement, Robinson has had a decisive influence on the club holiday concept from its conception and to date has ensured its clear lead ahead of the competition.

Scope
In the course of the introduction of new hotel software and the successive innovations in the total IT landscape, the need arose to optimise all the scheduling and reporting processes. The key elements of the optimisation were the clear definition of the required information and the creation of a technical platform that allows a flexible, multi-dimensional OLAP analysis and at the same time ensures standard reporting. In addition to pure analysis, there was a need to set up this platform to support the optimised scheduling processes and functions effectively. The previous scheduling and reporting system was characterised by a high degree of manual data consolidation and editing.

Solution
As the first step towards optimisation, an analysis was held. After all the relevant reports from the departments as well as other information such as report recipients and creation cycles had been compiled, the next step for the project team was to identify and classify the reports. This systematically edited information could then be used at workshops with the departments, where the indexes and parameters and the corresponding dimensions could be deduced. In this way, the multidimensional data model was conceived and the relevant data determined. It soon became obvious that the information required from various source systems had to be consolidated and edited in a central data warehouse (DWH). The structure of this DWH was implemented on the basis of an MS SQL server.

Important indexes can be analysed quickly and flexibly
The data from the various source systems were then transferred at night using SSIS packages (SQL Server Integration Services). Next, they were consolidated and reviewed according to certain routines. The result of the nightly updates is a consistent database for relational standard reporting using Microsoft Reporting Services as well as the data foundation for the multidimensional analysis and planning tool BOARD. Using the solution created, the various departments can quickly and flexibly analyse their most important indexes using a range of dimensions. These include the number of overnight stays and the corresponding room occupation (including single occupancy of double rooms) for each Club, room categories and the current booking status.

In a few mouse clicks, all this information can be organised in a drill-down to show other dimensions, such as booking channel or age structure of the guests. The manual process of editing the data has been omitted entirely and standard reports are distributed automatically using a report subscription system. This means that all users receive the information they need for their daily work faster and more reliably.

Customer benefits
Simplifying the reporting created increased transparency in the occupancy analysis. As a result, the data editing costs were clearly reduced and multi-dimensional analyses from all defined levels are now easily covered and very feasible. The realisation of the reporting system already took into consideration that scheduling data will be analysed using BOARD in the future. This scheduling project will also be carried out by Qurius Advanced Solutions AG.