dashboard page template for tableau on Finance (Bank, Wealth, FO...) Loans Loans Delinquent and Default Loans data visualization dataviz

Presentation

This cockpit shows the volume and number of delinquent and default loans of your top Branches or Loan Types:

For each of them, you can see both the last 24 months evolution and the performance for the current select period.

Below the top KPIs, you can visualize the performance breakdown of your top Branches or Loan Types sorted by the KPI of your choice.

 

Select KPI

'Select KPI' selector allows you to easily switch from one KPI to another, so you can analyze your data from any point of view.

The list of available KPIs is defined during the configuration of your dashboard in LinPack.

In your Loans dashboard, you will be able to select the following KPIs:

  • Total Liabilities Total outstanding amount by borrowers, excluding fees and interest AFTER payment of the current period.
  • Nb Loans Total number of active loans during the period
  • Total New Loans Total Amount borrowed for new loans during the period
  • Nb New Loans Total number of new loans, starting during the period
  • Full Loan Amount Full amount borrowed for the loan.
  • Full Loan Interests Full amount of Interests to be paid for the loan.
  • Full Loan Fees Full amount of Fees to be paid for the loan.
  • Total Amortization Total repayment of the borrowed amount during the period
  • Total Interests Total amount of monthly interests to be paid during the period
  • Total Fees Total amount of monthly fees to be paid during the period
  • Total Revenue Total revenue (interests and fees) generated by the current loans during the period
  • Revenue Rate Revenue rate generated by borrowers: Paid Interests + Fees / Paid Loan Amortization
  • Nb Delinquent Loans Total number of Delinquent loans during the period (having Nb of days Past Due between 60 and 270)
  • Loan Delinquency Rate Percentage of Delinquent loans: Delinquent loans / total active loans
  • Total Delinquent Loans Total outstanding amount by Delinquent loan, excluding fees and interest AFTER payment of the current period.
  • Nb Loan Defaults Total number of Default loans during the period (having Nb of days Past Due over 270)
  • Loan Default Rate Percentage of Delinquent loans: Default loans / total active loans
  • Total Loan Defaults Total outstanding amount by loan in Default, excluding fees and interest AFTER payment of the current period.
  • (+ any KPI you want to add to your Loans dashboard)

 

Select Dimension

'Select Dimension' selector allows you to easily switch from one dimension (analytical axis) to another, so you can analyze your data from any point of view.

The list of available dimensions is defined during the configuration of your dashboard in LinPack.

In your Loans dashboard, you will be able to select the following dimensions:

  • Month SnapshotMonth of the snapshot
  • BorrowerFull name of the borrower
  • BranchName of the Branch/Agency
  • Loan #ID of the Loan
  • Loan Start DateStart date of the Loan
  • Loan End DateEnd date of the Loan
  • Loan TypeType of the loan (Credit cards, Auto Loan, Student loan, Personal Loan, Mortgage, Small Business Loan, ...)
  • Is Delinquent LoanContains "Y" if the loan is considered as Delinquent (usually between 60 and 270 days past due) and "N" if the loan is not delinquent (either less than 60 days past due or more than 270)
  • Is Default LoanContains "Y" if the loan is considered as Default (usually after 270 days past due) and "N" if the loan is not Default.

 

Select Current Period

'Current Month' and 'Current Year' selectors allow you to easily select what is the period (month and year) you want to analyze.

 

Select Performance Scope

'Performance Scope' selector allows you to easily switch from one type of Performance Analysis to another.

Just pick-up what you want to analyze:

There are five types of Performance Analysis available:

  • Current Month vs Previous Month (e.g. if you selected Nov-2017 as being your current month, you will analyze Nov-2017 vs Nov-2016)
  • Current Month vs Same Month, Previous Year (e.g. if you selected Nov-2017 as being your current month, you will analyze Nov-2017 vs Oct-2017)
  • Current Month: Actual vs Target  (e.g. if you selected Nov-2017 as being your current month, you will analyze Actual Nov-2017 vs Target Nov-2017)
  • Year-to-Date: Current Year vs Previous Year (e.g. if you selected Nov-2017 as being your current month, you will analyze YTD Nov-2017 vs YTD Nov-2016)
  • Year-to-Date: Actual vs Target  (e.g. if you selected Nov-2017 as being your current month, you will analyze Actual YTD Nov-2017 vs Target YTD Nov-2017)

Note: 'Current Month: Actual vs Target' and 'Year-to-Date: Actual vs Target' are only available in the list if at least one of your KPIs is defined as having a related Target.

 

Filter your data

This data visualization comes with four top filters:

In your Loans dashboard, you will be able to filter on:

  • BranchName of the Branch/Agency
  • Loan TypeType of the loan (Credit cards, Auto Loan, Student loan, Personal Loan, Mortgage, Small Business Loan, ...)

 

How to read a KPI Card

This DataViz shows the performance of a given KPI.

It combines three components.

  • In the foreground, you can see the KPI name, its value and a symbol that indicates whether the KPI is above or under the reference (the reference is defined by the chosen value in the Performance Scope selector). This first component is colored depending on the evaluation.
  • In the background, an area chart shows the monthly evolution of the KPI across the last 24 months based on the selected period.
  • Below the chart, the variance in % vs the reference is displayed.

Other DataViz in "Loans" Pack

Cockpit

Cockpit Loans

Cockpit Loans
Cockpit Loans Cockpit Loans
This cockpit provides an overview of the loans you manage: What volume of loans do we manage? What is our new Business? How much revenue did our loans have generated? What are our top Loan Type?

Banking Analytics

Loans Revenue

Loans Revenue
Loans Revenue Loans Revenue
Visualize your best-in-class Branches or Loan Types in revenue generated.

Loans Maturity

Loans Maturity
Loans Maturity Loans Maturity
This dashboard page provides you with insightful information on the maturity of your loans at the level of detail of your choice: When will our loans expire?

Delinquent and Default Loans

Delinquent and Default Loans
Delinquent and Default Loans Delinquent and Default Loans
Visualize where your delinquent and default loans are the most impactful.

Borrower Detail

Borrower Detail
Borrower Detail Borrower Detail
Explore the main information about your borrowers and the loan they have taken out.

Behavioral Analytics

Loans Adhoc Analysis

Loans Adhoc Analysis
Loans Adhoc Analysis Loans Adhoc Analysis
Perform simple ad-hoc analysis on your Loans data set: analyze any of your KPIs across any dimension (trends, distribution and pareto analysis)

Loans KPI Performance

Loans KPI Performance
Loans KPI Performance Loans KPI Performance
Visualize the overall performance of any of your Loans KPIs: what is the performance, how does this performance evolve, who contributes to this performance

Other Dashboard Templates