# hemug1430/healthcare-rcm-analytics architecture

> Architecture diagram of the GitHub repository hemug1430/healthcare-rcm-analytics, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-20). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/hemug1430/healthcare-rcm-analytics
- Repository: https://github.com/hemug1430/healthcare-rcm-analytics

## Overview

This repository is a healthcare revenue-cycle analytics portfolio: it generates synthetic claims, analyzes billing and denial patterns, trains a denial classifier, and presents financial KPIs in Power BI. The shown training script reads the generated CSV directly; it does not load SQL results or save a model. README documents SQL aging/CARC analysis and dashboard capabilities, but the dashboard’s data connections are not visible in the sampled files, so those links are omitted.

Main entry points: [`data/synthetic_rcm_claims.csv`](https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/data/synthetic_rcm_claims.csv) (Synthetic Claims CSV), [`scripts/generate_data.py`](https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/scripts/generate_data.py) (Synthetic Claim Generator), [`sql/rcm_analytics.sql`](https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/sql/rcm_analytics.sql) (MySQL Claims Staging), [`scripts/train_denial_model.py`](https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/scripts/train_denial_model.py) (Denial Model Training)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_claims["Claim Data"]
  node_generator["Synthetic Claim Generator<br/>[generate_data.py]"]
  node_claims_csv["Synthetic Claims CSV"]
end

subgraph group_analytics["RCM Analytics"]
  node_sql_analytics["A/R and CARC Analytics<br/>[rcm_analytics.sql]"]
  node_claims_warehouse[("MySQL Claims Staging<br/>[rcm_analytics.sql]")]
end

subgraph group_prediction["Denial Prediction"]
  node_denial_model["Denial Model Training"]
end

subgraph group_reporting["Executive Reporting"]
  node_dashboard["Power BI RCM Dashboard"]
end

node_analyst(("RCM Analyst"))

node_generator -->|"writes CSV"| node_claims_csv
node_claims_csv -->|"loads claims"| node_denial_model
node_claims_warehouse -->|"analyzed by"| node_sql_analytics
node_analyst -->|"explores KPIs"| node_dashboard

click node_generator "https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/scripts/generate_data.py"
click node_claims_csv "https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/data/synthetic_rcm_claims.csv"
click node_sql_analytics "https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/sql/rcm_analytics.sql"
click node_claims_warehouse "https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/sql/rcm_analytics.sql"
click node_denial_model "https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/scripts/train_denial_model.py"
click node_dashboard "https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/Insights/Healthcare_RCM_Dashboard.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_generator,node_claims_csv toneBlue
class node_sql_analytics,node_claims_warehouse toneAmber
class node_denial_model toneMint
class node_dashboard toneRose
class node_analyst toneIndigo
```

## Components

### Claim Data

- [Synthetic Claim Generator](https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/scripts/generate_data.py): `scripts/generate_data.py`
- [Synthetic Claims CSV](https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/data/synthetic_rcm_claims.csv): `data/synthetic_rcm_claims.csv`

### RCM Analytics

- [A/R and CARC Analytics](https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/sql/rcm_analytics.sql): `sql/rcm_analytics.sql`
- [MySQL Claims Staging](https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/sql/rcm_analytics.sql): `sql/rcm_analytics.sql`

### Denial Prediction

- [Denial Model Training](https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/scripts/train_denial_model.py): `scripts/train_denial_model.py`

### Executive Reporting

- [Power BI RCM Dashboard](https://github.com/hemug1430/healthcare-rcm-analytics/blob/main/Insights/Healthcare_RCM_Dashboard.pbix): `Insights/Healthcare_RCM_Dashboard.pbix`

### Other components

- **RCM Analyst**

## Connections

- Synthetic Claim Generator → Synthetic Claims CSV: writes CSV (evidence: `scripts/generate_data.py`)
- Synthetic Claims CSV → Denial Model Training: loads claims (evidence: `scripts/train_denial_model.py`)
- MySQL Claims Staging → A/R and CARC Analytics: analyzed by (evidence: `README.md`)
- RCM Analyst → Power BI RCM Dashboard: explores KPIs (evidence: `README.md`)
