Business and risk have always been seen to go hand-in-hand and the need for banks to strengthen their risk management framework is vital. Exposing the true risk profile to the users has been a challenging business problem due to multiple data sources and differences in operational processes and metric definitions.
To mitigate this situation, a financial institution should provide a holistic view of the risks faced by the organization at any point in time. When up-to-date information on risks can be analyzed and put at the users fingertips, firms will inevitably find it easier to maximize profit AND reduce risk.
The purpose of the Credit Risk Management demo is to illustrate how QlikView can be used by a
financial institution to manage credit risk. By providing a unified picture to the entire business, QlikView helps everyone have the same, up to date, picture of their risk exposure instead of disparate spreadsheets floating around the business. Credit Risk data is also interesting to the entire Business, not only the Credit Analysts. Are we pricing the products correctly? Are we in compliance with regulations? Should we continue to do business in a specific market or geographic segment? These are all questions that could be asked against Credit Risk data.
QlikView Credit Risk Management Dashboard application is designed to cover the following main analysis areas:
You can access the application by following the below links:
QlikView Credit Risk Management Dashboard Template online demo
QlikView Credit Risk Management Dashboard QVW file (opens with QlikView)
To mitigate this situation, a financial institution should provide a holistic view of the risks faced by the organization at any point in time. When up-to-date information on risks can be analyzed and put at the users fingertips, firms will inevitably find it easier to maximize profit AND reduce risk.
The purpose of the Credit Risk Management demo is to illustrate how QlikView can be used by a
financial institution to manage credit risk. By providing a unified picture to the entire business, QlikView helps everyone have the same, up to date, picture of their risk exposure instead of disparate spreadsheets floating around the business. Credit Risk data is also interesting to the entire Business, not only the Credit Analysts. Are we pricing the products correctly? Are we in compliance with regulations? Should we continue to do business in a specific market or geographic segment? These are all questions that could be asked against Credit Risk data.
- Exposure Concentration Analysis (Exposure : The total amount of credit extended to a client by the lending company)
- Correlation Analysis
- Probability of Default (PD) Analysis (The likelyhood that a borrower will default on their loans)
- Exposure Comperison
- Capital Allocation Modeling
You can access the application by following the below links:
QlikView Credit Risk Management Dashboard Template online demo
QlikView Credit Risk Management Dashboard QVW file (opens with QlikView)
Wonderful article. thanks for putting this together! This is obviously one great post. Thanks for the valuable information and insights you have so provided here.
ReplyDeletebusiness credit