duncanalyst/kenya-banking-risk-dashboard
Domaine:
socioeconomicType de record:
tools
Créateur:
dun
Hôte:
Excel dashboard analysing Kenya banking loan defaults — KPI cards, XLOOKUP, Power Query, conditional formatting, Pivot Tables and advanced formulas
# 🏦 Kenya Banking — Loan Portfolio Risk Dashboard
## Project Overview
Analysis of a Kenyan bank's loan portfolio identifying
credit risk concentration and default patterns across
counties, loan types and customer demographics.
## Key Findings
- **Portfolio Value:** KES 12,285,000
- **Default Rate:** 20% (4 of 20 loans)
- **Nairobi** accounts for 60% of all defaults 🚨
- **Personal loans** carry 57.7% default rate
- **Mortgage** portfolio fully performing (0% defaults)
- **Average repayment delay:** 19.1 days
- **Mombasa** emerging risk — 45 avg days late ⚠️
## 💡 Business Recommendations
1. Implement stricter credit screening for Personal loans
2. Conduct immediate Nairobi portfolio review
3. Monitor Mombasa closely — emerging default risk
4. Mortgage product strategy is working — maintain standards
## Tools & Skills Demonstrated
| Skill | Application |
|---|---|
| Power Query | Automated cleaning of 3 raw data sources |
| Merge Queries | Linked Customers + Loans + Repayments |
| Pivot Tables | 4 multi-dimensional risk analyses |
| COUNTIFS/SUMIF | Dynamic KPI calculations |
| Conditional Formatting | Automated risk traffic lights |
| Dashboard Design | Executive-ready presentation |
## 📁 Project Structure
| Sheet | Purpose |
|---|---|
| RAW_Customers | Original messy customer data |
| RAW_Loans | Original messy loan data |
| RAW_Repayments | Original messy repayment data |
| Master_Portfolio | Power Query merged master dataset |
| ANALYSIS | 4 Pivot Table risk analyses |
| DASHBOARD | Executive KPI dashboard |
## | Other Excel Analyst Projects |
- 🔗Kenya Healthcare Analytics — Patient Admission, Cost Analysis & Risk Dashboard
- 🔗Global-Superstore-Sales-Analysis-Dashboard
---
## | Microsoft SQL Server Analyst Projects |
- 🔗Olist-Ecommerce-SQL-Analysis
- 🔗IBM-HR-Attrition-SQL-Analysis
- 🔗Credit-Card-Fraud-Detection-SQL
---
## | PowerBI Analyst Projects |
- 🔗Olist-Ecommerce-PowerBI-Analysis
---
## 👤 Author
**NC-Dan (Duncan N Chicho)** | Data Analyst | Op …
Similaires
aadhavans-ailabs/Kenya-Risk-DashboardEugenekiyengo2/ea-banking-dashboardphilemon-kibor001/KENYA-FLOOD-RISK-ANALYSIS-AND-VISUALIZATION-DASHBOARD-CREDIT RISK MANAGEMENT AND ACCESS TO BANKING SERVICES BY ISLAMIC BANKING CUSTOMERS IN KENYALilyJorelle/malnutrition-risk-dashboardJosephnyingi/stunting-risk-dashboard