Kyvos Insights > 实例探究 > Delivering Cost-effective and Scalable BI at a Leading Telecom

Delivering Cost-effective and Scalable BI at a Leading Telecom

Kyvos Insights Logo
公司规模
1,000+
产品
  • MicroStrategy
  • Kyvos
  • Smart OLAP™ technology
技术栈
  • OLAP
  • Big Data
  • Data Lake
实施规模
  • Enterprise-wide Deployment
影响指标
  • Cost Savings
  • Productivity Improvements
技术
  • 分析与建模 - 大数据分析
  • 平台即服务 (PaaS) - 数据管理平台
适用行业
  • 电信
适用功能
  • 商业运营
服务
  • 数据科学服务
  • 系统集成
关于客户
The customer is a global telecommunication company that was using MicroStrategy to deliver business insights to its 10K+ employees. The company deals with massive volumes of data, with more and more dimensions, metrics, and measures being added to their MicroStrategy reports. However, as the volume of their data increased, they faced challenges with response times, memory overload issues, and prohibitive costs. The company needed a solution that could handle their growing data volumes and deliver the desired performance.
挑战
The global telecommunication company was facing several challenges with their existing MicroStrategy BI tool. As the volume of their data increased massively, and more dimensions, metrics, and measures got added to their MicroStrategy reports, response times increased from seconds to several minutes, even for smaller and less complex reports. Transferring billions of rows of raw data from the data lake to MicroStrategy for computations caused the application to time out in most cases. Disconnects between the data collected by different departments such as marketing, finance, product development, and others made cross-functional analysis extremely difficult. Building cubes on MicroStrategy consumed 50% of resources, resulting in prohibitive costs. They also faced inconsistent response times on MicroStrategy queries and an inability to meet increasing business requirements as they could not accommodate additional dimensions and measures in reports without impacting performance.
解决方案
The company decided to implement an OLAP solution directly on their big data platform to deliver the desired performance. After evaluating several vendors such as AtScale and open-source platforms like Apache Kylin, they chose Kyvos as their BI acceleration platform. Using its Smart OLAP™ technology, Kyvos helped them build cubes on massive data volumes. Kyvos pre-aggregated and materialized the entire cube structure for speed, just like MicroStrategy cubes but at a much larger scale. Since the cubes were stored on the data lake and not in memory, it was easy to build cubes that were much larger than before. First, they migrated their existing MicroStrategy cubes to Kyvos, especially the ones that took a huge amount of platform memory and resources. Cube replication was easy as Kyvos uses the same principles and best practices to build cubes as MicroStrategy Developer. Then, they built new cubes on unoptimized raw data on the data lake. With Kyvos, it became easy to scale up architecture as they could increase compute power or get faster responses just by adding another node to the cluster.
运营影响
  • Query response times ranging from 0.25 to 0.65 seconds on billions of rows
  • Instant responses, even for thousands of concurrent users
  • No compromise with performance
  • Reduced overall MicroStrategy costs
  • Easy-to-scale architecture to deal with increasing workloads
数量效益
  • Incremental cube build time reduced to 2 minutes from to 30 minutes in MicroStrategy

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。