Bank Loan Analysis Dashboard

Bank Loan Analysis Dashboard is a comprehensive data analytics project designed to evaluate loan performance and monitor key lending metrics using SQL Server and Power BI

The project transforms raw financial loan data into actionable business insights through data extraction, KPI calculations, and interactive visualizations

Key analyses include Total Loan Applications, Funded Amount, Amount Received, Average Interest Rate, and Debt-to-Income (DTI) Ratio

The solution also classifies loans into Good Loans and Bad Loans to assess portfolio risk and lending quality

Interactive dashboards provide detailed breakdowns by state, loan term, employment length, and loan purpose, enabling stakeholders to identify trends and make data-driven financial decisions

Technologies used include SQL Server, Power BI, DAX, and CSV-based financial datasets