Comprehensive Bank Loan Analysis Dashboard Using Power BIComprehensive Bank Loan Analysis Dashboard Using Power BI
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
šŸ¦ Bank Loan Portfolio Analysis | Power BI Dashboard Project
Analyzed 38,576 loan records across 50 states to give a bank's lending division a unified view of portfolio health — something they simply didn't have before.
What the data revealed: āœ… Net-positive portfolio: $435.8M disbursed, $473.1M recovered āš ļø 13.8% bad loan rate = $28.25M net capital loss šŸ“Š Debt consolidation drives nearly half of all loan applications ā³ 73% of borrowers chose 60-month terms over 36-month šŸ“ 60%+ of repayments concentrated in just 5 states (CA, NY, FL, TX, NJ)
Tools used: PostgreSQL → Excel → Power Query → Power BI + DAX
Built two interactive dashboards: → Summary: KPI cards, good vs. bad loan segmentation, loan status grid → Overview: Trends, geographic maps, term/purpose/employment breakdowns
The next phase? Building a predictive risk scoring layer using DTI, interest rate, and employment length to flag at-risk loans before they default.
Open to feedback from data folks in the community šŸ‘‡
#PowerBI #DataAnalytics #SQL #DAX #BankingAnalytics #PortfolioAnalysis #DataVisualization

Post image
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started