How faisalkhan-7/capstone---predictive-credit-risk-analytics works
This repository documents a credit-risk analytics project for the Canadian Credit Union Association, rather than providing an application codebase. Its stated data workflow cleans and encodes loan records in Python, exports them to SQLite, and imports the resulting data into Power BI. The dashboard design spans portfolio risk, borrower stability, repayment trends, and DTI/utilization stress, with executive and underwriting drill-downs. The tree contains only a presentation and README, so relationships below reflect documented workflow and wireframe capabilities—not inspected runtime implementations.
Main entry points: README.md Power BI dashboards
Components 16
Data preparation
- Raw loan data
- Clean and encode
README.md - Analytics database
README.md - Power BI dashboards
README.md
Portfolio risk
- Portfolio overview
README.md - Purpose × funding tiers
README.md - Category detail
README.md
Borrower risk
- Borrower stability
README.md - Employment × homeownership
README.md
Repayment trends
- Loan status trends
README.md - Purpose × tenor
README.md - Segment detail
README.md
Credit stress
- DTI and utilization overview
README.md - DTI × utilization matrix
README.md - High-stress detail
README.md
Other components
- Executive / underwriter
Connections 15
- Raw loan data → Clean and encode: loads and cleans
README.md - Clean and encode → Analytics database: exports records
README.md - Analytics database → Power BI dashboards: imports data
README.md - Executive / underwriter → Power BI dashboards: explores dashboards
README.md - Power BI dashboards → Portfolio overview: presents
README.md - Portfolio overview → Purpose × funding tiers: drills into
README.md - Portfolio overview → Category detail: opens category
README.md - Power BI dashboards → Borrower stability: presents
README.md - Borrower stability → Employment × homeownership: compares factors
README.md - Power BI dashboards → Loan status trends: presents
README.md - Loan status trends → Purpose × tenor: drills into
README.md - Loan status trends → Segment detail: opens segment
README.md - Power BI dashboards → DTI and utilization overview: presents
README.md - DTI and utilization overview → DTI × utilization matrix: cross-tabulates
README.md - DTI and utilization overview → High-stress detail: drills into
README.md