The Loan Portfolio Dashboard is a multi-page Power BI report designed to help financial institutions analyze, monitor, and optimize their loan portfolios. This project demonstrates my data analysis, visualization, and storytelling skills by transforming raw lending data into actionable business insights.
- Dataset:
sample_loan_portfolio.csv(5,000 records: loan status, income, term, interest rate, DTI, and more) - Report: Loan Portfolio Dashboard.pbix
- Visuals: Power BI, custom DAX, and Power Query transformations
- Removed blanks, standardized formats, and resolved data type mismatches in Power Query.
- Created analysis-ready columns for robust reporting.
- Built a star schema with a central fact table (
Loan_ID) and dimension tables (e.g.,Term,Home_Ownership). - Defined relationships for accurate cross-filtering and interactivity.
- Developed custom metrics:
Total Applications,Fully Paid Rate,Charged Off Rate,Average Interest Rate,Average DTI, and more. - Segmented metrics for risk, repayment, and borrower profiles.
- Disbursement trends, employment analysis, and time series insights.
- High vs. low-risk breakdown, interest rate, income, and state-wise lending.
- Analysis of repaid, outstanding, and charged-off loans.
- Home ownership, verification status, and term-based default behavior.
- Strategic recommendations and business actions.
- Interactive Visuals: Dynamic filters by term, status, and borrower traits; drillable bar and pie charts.
- Custom Design Theme: Consistent layout, color palette, and data-label formatting for professional readability.
- Strategic Recommendation Boxes: Actionable insights for business users on every page.
- 71.8% of loans fully paid; 13.7% charged off.
- Long-term (60-month) loans show higher default counts.
- Verification and home ownership have subtle but notable impacts.
- Charged-off borrowers received $13.7M but repaid only $4.2M—highlighting loss risk.
- High account count correlates with increased risk.
- Ensured precise alignment between visuals and KPIs.
- Maintained consistent navigation and minimal clutter.
- Focused on usability and business value throughout the design.
- Download the Loan Portfolio Dashboard.pbix file.
- Open with Power BI Desktop.
Reach out via 
Thank you for viewing my portfolio project!