# rodrigosilva1936/healthcare-performance-analytics architecture

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

- Interactive diagram: https://gitdiagram.com/rodrigosilva1936/healthcare-performance-analytics
- Repository: https://github.com/rodrigosilva1936/healthcare-performance-analytics

## Overview

This is a healthcare analytics project, not an application service: its main workflow prepares the raw dataset with Python, analyzes the cleaned data in SQL Server, and presents results in Power BI. The graph preserves the documented cleaning, query-analysis, and dashboard stages, including the dashboard’s overview, regional, and trend capabilities. The README documents these workflow relationships; source excerpts were limited to the dependency list, so implementation-level calls are not established.

Main entry points: [`data/processed/healthcare-cleaned.csv`](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/data/processed/healthcare-cleaned.csv) (Cleaned dataset), [`data/raw/healthcare-data.csv`](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/data/raw/healthcare-data.csv) (Raw healthcare data), [`notebooks/data_cleaning.ipynb`](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/notebooks/data_cleaning.ipynb) (Data cleaning), [`powerbi/healthcare-performance-dashboard.pbix`](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/powerbi/healthcare-performance-dashboard.pbix) (Performance dashboard)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data preparation"]
  node_raw["Raw healthcare data"]
  node_understanding["Data understanding"]
  node_cleaning["Data cleaning"]
  node_cleaned["Cleaned dataset"]
  node_exploration["Exploratory analysis"]
end

subgraph group_analysis["SQL analysis"]
  node_overview["Data overview queries<br/>[data_overview.sql]"]
  node_episodes["Emergency episodes"]
  node_regional["Regional analysis"]
  node_waiting["Waiting time analysis"]
end

subgraph group_bi["Power BI reporting"]
  node_dashboard["Performance dashboard"]
end

node_analyst(("Analyst"))
node_sqlserver[("SQL Server")]

node_raw -->|"examines"| node_understanding
node_raw -->|"prepares"| node_cleaning
node_cleaning -->|"exports"| node_cleaned
node_cleaned -->|"explores"| node_exploration
node_cleaned -->|"imports into"| node_sqlserver
node_overview -->|"queries"| node_sqlserver
node_episodes -->|"queries"| node_sqlserver
node_regional -->|"queries"| node_sqlserver
node_waiting -->|"queries"| node_sqlserver
node_dashboard -->|"connects to"| node_sqlserver
node_analyst -->|"explores"| node_dashboard

click node_raw "https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/data/raw/healthcare-data.csv"
click node_understanding "https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/notebooks/understanding_data.ipynb"
click node_cleaning "https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/notebooks/data_cleaning.ipynb"
click node_cleaned "https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/data/processed/healthcare-cleaned.csv"
click node_exploration "https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/notebooks/exploratory_analysis.ipynb"
click node_overview "https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/sql/data_overview.sql"
click node_episodes "https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/sql/Emergency_Episodes_Analysis.sql"
click node_regional "https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/sql/regional_analysis.sql"
click node_waiting "https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/sql/waiting_time_analysis.sql"
click node_dashboard "https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/powerbi/healthcare-performance-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_raw,node_understanding,node_cleaning,node_cleaned,node_exploration toneBlue
class node_overview,node_episodes,node_regional,node_waiting,node_sqlserver toneAmber
class node_dashboard toneMint
class node_analyst toneIndigo
```

## Components

### Data preparation

- [Raw healthcare data](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/data/raw/healthcare-data.csv): `data/raw/healthcare-data.csv`
- [Data understanding](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/notebooks/understanding_data.ipynb): `notebooks/understanding_data.ipynb`
- [Data cleaning](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/notebooks/data_cleaning.ipynb): `notebooks/data_cleaning.ipynb`
- [Cleaned dataset](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/data/processed/healthcare-cleaned.csv): `data/processed/healthcare-cleaned.csv`
- [Exploratory analysis](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/notebooks/exploratory_analysis.ipynb): `notebooks/exploratory_analysis.ipynb`

### SQL analysis

- [Data overview queries](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/sql/data_overview.sql): `sql/data_overview.sql`
- [Emergency episodes](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/sql/Emergency_Episodes_Analysis.sql): `sql/Emergency_Episodes_Analysis.sql`
- [Regional analysis](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/sql/regional_analysis.sql): `sql/regional_analysis.sql`
- [Waiting time analysis](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/sql/waiting_time_analysis.sql): `sql/waiting_time_analysis.sql`

### Power BI reporting

- [Performance dashboard](https://github.com/rodrigosilva1936/healthcare-performance-analytics/blob/main/powerbi/healthcare-performance-dashboard.pbix): `powerbi/healthcare-performance-dashboard.pbix`

### Other components

- **Analyst**
- **SQL Server**

## Connections

- Raw healthcare data → Data understanding: examines (evidence: `README.md`)
- Raw healthcare data → Data cleaning: prepares (evidence: `README.md`)
- Data cleaning → Cleaned dataset: exports (evidence: `README.md`)
- Cleaned dataset → Exploratory analysis: explores (evidence: `README.md`)
- Cleaned dataset → SQL Server: imports into (evidence: `README.md`)
- Data overview queries → SQL Server: queries (evidence: `README.md`)
- Emergency episodes → SQL Server: queries (evidence: `README.md`)
- Regional analysis → SQL Server: queries (evidence: `README.md`)
- Waiting time analysis → SQL Server: queries (evidence: `README.md`)
- Performance dashboard → SQL Server: connects to (evidence: `README.md`)
- Analyst → Performance dashboard: explores (evidence: `README.md`)
