Project Overview
The Bank Loan Report Dashboard is structured into three main dashboards:
1. Summary Dashboard
Provides key performance indicators (KPIs) including:
Total Loan Applications
Total Funded Amount
Total Amount Received
Average Interest Rate
Average Debt-to-Income Ratio (DTI)
Additional features:
Month-to-Date (MTD) and Month-over-Month (MoM) comparisons
Good Loan vs Bad Loan segmentation
Loan Status Grid View for an overview of all loan statuses
2. Overview Dashboard
Visual representations to uncover trends and patterns:
Monthly Trends (Line Chart): Loan metrics over time
Regional Analysis (Filled Map): State-wise loan activities
Loan Term Analysis (Donut Chart): Distribution of loan terms
Employee Length Analysis (Bar Chart): Impact of employment length
Loan Purpose Breakdown (Bar Chart): Purpose-specific loan categorization
Home Ownership Analysis (Tree Map): Insights by home ownership status
3. Details Dashboard
A comprehensive data view combining:
Borrower profiles
Loan performance metrics
Financial indicators for deeper insights
