Bank Loan Data Analysis Dynamic Dashboard
DESCRIPTION
Analyzed 40k rows of bank loan data using SQL and Excel skills.
When
January 2024
Who
Isha Choudhary
Data Scientist (Intern) - PW Skills
PROBLEM STATEMENT -
DASHBOARD 1 - SUMMARY
In order to monitor and assess our bank's lending activities and performance, we need to create a comprehensive Bank Loan Report. This report aims to provide insights into key loan-related metrics and their changes over time. The report will help us make data-driven decisions, track our loan portfolio's health, and identify trends that can inform our lending strategies.

Key Performance Indicators(KPIs) Requirements:
1. Total Loan Applications
2. Total Funded Amount
3. Total Amount Received
4. Average Interest Rate
5. Average Debt-to-Income Ratio (DTI)

DASHBOARD 2: OVERVIEW
In our Bank Loan Report project, we aim to visually represent critical loan-related metrics and trends using a variety of chart types. These charts will provide a clear and insightful view of our lending operations, facilitating data-driven decision-making and enabling us to gain valuable insights into various loan parameters. Below are the specific chart requirements.

CHARTS ON DASHBOARD
1. Monthly Trends by Issue Date (Line Chart)
2. Regional Analysis by State (Filled Map)
3. Loan Term Analysis (Donut Chart)
4. Employee Length Analysis (Bar Chart)
5. Loan Purpose Breakdown (Bar Chart)
6. Home Ownership Analysis (Tree Map)
Get a Data Scientist for Your Business
Unlock your business potential with Data-Driven Decision Making. Empower your ideas with a robust, data-backed strategy for success.
CONTACT Now