Samu331/vehicle-loan-risk-analysis

Credit risk dashboard using Python, SQLite and Power BI, and simulated South African loan data 🚗 Vehicle Loan Credit Risk Analysis Dashboard A data-driven credit risk dashboard built using **Python**, **SQLite**, and **Power BI**, analyzing vehicle loan behaviors for South African customers. --- 📊 Project Overview This project simulates a dataset for vehicle loan applications and performs a full end-to-end analysis to evaluate and flag high-risk customers based on financial behavior. --- 💡 Key Objectives - Perform data cleaning and ETL using Python - Calculate risk metrics: - Loan-to-Income (LTI) - Installment-to-Income ratio - Risk Flags (High vs Low) - Build a visual dashboard in Power BI to display: - Risk distributions - Age group & employment type impact - High-risk customer breakdown --- 🛠️ Tech Stack - **Languages**: Python, SQL - **Libraries**: Pandas, NumPy, Matplotlib, Seaborn - **Database**: SQLite - **BI Tool**: Power BI --- 📁 Folder Structure vehicle-loan-risk-analysis/ ├── data/ │ └── loan_data.csv ├── scripts/ │ └── etl.py # Python script for cleaning + transforming data ├── dashboard/ │ └── vehicle_loan_dashboard.pbix # Power BI dashboard file │ └── dashboard_screenshot.png # Screenshot preview for README │ ├── README.md # Project overview and instructions ├── requirements.txt # Python dependencies