# akashmurugesan-datascientist/nhs-waiting-time-analysis architecture

> Architecture diagram of the GitHub repository akashmurugesan-datascientist/nhs-waiting-time-analysis, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-02). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/akashmurugesan-datascientist/nhs-waiting-time-analysis
- Repository: https://github.com/akashmurugesan-datascientist/nhs-waiting-time-analysis

## Overview

This repository is an NHS waiting-time analysis project: its README describes using SQL, Python and Power BI to identify demand trends and hospital performance. The tree contains the dataset, analysis artifacts and dashboard/report files. No source excerpts or documented data-flow links are available, so relationships between artifacts are omitted rather than inferred.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Waiting-time data"]
  node_waiting_data["Waiting-time CSV"]
end

subgraph group_analysis["Analysis artifacts"]
  node_sql_analysis["SQL analysis<br/>[sql_analysis.sql]"]
  node_python_analysis["Python analysis"]
end

subgraph group_reporting["Results"]
  node_powerbi_dashboard["Power BI dashboard"]
  node_dashboard_pdf["Dashboard PDF"]
end

node_analyst(("Analyst"))

click node_waiting_data "https://github.com/akashmurugesan-datascientist/nhs-waiting-time-analysis/blob/main/nhs_waiting_times.csv"
click node_sql_analysis "https://github.com/akashmurugesan-datascientist/nhs-waiting-time-analysis/blob/main/sql_analysis.sql"
click node_python_analysis "https://github.com/akashmurugesan-datascientist/nhs-waiting-time-analysis/blob/main/python_analysis.ipynb"
click node_powerbi_dashboard "https://github.com/akashmurugesan-datascientist/nhs-waiting-time-analysis/blob/main/nhs_waiting_time_dashboard.pbix"
click node_dashboard_pdf "https://github.com/akashmurugesan-datascientist/nhs-waiting-time-analysis/blob/main/nhs_waiting_time_dashboard.pdf"

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_waiting_data toneBlue
class node_sql_analysis,node_python_analysis toneAmber
class node_powerbi_dashboard,node_dashboard_pdf toneMint
class node_analyst toneIndigo
```

## Components

### Waiting-time data

- [Waiting-time CSV](https://github.com/akashmurugesan-datascientist/nhs-waiting-time-analysis/blob/main/nhs_waiting_times.csv): `nhs_waiting_times.csv`

### Analysis artifacts

- [SQL analysis](https://github.com/akashmurugesan-datascientist/nhs-waiting-time-analysis/blob/main/sql_analysis.sql): `sql_analysis.sql`
- [Python analysis](https://github.com/akashmurugesan-datascientist/nhs-waiting-time-analysis/blob/main/python_analysis.ipynb): `python_analysis.ipynb`

### Results

- [Power BI dashboard](https://github.com/akashmurugesan-datascientist/nhs-waiting-time-analysis/blob/main/nhs_waiting_time_dashboard.pbix): `nhs_waiting_time_dashboard.pbix`
- [Dashboard PDF](https://github.com/akashmurugesan-datascientist/nhs-waiting-time-analysis/blob/main/nhs_waiting_time_dashboard.pdf): `nhs_waiting_time_dashboard.pdf`

### Other components

- **Analyst**
