下载PDF
Qlik > 实例探究 > Crédit Agricole CIB Optimizes Value of Risk Analysis with Qlikview
Qlik Logo

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

技术
  • 分析与建模 - 实时分析
适用行业
  • 金融与保险
适用功能
  • 商业运营
服务
  • 数据科学服务
  • 系统集成
挑战
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.
关于客户
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 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.
运营影响
  • 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.
数量效益
  • 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.

相关案例.

联系我们

欢迎与我们交流!

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

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