Kyvos Insights Case Studies CCAR & Risk Management: Risk Forecasting with Instant BI on 500 Billion Transactions

Edit This Case Study Record

	CCAR & Risk Management: Risk Forecasting with Instant BI on 500 Billion Transactions Kyvos Insights

CCAR & Risk Management: Risk Forecasting with Instant BI on 500 Billion Transactions

Kyvos Insights

Technology Category	Analytics & Modeling - Big Data Analytics Analytics & Modeling - Real Time Analytics
Applicable Industries	Finance & Insurance
Applicable Functions	Business Operation
Services	Data Science Services
Challenge	The investment bank arm of a global financial institution was struggling to limit its daily risk exposure across its entire business. The risk analytics team found it difficult to assess their daily trading positions across various asset classes - foreign exchange, equities, fixed income, and other special products. They were unable to see how one asset class risk affected another. The bank set out to deliver a daily single consolidated view of its risk position to drill down into individual transactions. However, they faced several challenges: With over a billion risk points a day, they were struggling to create a consolidated view of risk across their assets. It was impossible to correlate risks across asset classes to understand trends. Analysts were unable to drill down into their data to understand complex transactions. Risk analysis was always late and deficient. Read More
About Customer	The customer is the investment bank arm of a global financial institution. The bank wanted to limit its daily risk exposure across its entire business. The risk analytics team was finding it difficult to assess their daily trading positions across various asset classes - foreign exchange, equities, fixed income, and other special products. They were unable to see how one asset class risk affected another. The bank set out to deliver a daily single consolidated view of its risk position to drill down into individual transactions. Read More
Solution	The bank used Kyvos, a BI acceleration platform that delivers instant insights on trillions of rows of data, both on the cloud and on-premise data lakes. The risk analytics team prepared data, created a common data schema for all asset classes, and built an OLAP-based semantic layer directly on their data lake. This enabled instant access to transaction-level data on a daily basis. Kyvos' Smart OLAP™ technology helped them quickly build an OLAP cube with 20 days of trading data. Data was added to the cube incrementally each day for analysis, and soon the OLAP cube had 160 days of data — approximately 500 billion transactions. Built-in integration with Tableau, Excel, Spotfire, and Java APIs, helped analysts work in a familiar environment. To ensure that access to the data lake had the same enterprise security that the bank required, Kyvos integrated with the company’s LDAP and Kerberos protocols. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Big Data Analytics

Analytics & Modeling - Real Time Analytics

Applicable Industries

Finance & Insurance

Applicable Functions

Business Operation

Services

Data Science Services

Challenge

The investment bank arm of a global financial institution was struggling to limit its daily risk exposure across its entire business. The risk analytics team found it difficult to assess their daily trading positions across various asset classes - foreign exchange, equities, fixed income, and other special products. They were unable to see how one asset class risk affected another. The bank set out to deliver a daily single consolidated view of its risk position to drill down into individual transactions. However, they faced several challenges: With over a billion risk points a day, they were struggling to create a consolidated view of risk across their assets. It was impossible to correlate risks across asset classes to understand trends. Analysts were unable to drill down into their data to understand complex transactions. Risk analysis was always late and deficient.

About Customer

The customer is the investment bank arm of a global financial institution. The bank wanted to limit its daily risk exposure across its entire business. The risk analytics team was finding it difficult to assess their daily trading positions across various asset classes - foreign exchange, equities, fixed income, and other special products. They were unable to see how one asset class risk affected another. The bank set out to deliver a daily single consolidated view of its risk position to drill down into individual transactions.

Solution

The bank used Kyvos, a BI acceleration platform that delivers instant insights on trillions of rows of data, both on the cloud and on-premise data lakes. The risk analytics team prepared data, created a common data schema for all asset classes, and built an OLAP-based semantic layer directly on their data lake. This enabled instant access to transaction-level data on a daily basis. Kyvos' Smart OLAP™ technology helped them quickly build an OLAP cube with 20 days of trading data. Data was added to the cube incrementally each day for analysis, and soon the OLAP cube had 160 days of data — approximately 500 billion transactions. Built-in integration with Tableau, Excel, Spotfire, and Java APIs, helped analysts work in a familiar environment. To ensure that access to the data lake had the same enterprise security that the bank required, Kyvos integrated with the company’s LDAP and Kerberos protocols.

Impact #1	Improved risk compliance with a daily consolidated view and analysis across all asset classes, incorporating data from 500 billion transactions
Impact #2	Power to perform 160-day trend analysis, updated daily, to understand risk behavior and correlate the impact of risks across assets
Impact #3	Interactive access to individual trade data via four familiar UIs - Tableau, Excel, Spotfire, and an in-house custom application

Impact #1

Improved risk compliance with a daily consolidated view and analysis across all asset classes, incorporating data from 500 billion transactions

Impact #2

Power to perform 160-day trend analysis, updated daily, to understand risk behavior and correlate the impact of risks across assets

Impact #3

Interactive access to individual trade data via four familiar UIs - Tableau, Excel, Spotfire, and an in-house custom application

Benefit #1	A daily consolidated view of risk across all asset classes
Benefit #2	Trend analysis on 160 days of historical data versus 9 days on prior designs
Benefit #3	Near-instant response times with insights in less than 5 seconds for hundreds of concurrent users

Benefit #1

A daily consolidated view of risk across all asset classes

Benefit #2

Trend analysis on 160 days of historical data versus 9 days on prior designs

Benefit #3

Near-instant response times with insights in less than 5 seconds for hundreds of concurrent users

Download PDF Version

Overview

CCAR & Risk Management: Risk Forecasting with Instant BI on 500 Billion Transactions

Operational Impact

Quantitative Benefit