Qlik > Case Studies > Crédit Agricole CIB Optimizes Value of Risk Analysis with Qlikview

Crédit Agricole CIB Optimizes Value of Risk Analysis with Qlikview

Qlik Logo
Customer Company Size
Large Corporate
Region
  • Europe
Country
  • France
  • United Kingdom
Product
  • QlikView
Tech Stack
  • Microsoft Excel
  • TXT
  • XML
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Productivity Improvements
  • Cost Savings
Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Finance & Insurance
Applicable Functions
  • Business Operation
Services
  • Data Science Services
  • System Integration
About The Customer
Crédit Agricole CIB is the corporate and investment banking division of the Crédit Agricole financial services group in France. The bank specializes in capital markets, offering customers a range of products and services, including wholesale banking, investment banking, and structured finance. Crédit Agricole CIB provides support to its customers in major international markets due to its global network in leading countries in Europe, the Americas, Asia, and the Middle East. The bank's fixed income markets monitoring & control (FIM M&C) business unit is a small team tasked with cross-functional missions with a wide area of research— principally market and credit risk across all FIM products worldwide.
The Challenge
Crédit Agricole CIB's fixed income markets monitoring & control (FIM M&C) business unit faced the challenge of optimizing the use of reports produced by market and credit risk teams. The team needed to deploy tools to help consolidate data from various Crédit Agricole CIB risk teams. Prior to QlikView, the FIM M&C team received Microsoft Excel spreadsheets containing information on different fixed income market product lines by email. Consolidating and analyzing such data volumes was a challenge, but there was the added challenge of all the different file formats. Each product line had its own front-office and back-office system. Terms used, file formats, and information sending frequency were all different. This made it difficult for the FIM M&C because it needed to obtain a transversal and consolidated view of the data. The objective was also to compare historical data, which was difficult with the previous system.
The Solution
The QlikView deployment required implementation of a rigorous data model to harmonize references and create the necessary cross-reference tables. The system stores source files in a QlikView directory. They are then read and interpreted by the relevant QlikView applications. This functionality supports the move from a multitude of disparate sources to centralized monitoring. QlikView applications also ensure easier detection of variations, either graphically or by implementing appropriate technical and functional integrity checks. If a figure appears to be unexplained, it's easy to detect and it's possible to return the file to the relevant department for amendment. With QlikView, different types of checks have been implemented. For the technical integrity of data, automatic checking of the date of a file, as well as its size and name, means it's easier to evaluate information consistency.
Operational Impact
  • QlikView has radically changed the fixed income team's ways of working. It used to take the FIM M&C team up to a day to examine the figures to assess whether there was any risk within the parameter under scrutiny. Today, QlikView control panels and visual retrieval mean that the teams can instantly spot whether something needs to be investigated.
  • QlikView provides the tools to explore data via its filter, focus, and drill-down functions if an abnormal situation appears.
  • With highly flexible data navigation, QlikView analysis can be refined at different consolidation levels reflecting the fixed income markets team's organization and structure. Analysts can go from a FIM view, which is the most aggregated, to a deal view, which is the most refined. This exploration capability is essential for carrying out in-depth analysis of risk levels.
Quantitative Benefit
  • With QlikView, the same operation now takes 10 seconds and can be repeated every day as required.
  • Around 20 QlikView applications have now been implemented, according to need.

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

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.