Bank-Loan-Performance-Analysis

This Project analyzed the percentage, Impact and Overcomes of Good and Bad Loan Applications

Tools Used

• MYSQl
• PowerBI

Key Findings

• Developed a date table and established relationships to enable advanced time-based analysis.
• Designed KPIs (e.g., Total Loan Applications, Total Funded Amount, MTD, MoM) and visualizations like line charts, donut charts, maps, and treemaps.
• Developed a comprehensive dashboard with Summary, Overview, and Details pages to analyze loan applications, funded amounts, and interest rates.