Case Study: OTA Insight achieves faster dashboard performance and cost savings with Devoteam

OTA Insight cuts dashboard load times from 26.4s to 5.7s with Devoteam

OTA Insight, a global leader in cloud-based hospitality business intelligence, faced performance issues with its Looker dashboards due to data being stored across multiple platforms, including BigQuery and a PostgreSQL data warehouse. This slow performance created concerns for their internal teams. Devoteam was engaged to conduct two proofs of concept (POCs) to address these challenges.

Devoteam implemented two solutions: a performance audit that optimized dashboards using Looker aggregate tables and a successful migration of a data pipeline from PostgreSQL to BigQuery. The results were significant, with one dashboard tile's execution time dropping from 26.4 seconds to 5.7 seconds and data read reducing from 1.53 GB to 790 MB. The migrated pipeline also saw a massive performance improvement, with queries that previously took over 50 minutes now running in a 2.5-minute pipeline. Devoteam provided OTA Insight with a clear path for a full migration and valuable cost-saving optimizations.

OTA Insight