Skip to content
VD
All projects

Data Analytics & BI, 2026

Bank Loan Analysis 2021

Loan-portfolio analysis with an interactive Streamlit dashboard covering applications, funding, repayments and loan health.

Streamlit apps sleep when idle and can take up to a minute to wake.

Bank loan portfolio, 202138,576 loansApplications38,576Funded$435.8MReceived$473.1MAvg. interest12.05%Loan statusFully paid 32,145Charged off 5,333Current 1,098Applications by month

The problem

Lenders need a clear view of application trends, funded vs. received amounts and loan status to monitor portfolio risk.

What it does

  • Datetime feature engineering for monthly and yearly trend analysis.
  • KPIs: total applications, funded and received amounts, average interest rate and DTI.
  • Breakdowns by loan status, purpose, home ownership and employment length.
  • Streamlit dashboard with trend and status views.

Built with

  • Python
  • Pandas
  • NumPy
  • Matplotlib
  • Seaborn
  • Streamlit

From the repository

Screenshots and charts as they appear in the project's code and notebooks.

Bank loan dashboard overview with KPI tiles
Bank loan dashboard overview with KPI tiles
Monthly loan application trends chart
Monthly loan application trends chart
Loan status distribution bar chart
Loan status distribution bar chart