Optimizing a travel portal’s BI reporting via a centralized data warehouse
Overview
Industry
Location
Travel and leisure
Poland
Technology Used
Apache Airflow
JupyterHub
MySQL
Nagios
PostgreSQL
S3
Tableau
Talend OpenStudio for Data Integration
Show more
Project overview
Our client, an operator of a travel booking platform, needed a single, central data source to replace their fragmented and diverse existing databases. We developed an on-premises data warehouse to process and structure this data for easier access and analysis. This solution now serves as the foundation for our client’s internal operations, by greatly enhancing data integration, analysis and the overall use of data in the company’s day-to-day operations.
Client background
A Polish company founded in 2013 that operates a travel booking platform specializing in offering hotel and accommodation packages at attractive prices. It combines both a reservation service and a travel magazine, providing travelers with ideas and deals primarily for destinations within Poland and abroad.
Goals
Our key objectives included introducing data governance principles and simplifying existing database structures. A major focus was on boosting data exchange efficiency and integrity by consolidating distributed business processes into a single, central system. A significant goal was also to deliver a flexible and scalable analytical and reporting environment for employees, notably by creating online reports using Tableau.
Results
Centralizing data foundation
The centralized environment integrates distributed business processes across IT systems, aligning operations and notably simplifying the organization's architecture.
Unifying data and achieving synergy
Combining data from diverse sources and the implemented deduplication and standardization results in significant data synergy.
Improving reporting and analytics
Analysts now benefit from improved reporting from a single source of truth, enabling publication of predefined reports.
Implementing data management principles
Robust data management principles were implemented, ensuring data quality, governance and reliability.
Ensuring real-time data access
The solution ensures cyclic data refresh, providing users with access to current data for timely insights.
We'd love to hear from you!
Fill out the form - we'll get back to you as soon as possible
