# mrbeastgamerzz/credit-risk-delinquency-analytics_project architecture

> Architecture diagram of the GitHub repository mrbeastgamerzz/credit-risk-delinquency-analytics_project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-06). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project
- Repository: https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project

## Overview

This is a credit delinquency analytics project that turns customer records into risk scores, explanations, and collections dashboards. The documented workflow moves from Excel exploration and cleaning through SQL analysis, Python preprocessing and modeling, SHAP explanations, and score export to Power BI. The Python excerpts show individual transformations and exports, but not a runtime orchestrator linking the scripts; phase-to-phase edges below are therefore based on README documentation. Excel, SQL, and Power BI internals are represented only at the level documented in the README and tree.

Main entry points: [`excel data/featured.csv`](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/featured.csv) (Featured Data), [`src/exporter.py`](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/exporter.py) (Score Export), [`sql/geldium.db`](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/sql/geldium.db) (SQLite Risk Data), [`excel data/processed/Cleaned_dataset.csv`](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/processed/Cleaned_dataset.csv) (Excel Cleaning)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_excel["Excel Analysis"]
  node_raw_data["Raw Customer Data"]
  node_excel_eda["Excel EDA"]
  node_excel_clean["Excel Cleaning"]
end

subgraph group_sql["SQL Risk Analysis"]
  node_sql_queries["Portfolio Queries<br/>[SQL_queries.sql]"]
  node_sql_db[("SQLite Risk Data<br/>[geldium.db]")]
end

subgraph group_python["Python Analytics"]
  node_preprocessing["Data Preprocessing<br/>[preprocessor.py]"]
  node_clean_data["Cleaned Data<br/>[fully_cleaned.csv]"]
  node_feature_engineering["Feature Engineering"]
  node_featured_data["Featured Data<br/>[featured.csv]"]
  node_eda_visuals["EDA Visuals<br/>[eda_plots.py]"]
  node_model_training["Model Training<br/>[model.py]"]
  node_trained_model["XGBoost Model<br/>[xgb_model.pkl]"]
  node_model_metrics["Evaluation Metrics<br/>[metrics.json]"]
  node_shap_analysis["SHAP Explanations<br/>[explainer.py]"]
  node_shap_report["Customer Risk Factors<br/>[shap_summary.csv]"]
  node_score_export["Score Export<br/>[exporter.py]"]
end

subgraph group_delivery["Risk Delivery"]
  node_dashboard_data["Dashboard Dataset<br/>[dashboard_data.csv]"]
  node_powerbi_dashboard["Collections Dashboard"]
end

node_risk_team(("Risk Team"))
node_collections_user(("Collections Stakeholders"))

node_raw_data -->|"explores"| node_excel_eda
node_excel_eda -->|"cleans"| node_excel_clean
node_excel_clean -->|"loads data"| node_sql_db
node_sql_queries -->|"queries"| node_sql_db
node_sql_db -->|"feeds foundation"| node_powerbi_dashboard
node_risk_team -->|"explores portfolio"| node_excel_eda
node_excel_clean -->|"provides input"| node_preprocessing
node_preprocessing -->|"writes"| node_clean_data
node_clean_data -->|"provides input"| node_feature_engineering
node_feature_engineering -->|"writes"| node_featured_data
node_featured_data -->|"provides input"| node_eda_visuals
node_featured_data -->|"trains on"| node_model_training
node_model_training -->|"saves"| node_trained_model
node_model_training -->|"writes"| node_model_metrics
node_featured_data -->|"explains predictions"| node_shap_analysis
node_shap_analysis -->|"loads"| node_trained_model
node_shap_analysis -->|"exports factors"| node_shap_report
node_featured_data -->|"scores customers"| node_score_export
node_score_export -->|"loads"| node_trained_model
node_score_export -->|"merges factors"| node_shap_report
node_score_export -->|"writes scores"| node_sql_db
node_score_export -->|"exports"| node_dashboard_data
node_dashboard_data -->|"powers"| node_powerbi_dashboard
node_powerbi_dashboard -->|"presents risk"| node_collections_user

