Download PDF
Kyvos Insights > Case Studies > OLAP Modernization at a Global Investment Bank
Kyvos Insights Logo

OLAP Modernization at a Global Investment Bank

Technology Category
  • Analytics & Modeling - Big Data Analytics
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Finance & Insurance
Applicable Functions
  • Business Operation
Use Cases
  • Predictive Quality Analytics
  • Real-Time Location System (RTLS)
Services
  • Data Science Services
The Challenge
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.
About The Customer
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 Solution
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.
Operational Impact
  • 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
Quantitative Benefit
  • A full cube with 600 million records took just 25 minutes
  • Incremental builds were even faster
  • Full dashboard refresh took less than 5 seconds

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

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