How m2ammar/indus-hospital-operations-intelligence-database works
This repository is a synthetic hospital-operations analytics project: Python scripts generate healthcare datasets, a MySQL schema and KPI queries support analysis, and exported CSVs feed a four-page Tableau dashboard. The main workflow runs core generation before the dependent emergency, OPD, and surgery generators, then loads the SQL database and uses CSV exports in Tableau. The README documents the SQL/export/dashboard stages; source excerpts show the generators’ dataset writes and inputs. Tableau workbook internals and SQL implementation were not sampled.
Main entry points: tableau Relationship model · raw Core datasets · generate_emergency.py Emergency generator · generate_opd.py OPD generator
Components 18
Synthetic Data
- Core generator
generate_core.py - Core datasets
data/raw - Emergency generator
generate_emergency.py - Emergency visits
data/raw - OPD generator
generate_opd.py - OPD datasets
data/raw - Surgery generator
generate_surgeries.py - Surgery datasets
data/raw
SQL Analytics
- Hospital schema
indus_hospital.sql - 23 KPI queries
indus_hospital.sql
Tableau Reporting
- Cleaned CSVs
data/tableau - Relationship model
data/tableau - Executive overview
- Patient demographics
- OPD and emergency
- Surgery and donations
Other components
- Project user
- Dashboard viewer
Connections 20
- Project user → Core generator: runs first
README.md - Core generator → Core datasets: writes datasets
generate_core.py - Project user → Emergency generator: runs next
README.md - Emergency generator → Core datasets: reads patients
generate_emergency.py - Emergency generator → Emergency visits: writes visits
generate_emergency.py - Project user → OPD generator: runs next
README.md - OPD generator → Core datasets: reads parent tables
generate_opd.py - OPD generator → OPD datasets: writes visits
generate_opd.py - Project user → Surgery generator: runs next
README.md - Surgery generator → Core datasets: reads admissions doctors
generate_surgeries.py - Surgery generator → Surgery datasets: writes surgeries
generate_surgeries.py - Project user → Hospital schema: loads schema
README.md - Hospital schema → 23 KPI queries: supports analysis
README.md - Hospital schema → Cleaned CSVs: exports cleaned data
README.md - Cleaned CSVs → Relationship model: imports CSVs
README.md - Relationship model → Executive overview: powers page
README.md - Relationship model → Patient demographics: powers page
README.md - Relationship model → OPD and emergency: powers page
README.md - Relationship model → Surgery and donations: powers page
README.md - Dashboard viewer → Executive overview: views dashboard
README.md