click node_raw_data "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/raw/Delinquency_prediction_dataset.xlsx"
click node_excel_eda "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/eda%20in%20excel/Delinquency_prediction_dataset-eda.xlsx"
click node_excel_clean "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/processed/Cleaned_dataset.csv"
click node_sql_queries "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/sql/SQL_queries.sql"
click node_sql_db "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/sql/geldium.db"
click node_preprocessing "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/preprocessor.py"
click node_clean_data "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/fully_cleaned.csv"
click node_feature_engineering "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/feature_engineer.py"
click node_featured_data "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/featured.csv"
click node_eda_visuals "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/eda_plots.py"
click node_model_training "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/model.py"
click node_trained_model "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/outputs/model/xgb_model.pkl"
click node_model_metrics "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/outputs/reports/metrics.json"
click node_shap_analysis "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/explainer.py"
click node_shap_report "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/outputs/reports/shap_summary.csv"
click node_score_export "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/exporter.py"
click node_dashboard_data "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/outputs/reports/dashboard_data.csv"
click node_powerbi_dashboard "https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/powerbi/risk_engine_dashboards.pbix"

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_data,node_excel_eda,node_excel_clean toneBlue
class node_sql_queries,node_sql_db toneAmber
class node_preprocessing,node_clean_data,node_feature_engineering,node_featured_data,node_eda_visuals,node_model_training,node_trained_model,node_model_metrics,node_shap_analysis,node_shap_report,node_score_export toneMint
class node_dashboard_data,node_powerbi_dashboard toneRose
class node_risk_team,node_collections_user toneIndigo
```

## Components

### Excel Analysis

- [Raw Customer Data](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/raw/Delinquency_prediction_dataset.xlsx): `excel data/raw/Delinquency_prediction_dataset.xlsx`
- [Excel EDA](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/eda%20in%20excel/Delinquency_prediction_dataset-eda.xlsx): `excel data/eda in excel/Delinquency_prediction_dataset-eda.xlsx`
- [Excel Cleaning](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/processed/Cleaned_dataset.csv): `excel data/processed/Cleaned_dataset.csv`

### SQL Risk Analysis

- [Portfolio Queries](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/sql/SQL_queries.sql): `sql/SQL_queries.sql`
- [SQLite Risk Data](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/sql/geldium.db): `sql/geldium.db`

### Python Analytics

- [Data Preprocessing](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/preprocessor.py): `src/preprocessor.py`
- [Cleaned Data](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/fully_cleaned.csv): `excel data/fully_cleaned.csv`
- [Feature Engineering](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/feature_engineer.py): `src/feature_engineer.py`
- [Featured Data](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/excel%20data/featured.csv): `excel data/featured.csv`
- [EDA Visuals](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/eda_plots.py): `src/eda_plots.py`
- [Model Training](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/model.py): `src/model.py`
- [XGBoost Model](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/outputs/model/xgb_model.pkl): `outputs/model/xgb_model.pkl`
- [Evaluation Metrics](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/outputs/reports/metrics.json): `outputs/reports/metrics.json`
- [SHAP Explanations](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/explainer.py): `src/explainer.py`
- [Customer Risk Factors](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/outputs/reports/shap_summary.csv): `outputs/reports/shap_summary.csv`
- [Score Export](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/src/exporter.py): `src/exporter.py`

### Risk Delivery

- [Dashboard Dataset](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/outputs/reports/dashboard_data.csv): `outputs/reports/dashboard_data.csv`
- [Collections Dashboard](https://github.com/mrbeastgamerzz/credit-risk-delinquency-analytics_project/blob/main/powerbi/risk_engine_dashboards.pbix): `powerbi/risk_engine_dashboards.pbix`

### Other components

- **Risk Team**
- **Collections Stakeholders**

## Connections

- Raw Customer Data → Excel EDA: explores (evidence: `README.md`)
- Excel EDA → Excel Cleaning: cleans (evidence: `README.md`)
- Excel Cleaning → SQLite Risk Data: loads data (evidence: `README.md`)
- Portfolio Queries → SQLite Risk Data: queries (evidence: `README.md`)
- SQLite Risk Data → Collections Dashboard: feeds foundation (evidence: `README.md`)
- Risk Team → Excel EDA: explores portfolio (evidence: `README.md`)
- Excel Cleaning → Data Preprocessing: provides input (evidence: `README.md`)
- Data Preprocessing → Cleaned Data: writes (evidence: `src/preprocessor.py`)
- Cleaned Data → Feature Engineering: provides input (evidence: `README.md`)
- Feature Engineering → Featured Data: writes (evidence: `src/feature_engineer.py`)
- Featured Data → EDA Visuals: provides input (evidence: `README.md`)
- Featured Data → Model Training: trains on (evidence: `README.md`)
- Model Training → XGBoost Model: saves (evidence: `src/model.py`)
- Model Training → Evaluation Metrics: writes (evidence: `src/model.py`)
- Featured Data → SHAP Explanations: explains predictions (evidence: `README.md`)
- SHAP Explanations → XGBoost Model: loads (evidence: `src/explainer.py`)
- SHAP Explanations → Customer Risk Factors: exports factors (evidence: `src/explainer.py`)
- Featured Data → Score Export: scores customers (evidence: `README.md`)
- Score Export → XGBoost Model: loads (evidence: `src/exporter.py`)
- Score Export → Customer Risk Factors: merges factors (evidence: `src/exporter.py`)
- Score Export → SQLite Risk Data: writes scores (evidence: `src/exporter.py`)
- Score Export → Dashboard Dataset: exports (evidence: `src/exporter.py`)
- Dashboard Dataset → Collections Dashboard: powers (evidence: `README.md`)
- Collections Dashboard → Collections Stakeholders: presents risk (evidence: `README.md`)
