How thrinesh13/surgical-scheduling-variance-analysis works
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: OR_Scheduling_Reliability.Report Power BI report · 01_bronze_ingest.ipynb Bronze ingest · 02_silver_patient_information.ipynb Silver patient data · 03_gold.ipynb Gold analysis cohort
Components 14
Analysis pipeline
- Bronze ingest
notebooks/01_bronze_ingest.ipynb - Silver patient data
notebooks/02_silver_patient_information.ipynb - Gold analysis cohort
notebooks/03_gold.ipynb
Power BI reporting
- Semantic model
powerbi/OR_Scheduling_Reliability.SemanticModel - Power BI report
powerbi/OR_Scheduling_Reliability.Report
Static dashboard
- Public dashboard
dashboard/index.html - OR dashboard HTML
dashboard-data/OR-dashboard.html - Benchmark review CSV
dashboard-data/Which procedures deserve a closer look.csv - Case misses CSV
dashboard-data/How often do case times miss the benchmark.csv - Scheduling review CSV
dashboard-data/Where should scheduling review begin.csv
Other components
- MOVER dataset
- OR leadership
- Scheduling committees
- Finance planners
Connections 10
- 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