# faisalkhan-7/capstone---predictive-credit-risk-analytics architecture

> Architecture diagram of the GitHub repository faisalkhan-7/capstone---predictive-credit-risk-analytics, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-21). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/faisalkhan-7/capstone---predictive-credit-risk-analytics
- Repository: https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics

## Overview

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`](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md) (Power BI dashboards)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data preparation"]
  node_raw["Raw loan data"]
  node_transform["Clean and encode<br/>[README.md]"]
  node_sqlite[("Analytics database<br/>[README.md]")]
  node_powerbi["Power BI dashboards<br/>[README.md]"]
end

subgraph group_portfolio["Portfolio risk"]
  node_sprint1["Portfolio overview<br/>[README.md]"]
  node_matrix["Purpose × funding tiers<br/>[README.md]"]
  node_detail["Category detail<br/>[README.md]"]
end

subgraph group_borrower["Borrower risk"]
  node_stability["Borrower stability<br/>[README.md]"]
  node_employment["Employment × homeownership<br/>[README.md]"]
end

subgraph group_repayment["Repayment trends"]
  node_trends["Loan status trends<br/>[README.md]"]
  node_segments["Purpose × tenor<br/>[README.md]"]
  node_segmentdetail["Segment detail<br/>[README.md]"]
end

subgraph group_stress["Credit stress"]
  node_dti["DTI and utilization overview<br/>[README.md]"]
  node_stressmatrix["DTI × utilization matrix<br/>[README.md]"]
  node_stressdetail["High-stress detail<br/>[README.md]"]
end

node_analyst(("Executive / underwriter"))

node_raw -->|"loads and cleans"| node_transform
node_transform -->|"exports records"| node_sqlite
node_sqlite -->|"imports data"| node_powerbi
node_analyst -->|"explores dashboards"| node_powerbi
node_powerbi -->|"presents"| node_sprint1
node_sprint1 -->|"drills into"| node_matrix
node_sprint1 -->|"opens category"| node_detail
node_powerbi -->|"presents"| node_stability
node_stability -->|"compares factors"| node_employment
node_powerbi -->|"presents"| node_trends
node_trends -->|"drills into"| node_segments
node_trends -->|"opens segment"| node_segmentdetail
node_powerbi -->|"presents"| node_dti
node_dti -->|"cross-tabulates"| node_stressmatrix
node_dti -->|"drills into"| node_stressdetail

click node_transform "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_sqlite "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_powerbi "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_sprint1 "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_matrix "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_detail "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_stability "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_employment "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_trends "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_segments "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_segmentdetail "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_dti "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_stressmatrix "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"
click node_stressdetail "https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_raw,node_transform,node_sqlite,node_powerbi toneBlue
class node_sprint1,node_matrix,node_detail toneAmber
class node_stability,node_employment toneMint
class node_trends,node_segments,node_segmentdetail toneRose
class node_dti,node_stressmatrix,node_stressdetail,node_analyst toneIndigo
```

## Components

### Data preparation

- **Raw loan data**
- [Clean and encode](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`
- [Analytics database](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`
- [Power BI dashboards](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`

### Portfolio risk

- [Portfolio overview](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`
- [Purpose × funding tiers](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`
- [Category detail](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`

### Borrower risk

- [Borrower stability](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`
- [Employment × homeownership](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`

### Repayment trends

- [Loan status trends](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`
- [Purpose × tenor](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`
- [Segment detail](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`

### Credit stress

- [DTI and utilization overview](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`
- [DTI × utilization matrix](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`
- [High-stress detail](https://github.com/faisalkhan-7/capstone---predictive-credit-risk-analytics/blob/main/README.md): `README.md`

### Other components

- **Executive / underwriter**

## Connections

- Raw loan data → Clean and encode: loads and cleans (evidence: `README.md`)
- Clean and encode → Analytics database: exports records (evidence: `README.md`)
- Analytics database → Power BI dashboards: imports data (evidence: `README.md`)
- Executive / underwriter → Power BI dashboards: explores dashboards (evidence: `README.md`)
- Power BI dashboards → Portfolio overview: presents (evidence: `README.md`)
- Portfolio overview → Purpose × funding tiers: drills into (evidence: `README.md`)
- Portfolio overview → Category detail: opens category (evidence: `README.md`)
- Power BI dashboards → Borrower stability: presents (evidence: `README.md`)
- Borrower stability → Employment × homeownership: compares factors (evidence: `README.md`)
- Power BI dashboards → Loan status trends: presents (evidence: `README.md`)
- Loan status trends → Purpose × tenor: drills into (evidence: `README.md`)
- Loan status trends → Segment detail: opens segment (evidence: `README.md`)
- Power BI dashboards → DTI and utilization overview: presents (evidence: `README.md`)
- DTI and utilization overview → DTI × utilization matrix: cross-tabulates (evidence: `README.md`)
- DTI and utilization overview → High-stress detail: drills into (evidence: `README.md`)
