下载PDF
Kyvos Insights > 实例探究 > OLAP Modernization at a Global Investment Bank
Kyvos Insights Logo

OLAP Modernization at a Global Investment Bank

技术
  • 分析与建模 - 大数据分析
  • 分析与建模 - 实时分析
适用行业
  • 金融与保险
适用功能
  • 商业运营
用例
  • 质量预测分析
  • 实时定位系统 (RTLS)
服务
  • 数据科学服务
挑战
A leading multinational investment bank and financial services company operating in 50 countries wanted to establish an executive-level global view of its financial data to support Management Discussion & Analysis (MD&A) for their C-suite. Their executives needed a single dashboard where they could measure the company’s performance on a comprehensive set of real-time measures and drill down to the lowest levels of granularity instantly. They also wanted to enable quick ad hoc analysis for 700 analysts located across the globe. Their reporting requirements were quite complex, and they needed a single view across all international businesses. It was difficult to use their existing BI environment to model complex financial KPIs and build reports on massive financial records. With no tolerance for latency, it became challenging to meet the high expectations and aggressive timelines from the executive team.
关于客户
The customer is a leading multinational investment bank and financial services company. They operate in 50 countries and have a large team of 700 analysts located across the globe. The company's executives needed a single dashboard where they could measure the company’s performance on a comprehensive set of real-time measures and drill down to the lowest levels of granularity instantly. They also wanted to enable quick ad hoc analysis for their analysts. The company's reporting requirements were quite complex, and they needed a single view across all international businesses. It was difficult to use their existing BI environment to model complex financial KPIs and build reports on massive financial records.
解决方案
The company deployed Kyvos to solve their data and BI challenges. Kyvos’ Smart OLAP™ technology enabled aggregation at a scale that was not possible earlier and allowed them to model complex data. The cubes quickly aggregated 5 years of financial data. A full cube with 600 million records took just 25 minutes, and incremental builds were even faster. As the cubes were pre-aggregated, users could drill down to the lowest level of detail in seconds. Even a full dashboard refresh took less than 5 seconds. Kyvos delivered high performance even for dimensions with complex alternate hierarchies and custom rollups. Quick incremental cube builds helped them manage refreshes as often as needed to support their business. The Kyvos semantic layerTM created a single source of truth, allowing them to keep complex business logic, such as year-over-year (YoY) calculations and currency conversions, in one place. It integrated seamlessly with Excel and MicroStrategy, enabling users to do complex analysis without any coding or the need to write formulas in their BI tools.
运营影响
  • Complete visibility into financial reporting, including MD&A
  • Cross LOB (line of business) reporting helped track the organization’s overall performance
  • Quick adjustments and restatements to the reported COB financials
数量效益
  • A full cube with 600 million records took just 25 minutes
  • Incremental builds were even faster
  • Full dashboard refresh took less than 5 seconds

相关案例.

联系我们

欢迎与我们交流!

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

Thank you for your message!
We will contact you soon.