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

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

Qlik Logo
公司规模
Large Corporate
地区
  • Europe
国家
  • France
  • United Kingdom
产品
  • QlikView
技术栈
  • Microsoft Excel
  • TXT
  • XML
实施规模
  • Enterprise-wide Deployment
影响指标
  • Productivity Improvements
  • Cost Savings
技术
  • 分析与建模 - 实时分析
适用行业
  • 金融与保险
适用功能
  • 商业运营
服务
  • 数据科学服务
  • 系统集成
关于客户
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.
挑战
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 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.

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

相关案例.

联系我们

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

感谢您的信息!
我们会很快与你取得联系。