Bank Loan Analytics

I developed a comprehensive Bank Loan Analytics Dashboard using SQL and Power BI to analyze loan performance, risk levels, and financial KPIs for better decision-making in banking operations.

The project involved extracting and transforming data from a structured loan dataset using SQL queries, then building interactive dashboards in Power BI to visualize key metrics such as loan applications, funded amounts, repayments, interest rates, and borrower behavior.

? Key Features & Analysis:

Total Loan Applications, Funded Amount, and Amount Received

Month-to-Date (MTD) and Previous Month-to-Date (PMTD) performance comparison

Good Loans vs Bad Loans analysis based on loan status

Key financial KPIs:

Average Interest Rate

Debt-to-Income (DTI) Ratio

Loan performance breakdown by:

State

Loan Purpose

Employment Length

Home Ownership

Loan Term

Trend analysis of loan applications and funding over time