Judeeazike/loan-default-analysis-nigeria
Domain:
socioeconomicCreator:
Jud
Host:
A Power BI dashboard and SQL exploration of loan default trends in Nigeria.
# 📊 Loan Default Analysis Dashboard – Nigeria
An interactive Power BI dashboard that analyzes loan default trends in Nigeria. Includes SQL queries, Excel pivots, and actionable fintech insights.
This project explores a fictional loan dataset to identify patterns in **loan defaults** and provide actionable insights for Nigerian fintech and microfinance institutions. It combines data analysis with interactive visualizations to support smarter lending decisions.
---
## 🧠 Project Overview
This analysis was performed using:
- **Power BI** – for data visualization and dashboard creation
- **SQL Server** – for data querying and transformation
- **Microsoft Excel** – for initial data exploration with pivot tables
---
## 💡 Key Insights
- **Overall Default Rate**: ~20% of all issued loans
- **High-Risk Loan Purposes**: Business and Agriculture loans had the highest default counts
- **Demographic Patterns**:
- Majority of defaulters earned below ₦100,000
- Self-employed individuals defaulted more frequently
- Most defaults occurred in the 25–34 age group
- **Loan Trends**:
- Disbursements peaked mid-year
- Recent months showed increasing volumes
---
## 📁 Project Deliverables
| File | Description |
|------|-------------|
| `Loan_Default_Analysis.pbix` | Power BI dashboard file |
| `LoanData.sql` | SQL practice queries |
| `Nigeria_Loan_Data.csv` | Clean dataset used |
| `Screenshots/` | Preview images of the dashboard |
| `README.md` | This summary document |
---
## 🧰 Tools Used
- **Power BI Desktop**
- **Microsoft SQL Server**
- **SQL Server Management Studio (SSMS)**
- **Microsoft Excel**
---
## 📷 Dashboard Preview
> _Add screenshots here in your GitHub repo (e.g., dashboard full view, charts, slicers, etc.)_
## 📷 Dashboard Preview
### 📊 Power BI Dashboard Overview
### 📈 Raw Data Exploration in Excel
### 🧮 SQL Query Practice
### 📋 Pivot Table Exploration
---
## 📚 SQL Practice (20 Queries Included)
The project includes a set of SQL queries to:
- Ca …