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
🏦 I built an interactive Bank Loan Report Dashboard entirely in Excel!
Is your loan data sitting in raw spreadsheets, making it hard to see which loans are performing and which are risky? I turned it into a clean, interactive dashboard that gives answers in seconds.
Key insights the dashboard reveals:
✅ Total loan applications, funded amount, and amount received at a glance
✅ Good loans vs bad loans (e.g. 86.18% good vs 13.82% bad overall)
✅ Average interest rate and DTI (Debt-to-Income) ratio tracking
✅ Month-to-Date (MTD) and Month-over-Month (MoM) performance
✅ Loan applications by month, state, term, employment length, purpose, and home ownership
✅ Loan status breakdown: Fully Paid, Current, and Charged Off
Features:
🔹 Multi-page dashboard: Summary, Overview, and Details
🔹 Interactive slicers to filter by loan grade and purpose
🔹 Dynamic KPIs, charts, and a state-wise map
🔹 Professional design that’s ready to present to management
Tools used: Microsoft Excel, Pivot Tables, Slicers, Dashboard Design, Data Analysis
💼 Need a custom Excel dashboard for your business data? Let’s connect!
📩 DM me or comment “EXCEL” to get started!
#Excel #DataAnalytics #DashboardDesign #BankLoan #FinancialAnalytics #DataVisualization #Freelancer #DataAnalyst #OpenToWork
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
Crypto Portfolio Dashboard
Blue means one thing here: the range you are looking at.
The value chart is a row of thin gray bars, and only the selected date range fills in blue. You read the period that matters and keep the months around it as context.
The phone carries the same chart above the holdings list. Each coin gets its own small bar chart between the name and the amount, so you can scan the whole portfolio for movement without opening a single coin.
Trading screens get busy fast. This one stays light and calm, so the numbers lead: total value, realized and unrealized P&L and open positions, all on one screen.
Designed by the Hue & Machine team.
#Crypto #Fintech #DashboardDesign #TradingPlatform #DataVisualization #UIDesign #ProductDesign #WebApp #MobileDesign #FigmaDesign
Nice Ui Dmytro
Business banking is already complex. The product shouldn’t make it feel even harder.
That was the thinking behind Bankora.
Payments, invoices, cash flow, financial overview. These are things business teams deal with constantly, yet many banking products still bury simple actions under dense data, long paths, and complicated navigation.
So I started with the workflows, not the screens.
I looked at the tasks people need to complete most often, where unnecessary steps appear, and what information actually needs attention first.
From there, I built the experience around clearer priorities: key actions available quickly, predictable navigation, structured financial data, and modular UI that makes things like pending and overdue invoices easier to understand at a glance.
I also designed an interactive cash flow calculator to help users see where the business may be heading, not just what has already happened.
The goal wasn’t to make financial operations simpler than they really are.
It was to make interacting with them feel simpler.
Less searching. Less cognitive load. More confidence in what to do next.
And it was especially nice to see Bankora later featured by Contra.
Lovely!
"Engineered an automated data-cleansing framework to audit, normalize, and restructure high-error transactional records. By resolving systemic data anomalies—including string irregularities, duplicate entity entries, schema mismatches, and null variances—this pipeline elevated raw, unreliable logs into clean, decision-ready assets primed for business intelligence modeling."
