Loan Analytics

Maintain profits by tracking loan maturity and design better loan products by understanding customer preference.

Loans add the largest chunk of revenue to bank’s basket. Loans have a bigger market than any other product and are available in multiple forms like home, auto, personal, business loans and more. Banks have loan management systems in place to record every activity. These activities ranges from application to disbursement, collections, interest calculation, brokers cut. There are reporting parts that include audit trails, aging’s, loan history and more. This system is more transactional in nature and helps in keeping records but not a strong source to take decisions.

Banks need a sophisticated business intelligence tool to extract, consolidate, transform and visualize data to understand risk involved in every application and disbursing the safest application in less time to mitigate risk, adhere to regulatory compliance and ensure customer satisfaction.

EzDataMunch’s pre-built banking analytics solutions comprises of comprehensive business intelligence dashboards. These dashboards gives users end-to-end insight into key metrics required to make accurate decisions and avoid surprises. Users get the option to create customer profiles that involves information such as applications, past dealings, credit ratings, transactions and more to reduce risk, predict future behavior, and ensure customer satisfaction.

Current loans & lendings

  • This dashboard summarizes total volume of existing loans and lendings by any financial institution.
  • Managers can view current status of loans by selecting categories like institution name, account number, daily advance accounts and top 10 accounts. A deeper view can be obtained by selecting more categories on the left side of the dashboard.
  • Also, top loans that have matured and callable advances for the day can be viewed.

Advances & Maturities

  • This dashboard represents total loans and advances that are matured and near to mature.
  • Managers can shift between advances and loans tabs to get a detailed view of maturity date, know the dollar value, name and account of the institution and agents handling the accounts.
  • Get a periodical overview of loans and maturities to understand trends and decide future actions.

Retail loan application dashboard.

  • This dashboard gives complete insight into total volume of loan applications and their dollar value.
  • Users have the options to select between retail and wholesale loans, drill down as per total applications and application value in dollar terms.
  • See total applications funded, rejected and dollar value.
  • Managers can also view the channels or source of application, which branch brought the lead, loan type like Fixed or LIBOR and more.

Retail loan application

  • Get detailed view of total number of application for both retail and wholesale loans.
  • See MCA (Maximum claim amount) for both the loan categories.
  • Drill down as per the location of applications and compare periodical variable to understand trends over time.

Automobile Finance

  • Auto finance dashboard gives complete health check of what is happening in this segment for any financial institute.
  • Users can see total number of auto finance application, auto financing approval rate and average ticket size of approved loan.
  • Drill down to know the decisions for every application and reasons for rejection of application as per industry and regulatory standard policies.


How to Use Simple Date Functions in QlikView and QlikSense

In the present competitive world, all organizations are showing an interest in Business Analytics by using different technologies like QlikView, QlikSense and Tableau etc. In different technologies, Year wise and Period wise analysis plays a major role for monitoring...
Read More

How to get started with NPrinting?

What is NPrinting and why it is used? Historically, QlikView has not had a particularly strong ability to print or publish reports. Qlik has preferred to concentrate their efforts on the strengths of QlikView - business intelligence and data discovery. This has lead...
Read More

Implementation of Incremental Load in QlikView and its Benefits

Why Incremental Load? Is your BI Application hitting Database for large volumes of data? If so, is it happening frequently? As BI applications are expected to deal with larger data sets, there is a need for frequent refreshes to get the updated data. In both the...
Read More

5 Milestones (Discoveries) driving Effective QlikView BI application

1) Data Access Layer: QlikView Adopts Multiple Data Sources. The QlikView Data Access layer supports heterogeneous data sources to load the data. Unlike all other reporting tools QlikView Data can be sourced from different databases using standard ODBC, OLEDB and JDBC...
Read More

Patient Care Analysis

Why Patient care analysis is important for Hospitals? In a 2009 report called "Crossing the Quality Chasm", the U.S. Institute of Medicine defined patient - centred care as: “providing care that is respectful of and responsive to individual patient preferences, needs,...
Read More

Six Rules to become a Quality QlikView Developer

If you have learned many programming languages but not settled in your career, QlikView can definitely boost your career. As a QlikView Developer, I would like to share my thoughts here. QlikView is growing rapidly. With over 30,000 customers, demand for skilled...
Read More

9 Reasons To Have Advanced Business Intelligence Tools

Generates Reports Quickly. There are multiple departments and processes in an organization. Thus data is scattered across the organization in various formats. Lot of effort is required to gather the data, cleanse it and convert it into desirable format for analysis...
Read More

6 Answers to Bolster Your Predictive Workforce Analytics Efforts.

Interview with Co-founder and President of EzDataMunch, Anupama Desai. Q: How is a specific line of business / business unit using your EzDataMunch predictive Workforce Analytics Software and Apps? How is your product deployed into operations? A: EzDataMunch is being...
Read More

7 ways analytics can help Supply Chain.

There are multiple factors that affect the success of supply chain process. These factors can be divided into four broad categories such as Political, social, economical and technology. Each category encompasses various elements such as increased regulatory pressure,...
Read More

Part 2: BI Software Implementation Pitfalls – Tips for a successful Proof of Concept.

7,098 total views, 50 views today

Address future requirements as well as current ones.
Consult with your own IT professionals.
Refuse to invest a lot of money in a POC.
Focus on BI dashboard capabilities –don’t get distracted by pretty visuals.

Read More


Up Coming Webinar

Completed Webinars


Share This