How biGENIUS helped implement the company-wide data warehouse within just 9 months, integrating 7 in-house and 2 online sources, improving the level of standardization, expandability and maintainability.
Scout24 Switzerland AG is the leading network of online marketplaces for vehicles, real estate and classified ads.
New requirements defined by the Scout24 top management as well as the shareholders Ringier and KKR to measure the performance of the online marketplaces were the trigger for the development of a company-wide business intelligence solution. The extensive (K)PIs were previously laid down independently by the business and the Scout24 marketplace managers. Neither the online systems nor the analysis solutions of the online marketplaces were able to provide the required key figures in a satisfactory quality and within the desired period.
Scout24 was looking for a suitable partner with many years of expertise in the design, implementation and maintenance of BI solutions to build the new business intelligence solution. Trivadis stood out from their competitors thanks to their high level of competence.
The solution includes a historicized data warehouse created according to the companys' DWH/BI best practices:
Work started immediately in October 2014. The essential basics for setting up the data warehouse were established within just 3 weeks and approved jointly. These were tailored to customer needs in productive and clearly structured workshops and then captured in a basic BI concept.
Basic BI concept
The first implementation unit, the integration of ImmoScout24, CRM and NET-Metrix, was launched in November 2014. Thanks to the central development tool - biGENIUS data warehouse generator - and the establishment of the basic BI concept, the release was made available to the customer in the required quality in December 2014. After completed delivery in January 2015, the first productive evaluations were created using the new data warehouse and presented to management.
The creation of a long-term data store was a central objective in order to clean up and free up the source systems. A historicized data store fulfils these requirements and forms the basis for further stages of expansion of the data warehouse.
In addition, a high level of standardization, expandability and maintainability were required to enable Scout24 to develop the data warehouse independently and at low cost. The use of the biGENIUS data warehouse generator enabled these requirements to be met and also supported the iterative approach in the development of the data warehouse.
1. Close collaboration between the Scout24 and project teams was very important for the successful implementation of the project. The solution was specified in several agile iterations, developed and agreed on together.
2. The timely and intensive involvement of all participating partners made it possible to implement the solution on time and on budget.
3. The close support of the business and the person responsible for BI during the delivery tests enforced the understanding for the new solution and confirmed the needs and requirements had been understood.
Accelerate and automate your analytical data workflow with comprehensive features that biGENIUS-X offers.
Stay updated on the biGENIUS application and get valuable insights on the development of data management technologies.
biGENIUS-X data vault generator for Apache Spark is now available.
In this use case demo, we show how to utilize biGENIUS-X features in a real project.