US Banks' Loans Analysis

Welcome to the US Banks' Loans Analysis repository! Here you will find a collection of Tableau dashboards focusing on various aspects of loans in the banking sector. Each dashboard addresses specific questions and provides insights into different levels of loan data. I've also added query document which has all the queries that I used to get data based on KPIs' mentioned. This step was done in MS sql server and it was neccessary to perform so that I could crosscheck the ouput of the Tableau dashboard with the sql queries output. This provided analysis quality and correctness.

Dashboards

Please click on play button to expand and view the problem statement and screenshot

Summary Dashboard

Problem Statement

This dashboard provides a high-level summary of the total loan portfolio, including the distribution of different KPI's. The explanation why these KPIs' are used is given below:

1. Total loan applications: We need to calculate the total number of loan applications received during a specified period. Additionally, it is essential to monitor the Month- to – Date (MTD) loan applications and track changes Month- over- Month (MoM).
2. Total funded amount: - Understanding the total amount of funds disbursed as loans is crucial. We also want to keep an eye on the MTD total funded amount and analyze the Month- over- Month (MoM) changes in this metric.
3. Total amount received: - Tracking the total amount received from borrowers is essential for assessing the bank’s cash flow and loan repayment. We should analyze the Month- to – Date (MTD) total amount received and observe the Month- over- month (MoM) changes.
4. Average interest rate: - Calculating the average interest rate across all loans, MTD, and monitoring the Month-over-month (MoM) variations in interest rates will provide insights into our lending portfolio’s overall cost.
5. Average Debt- to -Income ratio (DTI): - Evaluating the average DTI for our borrowers helps us gauge their financial health. We need to compute the average DTI for all loans, MTD and track Month-over-Month (MoM) fluctuations.

Screenshot

---

Overview Dashboard

Problem Statement

Screenshot

---

Details Dashboard

Problem Statement

Screenshot

---

Tableau Public Link:

Click here to interact with dashboard

Additional Information

For more dashboards and detailed analysis, please visit my Tableau Public profile: Shreyas Lengade

Feel free to reach out for any questions or feedback!