How pratikshadandriyal/hospital-readmission-patient-flow-analytics works
This repository is a hospital readmission analytics project, not a deployed clinical application. Its main workflow is to build a synthetic encounter dataset, analyze and feature-engineer it in Python and SQL, then present operational and readmission-risk findings in a two-page Power BI dashboard. Distinct capabilities include patient, doctor, and encounter data; cohort and readmission analysis; risk scoring; frequent-flyer cost analysis; and exploratory checks. The README documents the cross-tool workflow, but sampled source does not establish every file-level handoff, so uncertain connections are omitted.
Main entry points: generate_data.py Dataset Generator · encounters_features_powerbi.csv Dashboard Features · hospital-readmission-patient-flow-analytics.pbix Operations Dashboard · eda.py Exploratory Analysis
Components 10
Hospital Data
- Dataset Generator
python/generate_data.py - Patient Records
data/patients.csv - Doctor Records
data/doctors.csv - Encounter Records
data/encounters.csv - Dashboard Features
data/encounters_features_powerbi.csv
Analytics
- Exploratory Analysis
python/eda.py
SQL Analysis
- SQL Tables
sql/01_create_tables.sql - Business Queries
sql/02_business_questions.sql
Power BI
- Operations Dashboard
powerbi/hospital-readmission-patient-flow-analytics.pbix
Other components
- Hospital Analyst
Connections 7
- Dataset Generator → Patient Records: builds data
README.md - Dataset Generator → Doctor Records: builds data
python/generate_data.py - Dataset Generator → Encounter Records: builds data
README.md - Exploratory Analysis → Dashboard Features: exports features
python/eda.py - SQL Tables → Business Queries: defines tables
README.md - Hospital Analyst → Operations Dashboard: explores findings
README.md - Dashboard Features → Operations Dashboard: powers dashboard
README.md