# pratikshadandriyal/hospital-readmission-patient-flow-analytics architecture

> Architecture diagram of the GitHub repository pratikshadandriyal/hospital-readmission-patient-flow-analytics, 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/pratikshadandriyal/hospital-readmission-patient-flow-analytics
- Repository: https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics

## Overview

This repository is a hospital readmission analytics project, not a deployed clinical application. Its main workflow is to build a synthetic encounter dataset, analyze and feature-engineer it in Python and SQL, then present operational and readmission-risk findings in a two-page Power BI dashboard. Distinct capabilities include patient, doctor, and encounter data; cohort and readmission analysis; risk scoring; frequent-flyer cost analysis; and exploratory checks. The README documents the cross-tool workflow, but sampled source does not establish every file-level handoff, so uncertain connections are omitted.

Main entry points: [`python/generate_data.py`](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/python/generate_data.py) (Dataset Generator), [`data/encounters_features_powerbi.csv`](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/data/encounters_features_powerbi.csv) (Dashboard Features), [`powerbi/hospital-readmission-patient-flow-analytics.pbix`](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/powerbi/hospital-readmission-patient-flow-analytics.pbix) (Operations Dashboard), [`python/eda.py`](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/python/eda.py) (Exploratory Analysis)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Hospital Data"]
  node_generator["Dataset Generator<br/>[generate_data.py]"]
  node_patients["Patient Records<br/>[patients.csv]"]
  node_doctors["Doctor Records<br/>[doctors.csv]"]
  node_encounters["Encounter Records<br/>[encounters.csv]"]
  node_powerbi_data["Dashboard Features"]
end

subgraph group_analysis["Analytics"]
  node_eda["Exploratory Analysis<br/>[eda.py]"]
end

subgraph group_database["SQL Analysis"]
  node_sql_schema["SQL Tables"]
  node_sql_questions["Business Queries"]
end

subgraph group_dashboard["Power BI"]
  node_dashboard_file["Operations Dashboard"]
end

node_analyst(("Hospital Analyst"))

node_generator -->|"builds data"| node_patients
node_generator -->|"builds data"| node_doctors
node_generator -->|"builds data"| node_encounters
node_eda -->|"exports features"| node_powerbi_data
node_sql_schema -->|"defines tables"| node_sql_questions
node_analyst -->|"explores findings"| node_dashboard_file
node_powerbi_data -->|"powers dashboard"| node_dashboard_file

click node_generator "https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/python/generate_data.py"
click node_patients "https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/data/patients.csv"
click node_doctors "https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/data/doctors.csv"
click node_encounters "https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/data/encounters.csv"
click node_powerbi_data "https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/data/encounters_features_powerbi.csv"
click node_eda "https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/python/eda.py"
click node_sql_schema "https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/sql/01_create_tables.sql"
click node_sql_questions "https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/sql/02_business_questions.sql"
click node_dashboard_file "https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/powerbi/hospital-readmission-patient-flow-analytics.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_patients,node_doctors,node_encounters,node_powerbi_data toneBlue
class node_eda toneAmber
class node_sql_schema,node_sql_questions toneMint
class node_dashboard_file toneRose
class node_analyst toneIndigo
```

## Components

### Hospital Data

- [Dataset Generator](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/python/generate_data.py): `python/generate_data.py`
- [Patient Records](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/data/patients.csv): `data/patients.csv`
- [Doctor Records](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/data/doctors.csv): `data/doctors.csv`
- [Encounter Records](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/data/encounters.csv): `data/encounters.csv`
- [Dashboard Features](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/data/encounters_features_powerbi.csv): `data/encounters_features_powerbi.csv`

### Analytics

- [Exploratory Analysis](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/python/eda.py): `python/eda.py`

### SQL Analysis

- [SQL Tables](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/sql/01_create_tables.sql): `sql/01_create_tables.sql`
- [Business Queries](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/sql/02_business_questions.sql): `sql/02_business_questions.sql`

### Power BI

- [Operations Dashboard](https://github.com/pratikshadandriyal/hospital-readmission-patient-flow-analytics/blob/main/powerbi/hospital-readmission-patient-flow-analytics.pbix): `powerbi/hospital-readmission-patient-flow-analytics.pbix`

### Other components

- **Hospital Analyst**

## Connections

- Dataset Generator → Patient Records: builds data (evidence: `README.md`)
- Dataset Generator → Doctor Records: builds data (evidence: `python/generate_data.py`)
- Dataset Generator → Encounter Records: builds data (evidence: `README.md`)
- Exploratory Analysis → Dashboard Features: exports features (evidence: `python/eda.py`)
- SQL Tables → Business Queries: defines tables (evidence: `README.md`)
- Hospital Analyst → Operations Dashboard: explores findings (evidence: `README.md`)
- Dashboard Features → Operations Dashboard: powers dashboard (evidence: `README.md`)
