🏦 Bank Loan Analysis Dashboard

🏦 Bank Loan Analysis Dashboard | Power BI & SQL

Transforming raw banking data into actionable insights using SQL, Power BI, Excel, and DAX.

Bank Loan Analysis is an end-to-end Business Intelligence solution designed to help banks and financial institutions monitor loan performance, borrower behavior, portfolio quality, and risk through interactive dashboards and KPI-driven analytics.

🔹 What I Did • Extracted, cleaned, and transformed loan data using SQL and Excel • Built an optimized data model in Power BI • Created interactive dashboards with drill-down and cross-filtering capabilities • Developed DAX measures for key banking and lending KPIs • Designed Summary, Overview, Risk & Profitability, and Details dashboards

📊 Dashboard Features • Executive Summary Dashboard • Loan Portfolio Overview • Good Loans vs Bad Loans Analysis • Funded Amount & Amount Received Analysis • Interest Rate & Debt-to-Income (DTI) Analysis • Loan Status Monitoring • Loan Purpose Analysis • Home Ownership Analysis • Risk & Profitability Dashboard • Loan Grade & Sub-Grade Analysis • Interactive Filters & Drill-through Navigation

🛠 Tools & Technologies • Power BI • SQL • Microsoft Excel • DAX • Power Query

📈 Project Impact • Analyzed 39K+ loan applications • Processed over $436M in funded loans • Tracked over $473M in loan repayments • Identified 86.18% Good Loans and 13.82% Bad Loans • Delivered interactive dashboards for faster, data-driven lending decisions • Improved portfolio monitoring through real-time KPI tracking

🔗 Live Dashboard https://app.powerbi.com/view?r=eyJrIjoiOTdlMzgxMWMtYmFkMi00MzQyLThmYzgtYjg4OTRkMzRjMzdhIiwidCI6ImY3ZGEyNGU1LWIyNDAtNDZlZC04OWFjLWE0NjczYTRlZGMxMSJ9

💻 GitHub Repository https://github.com/Sandeep-crtl/Bank_loan_analysis

📝 LinkedIn Project Post https://www.linkedin.com/feed/update/urn:li:activity:7418738759317450752/

#PowerBI #SQL #BankingAnalytics #FinancialAnalytics #BusinessIntelligence #DataAnalytics #Dashboard #DataVisualization #DAX #PowerQuery #LoanAnalysis #RiskAnalysis #BusinessAnalytics