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
Back to feedPost
🏦 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
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
Related posts
I analyzed 3M+ job postings across 161 countries and 93K companies to identify hiring trends, in-demand roles, work-mode patterns, and salary insights.
I used Python for data cleaning and preprocessing, SQL for analysis, and Power BI to build an interactive dashboard.
Key areas analyzed:
• Global hiring demand
• Top job roles by demand
• Remote vs. onsite/hybrid work patterns
• Average salary trends
• Monthly hiring trends
This project helped me turn a large dataset into clear, actionable insights for understanding the global job market.
Dashboard Key Highlights:
Total Performance: Total Revenue of $5,468 and Gross Profit of $2,313 with an overall profit margin of 42.3%.
Top Profit Contributor: Product D yields the highest gross profit at $1,548 (54.3% of total profit) and revenue of $2,808 (51.4% of total sales).
Highest Margin Product: Product A leads in efficiency with a 66.7% profit margin ($540 profit on $810 sales).
sales Performance Dashboard — Demo / Personal Portfolio Project
A business intelligence dashboard designed to track revenue, profit, profit margin, average order value, monthly trends, regional performance, and top-selling products.
Created using a synthetic dataset for portfolio demonstration purposes. This is not client work and contains no confidential information.
Tools: Power BI, Power Query, DAX, and Microsoft Excel.
