# thrinesh13/surgical-scheduling-variance-analysis architecture

> Architecture diagram of the GitHub repository thrinesh13/surgical-scheduling-variance-analysis, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-26). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/thrinesh13/surgical-scheduling-variance-analysis
- Repository: https://github.com/thrinesh13/surgical-scheduling-variance-analysis

## Overview

This is an operating-room scheduling analytics product: it benchmarks case durations against procedure medians, quantifies early and late variation and annual cost exposure, and identifies procedures for review. The documented analysis stages run from MOVER ingestion through cleaned Silver data to a Gold cohort, then into Power BI reporting. The tree also contains a separate static dashboard and question-oriented CSV/HTML artifacts; their wiring to the notebooks is not established by the available excerpts.

Main entry points: [`powerbi/OR_Scheduling_Reliability.Report`](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/tree/main/powerbi/OR_Scheduling_Reliability.Report) (Power BI report), [`notebooks/01_bronze_ingest.ipynb`](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/notebooks/01_bronze_ingest.ipynb) (Bronze ingest), [`notebooks/02_silver_patient_information.ipynb`](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/notebooks/02_silver_patient_information.ipynb) (Silver patient data), [`notebooks/03_gold.ipynb`](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/notebooks/03_gold.ipynb) (Gold analysis cohort)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_analysis["Analysis pipeline"]
  node_bronze["Bronze ingest"]
  node_silver["Silver patient data"]
  node_gold["Gold analysis cohort<br/>[03_gold.ipynb]"]
end

subgraph group_powerbi["Power BI reporting"]
  node_model["Semantic model"]
  node_report["Power BI report"]
end

subgraph group_static["Static dashboard"]
  node_dashboard["Public dashboard<br/>[index.html]"]
  node_orhtml["OR dashboard HTML<br/>[OR-dashboard.html]"]
  node_benchmarkcsv["Benchmark review CSV"]
  node_misscsv["Case misses CSV"]
  node_schedulingcsv["Scheduling review CSV"]
end

node_uci[("MOVER dataset")]
node_leaders(("OR leadership"))
node_committees(("Scheduling committees"))
node_finance(("Finance planners"))

node_uci -->|"ingested by"| node_bronze
node_bronze -->|"cleans into"| node_silver
node_silver -->|"forms cohort"| node_gold
node_gold -->|"models"| node_model
node_model -->|"powers"| node_report
node_leaders -->|"reviews"| node_report
node_committees -->|"reviews"| node_report
node_finance -->|"uses exposure"| node_report
node_leaders -->|"views"| node_dashboard
node_committees -->|"views"| node_dashboard

click node_bronze "https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/notebooks/01_bronze_ingest.ipynb"
click node_silver "https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/notebooks/02_silver_patient_information.ipynb"
click node_gold "https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/notebooks/03_gold.ipynb"
click node_model "https://github.com/thrinesh13/surgical-scheduling-variance-analysis/tree/main/powerbi/OR_Scheduling_Reliability.SemanticModel"
click node_report "https://github.com/thrinesh13/surgical-scheduling-variance-analysis/tree/main/powerbi/OR_Scheduling_Reliability.Report"
click node_dashboard "https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/dashboard/index.html"
click node_orhtml "https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/dashboard-data/OR-dashboard.html"
click node_benchmarkcsv "https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/dashboard-data/Which%20procedures%20deserve%20a%20closer%20look.csv"
click node_misscsv "https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/dashboard-data/How%20often%20do%20case%20times%20miss%20the%20benchmark.csv"
click node_schedulingcsv "https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/dashboard-data/Where%20should%20scheduling%20review%20begin.csv"

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_bronze,node_silver,node_gold toneBlue
class node_model,node_report,node_uci toneAmber
class node_dashboard,node_orhtml,node_benchmarkcsv,node_misscsv,node_schedulingcsv toneMint
class node_leaders,node_committees,node_finance toneIndigo
```

## Components

### Analysis pipeline

- [Bronze ingest](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/notebooks/01_bronze_ingest.ipynb): `notebooks/01_bronze_ingest.ipynb`
- [Silver patient data](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/notebooks/02_silver_patient_information.ipynb): `notebooks/02_silver_patient_information.ipynb`
- [Gold analysis cohort](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/notebooks/03_gold.ipynb): `notebooks/03_gold.ipynb`

### Power BI reporting

- [Semantic model](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/tree/main/powerbi/OR_Scheduling_Reliability.SemanticModel): `powerbi/OR_Scheduling_Reliability.SemanticModel`
- [Power BI report](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/tree/main/powerbi/OR_Scheduling_Reliability.Report): `powerbi/OR_Scheduling_Reliability.Report`

### Static dashboard

- [Public dashboard](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/dashboard/index.html): `dashboard/index.html`
- [OR dashboard HTML](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/dashboard-data/OR-dashboard.html): `dashboard-data/OR-dashboard.html`
- [Benchmark review CSV](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/dashboard-data/Which%20procedures%20deserve%20a%20closer%20look.csv): `dashboard-data/Which procedures deserve a closer look.csv`
- [Case misses CSV](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/dashboard-data/How%20often%20do%20case%20times%20miss%20the%20benchmark.csv): `dashboard-data/How often do case times miss the benchmark.csv`
- [Scheduling review CSV](https://github.com/thrinesh13/surgical-scheduling-variance-analysis/blob/main/dashboard-data/Where%20should%20scheduling%20review%20begin.csv): `dashboard-data/Where should scheduling review begin.csv`

### Other components

- **MOVER dataset**
- **OR leadership**
- **Scheduling committees**
- **Finance planners**

## Connections

- MOVER dataset → Bronze ingest: ingested by
- Bronze ingest → Silver patient data: cleans into
- Silver patient data → Gold analysis cohort: forms cohort
- Gold analysis cohort → Semantic model: models
- Semantic model → Power BI report: powers
- OR leadership → Power BI report: reviews
- Scheduling committees → Power BI report: reviews
- Finance planners → Power BI report: uses exposure
- OR leadership → Public dashboard: views
- Scheduling committees → Public dashboard: views