Loan Portfolio Risk Dashboard | Data Analytics Project Developed an interactive Loan Portfolio Ri...Loan Portfolio Risk Dashboard | Data Analytics Project Developed an interactive Loan Portfolio Ri...
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
Loan Portfolio Risk Dashboard | Data Analytics Project
Developed an interactive Loan Portfolio Risk Dashboard to analyze credit risk and loan performance across branches and loan types. The dashboard provides a consolidated view of total loan amount, total interest earned, NPA percentage, and bad loan exposure, enabling quick risk assessment.
Key insights include:
▪️Identification of high-risk branches based on NPA% and bad loan amounts.
▪️Comparison of NPA% by loan type (Personal Loan vs Home Loan).
▪️Dynamic rate adjustment simulation to estimate potential extra revenue.
▪️Clear visualization of portfolio health using KPI cards, gauges, and bar chart
Tools Used: Excel / Power BI
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