The company
Robinson Club GmbH, a group company in the World of TUI based in Hanover, is Germany's quality and market leader in the premium segment for club-based vacations. At the present time, its portfolio includes 23 Club facilities and one townhouse, spread across eleven countries with a total bednight capacity of 12,600.

About 40 years ago, ROBINSON laid the foundation for an entirely new kind of vacation: a quality offering that placed much greater emphasis on the individuality of its guests. By pursuing a consistent brand strategy and through continuous quality improvement, ROBINSON has exerted a decisive influence on the concept of club-based holidays and has secured itself a substantial competitive edge over all the other providers in this field.


Task profile
In the context of introducing new hotel software and through a rolling programme of upgrades to the full extent of IT systems, a need arose to optimise the entire range of planning and reporting processes. Core elements in this optimisation process included a clear definition of the information required, and the procurement of a technology platform capable on the one hand of conducting flexible, multidimensional OLAP analyses and, on the other hand, of delivering standard reporting facilities. Alongside pure analysis work, a need arose to configure this platform in such a way as to provide effective support to the optimised planning processes and functions. The previous planning and reporting system was characterised by the need for a high level of data collation and pre-processing. Qurius Advanced Solutions, a long-term partner of BOARD, was on hand to assist the company with the implementation of this project.


BOARD solution
The first step towards optimisation was to conduct a detailed analysis. Once all relevant reports had been assembled from the departments involved, together with a distribution address lists and frequency of report generation the project team was able to inventorise and categorise the full range of reports. With these systematically processed blocks of information, it was then possible to run workshops with the departments involved. During these workshops the characteristics and parameters required were identified, and the dimensions required to accommodate these factors decided upon. This process culminated in the design of a multidimensional data model, which enabled all relevant data to be obtained. The information gathered from the various different source systems soon made it clear that all the data needed to be collated and pre-processed in a central data warehouse or DWH. The structure for this DWH was implemented on an MS SQL server platform.

The data from the various different source systems is now updated each night night with the help of SSIS packages (SQL Server Integration Services). Thereafter, the data are consolidated and checked in accordance with defined routines. The outcome of this nightly update is a consistent set of data for use by BOARDs multidimensional analysis and planning tool.

Using this solution , the various departments involved are able to analyse their most critical data, sourced from various dimensions, and can do so quickly and flexibly. This includes for example the number of bednights, and the associated room utilisation level (single occupancy in double rooms etc.) in each Club, room category and the latest booking status. All this information can be layered in other dimensions, e.g. the bookings channel or guest demographics using a drill-down feature involving just a few clicks of the mouse. This completely eliminates the manual operation of processing data, and standard reports can be distributed automatically with the help of a report enrolment facility. This enables all users to obtain the specific information they require for their daily work, and to do so faster and more reliably.


Customer benefits
An enhanced level of transparency with utilisation analyses has been achieved by simplifying the reporting process. This has substantially reduced the resource required to pre-process data. Moreover, multidimensional analyses are now much easier to cover from all defined levels and are very easy to implement.

During implementation of the reporting process, due account was taken of the future need to use BOARD products for the analysis of planning data. This planning project will also be delivered by Qurius Advanced Solutions AG.


BOARD partners
Qurius Advanced Solutions is a specialist IT service provider that delivers management, planning and controlling solutions. The range of services provided by this company comprises business intelligence, data warehousing, systems integration and portals. The companys core skills focus on the following task areas: CPM, controlling, process consultancy, technology expertise and project management. Its customer base includes ABB, Primondo, Tamoil and 3PAGEN.

www.qurius.com