Case Study: Leading US Financial Technology Services Company achieves consolidated analytics and sub-10s query performance with Kyvos Insights

Leading Fintech Eliminates Analytical Silos with OLAP on BigQuery

Leading US Financial Technology Services Company struggled to deliver a single, consolidated view of more than 50 billion annual transactions for hundreds of users across 100+ countries. Reporting was fragmented into 20 MicroStrategy intelligent cubes on Google BigQuery, causing long publish and reprocess times (over 6–24+ hours), capacity limits, and high cloud costs. Kyvos Insights was engaged to address these analytical silos using its cloud-native Smart OLAP solution on BigQuery.

Kyvos Insights consolidated the 20 cubes into a single, cloud-stored OLAP cube with native MicroStrategy connectivity, eliminating in‑memory limits and reducing cube build time from 24+ hours to 90 minutes. The new Kyvos cube aggregated 1.6 billion fact records, 2.4M unique Merchant IDs and 840K Customer IDs across 25 months of history, delivered query response SLAs under 10 seconds, cut compute costs, removed downtime for refreshes, and enabled hundreds of users to run unified, granular analytics.