Bank Loan Report Dashboard
A comprehensive Power BI dashboard analyzing 38K+ financial loan records to provide actionable insights into loan distribution, repayment performance, and risk assessment for data-driven decision making.
Power BI
DAX
Financial Analytics
Data Visualization
Power BI
Technology
38K+
Records
3
Dashboards
Completed
Status
Download Project Files
Financial Loan Dataset
CSV • financial_loan.csv
Download CSV
Domain Knowledge
PDF • Banking Concepts
View PDF
Problem Statement
PDF • Project Requirements
View PDF
SQL & DAX Queries
PDF • Data Transformations
View PDF
Data Dictionary
PDF • Field Definitions
View PDF
README.md
MD • Project Overview
View File
Dashboard Preview
Interactive Power BI dashboard with three comprehensive views for complete loan analysis
Key Features
- Overview Dashboard: Comprehensive view of total applications, funded amounts, and received amounts with real-time metrics
- Loan Status Analysis: Detailed breakdown of Approved, Rejected, and Charged-Off loans with visual representations
- Key Performance Indicators: Track interest rates, DTI ratios, and loan term distributions across the portfolio
- Interactive Filters: Dynamic filtering by loan purpose, State/Region, and Grade/Sub-grade for targeted analysis
- Risk Assessment: Color-coded visual indicators highlighting high-risk loan categories and segments
- Trend Analysis: Month-over-month and year-over-year comparisons with historical data visualization
Technologies & Tools
Power BI Desktop
Data visualization and dashboard creation
Data Modeling
Relationship management and data structure
DAX Formulas
Advanced calculations and measures
CSV Processing
38K+ records data transformation