Sandaya: Driving Growth with Real-Time Data Insights

The Challenge

As Sandaya experienced exponential growth over the past seven years, the expansion of campsites and an increasing influx of visitors resulted in a massive surge of data, posing significant challenges in data management and hindering marketers and analysts from gaining quick and clear insights. The data was scattered across multiple applications, requiring time-consuming processes of moving it from various sources, including on-premise locations, into spreadsheets and back to analyzing tools, taking days to complete. Moreover, the existing tools at Sandaya's disposal were ill-suited for the travel business, making it difficult to obtain the precise insights they sought.

Seeking an effective solution, Sandaya aimed to create an automated and user-friendly dashboard that could provide valuable insights into trends related to their campsite portfolio. The key requirements included swift sorting, filtering, and comparison of data based on specific travel characteristics, such as arrival date, country origin, accommodation type, region, campsite, and other critical dimensions and metrics. In addition, they sought a cloud-based solution to reduce internal infrastructure maintenance costs and facilitate rapid scaling.

In response to Sandaya's challenges, Crystalloids devised a custom solution InsightOS - an intuitive application developed using Google App Engine and Google BigQuery, tailored to assist travel companies in leveraging data for revenue improvement. InsightOS streamlined data storage, analysis, and processing, featuring the functionality to save and share specific views, graphs, or tables among colleagues.

To accommodate the unique needs of the travel industry, two separate InsightOS viewer applications were designed - the Arrival Viewer and the Booking Viewer - effectively handling the distinction between arrival and booking time units, providing seamless insights for Sandaya's data-driven decision-making.

The Solution - InsightOS

Crystalloids developed a tailored solution for Sandaya - InsightOS - an easy-to-use application built on Google App Engine and Google BigQuery, designed to enhance revenue through data utilization. This comprehensive tool streamlined data storage, analysis, and processing, allowing Sandaya to save and share views, graphs, and tables with colleagues.

Arrival and Booking Viewer Applications

Recognizing the unique requirements of the travel industry, Crystalloids created two distinct InsightOS viewer applications - the Arrival Viewer and the Booking Viewer.

The Arrival Viewer enables Sandaya to link various data sets, including customer, media, and sales, to arrival dates. Through facet navigation, future and past arrival dates can be selected, providing marketers and analysts with comprehensive insights into customer behavior.

The Booking Viewer, on the other hand, allows Sandaya to associate different datasets, such as destination, customer, sales, and media channels, with booking dates. The intuitive calendar element facilitates the comparison of past and present booking periods, with the ability to save selections for future reference.