Skip to main content

Featured post

Golf Solutions Designed at Barnham Broom Golf Club in Norfolk

 Many sports tend to be biassed towards one sex or another. For example, football is a sport dominated by men and does not become much more masculine than rugby! On the other side of the fence, netball definitely falls into the women's category. However, there are some sports that share gender gracefully, which appeal to both men and women. Reddit live streaming Golf is undoubtedly one of these sports and has no age limits. Spread across courses in the UK you will find some unlikely groups of people bound by their love for this great outdoor sport. Some will play every day, while others will only play on the weekends, perhaps as a way to relieve the stress of a difficult week at the office. No golfer tends to join a club and membership packages vary widely in price. Most golf clubs simply offer standard packages with the assumption that one size fits all and offers a bit of flexibility. However, some offer more realistic membership packages, considering how much you will be playing...
Post a Comment

Credit Risk Management Dashboard Demo by QlikView Business Intelligence Platform

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:
  • 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
The application allows you to load your own data. If you download the zip file below, you will see a RiskData Excel file in it. You can input your data in this format by simply opening Credit Risk Management Dashboard app and selecting File > Reload.

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)


Labels:

Comments

Post a Comment

Popular posts from this blog

What is JEDOX?

Jedox is a Self Service Business Intelligence, Analytics and Performance Management platform developed by Jedox AG based in Freiburg im Breisgau/Germany. With a modular structure, JEDOX platform uses Microsoft Excel as its user interface on the one hand and a Jedox-specific spreadsheet on the other, both of which can be used in all common browsers. Jedox is unique in a sense that while most business intelligence solutions try to replace MS Excel based analysis and planning process entirely with their platform (and usually fails to do so because at one point things are exported to Excel), Jedox puts the powerful MS Excel sheet in the heart of their solution. By doing this they provide a familiar interface to users while enhancing business intelligence capabilities far beyond MS Excel. This is actually what JEDOX offers in a nutshell : Excel Plus. The modular architecture of JEDOX has a cell-oriented, multi-dimensional in-memory OLAP server that has been especially designed for...
Post a Comment
Read more

The Black Death and how it changed Europe

 In the dark ages, religious dogma is the law, science is a cult that can be executed, and technology is considered the devil's masterpiece. History and public consciousness bear in mind the aforementioned features of the Dark Ages and the Crusades, which were only examples of the goals of European imperialism. However, there was another major event in the Dark Ages that greatly influenced modern culture in its own right. In fact, a widespread bacterial infection could be said to have a greater impact than most other events at the time. A small bacterial infection wiped out nearly half of Europe, setting off the invasion of the Mongol tribes of Genghis Khan. The same pandemic has left Europe in such a weakened state that it took almost a century for most major nations to recover. A small bacterial infection turned into a large-scale epidemic, spawning many heretical Christian groups, and indirectly leading to the formation of the Inquisition, which paralyzed the old world for deca...
Post a Comment
Read more

Data Analytics for Online Shops

Making shopping a smooth and easy experience is the goal of many online shops. But how can easy website navigation be optimized? Unlike the physical shops, you cannot talk to the sales people in the online shops and a customer should find his or her way through the online shop. And unlike pysical shops, online shops can have hundreds of thousands of visitors every day. To optimize the shopping experience, some important questions should be answered : Why do customers put products into their shopping cart and do not buy them at the end? Was it because of the sales process or he/she liked another product simply better? What impact has a customer's drop from a detail page? Where are the differences in customer behavior depending on the different product groups, Customer types or assortments? What are the figures compared to the previous year? Were there any technical errors? Was the accessibility of all pages always guaranteed? Traditionally, answering these questions require a lot of...
Post a Comment
Read more