back to all case studiescase study // healthcare analytics
Healthcare Analytics•2023

Clinical Readmission & Risk Stratification

Statistical analysis and risk factor modeling on 100k+ hospital encounter records

roleHealthcare Data Analyst
duration3 Months
year2023
primary stackPython (Statsmodels, SciPy, Pandas)
Clinical Readmission & Risk Stratification
[01]

the problem

Hospitals face substantial financial penalties when 30-day patient readmission rates exceed benchmark thresholds. Clinical staff needed empirical evidence to determine which demographic variables, inpatient lab procedures, and medication adjustments directly correlated with unplanned return visits.

[02]

approach & architecture

Analyzed an anonymized clinical dataset comprising 100,000+ hospital admissions. Conducted rigorous statistical hypothesis tests (two-sample t-tests, Mann-Whitney U, and Chi-square contingency tables) to isolate significant factors. Built multivariate logistic regression models in Statsmodels with odds ratios (OR) and 95% confidence intervals, compiling outcomes into an intuitive clinical decision dashboard.

system highlights

Processed high-dimensional clinical data with 50+ features, handling extreme class imbalances via stratified sampling and cost-sensitive weighting.
Conducted multicollinearity diagnostics (Variance Inflation Factor < 2.5) to ensure statistical validity across comorbid diagnoses.
Calculated Adjusted Odds Ratios: identified that changes in diabetic medication dosage during admission reduced readmission likelihood by 15% (p < 0.001).
Built HIPAA-conscious aggregate BI dashboards in Looker Studio with dynamic filtering by admission type, diagnosis category, and age bracket.
[03]

key features

01

Adjusted Odds Ratio Forest Plot

Clear statistical visualization depicting the relative impact and 95% confidence intervals for each clinical indicator.

02

Length-of-Stay vs Readmission Analysis

Discovered nonlinear correlations between initial inpatient stay duration and subsequent 30-day revisit frequency.

03

Demographic & Comorbidity Risk Heatmap

Highlights patient subgroups requiring post-discharge telemedicine checkups and medication reconciliation.

04

Automated Executive KPI Scorecard

Monitors readmission rates against state and national benchmarks with automated outlier detection.

[04]

technologies

Python (Statsmodels, SciPy, Pandas)Looker StudioSQL (BigQuery)Multivariate Logistic RegressionHypothesis Testing (Chi-Square, T-Tests)Data Governance & Anonymization
[05]

outcomes & metrics

Bridged medical records and statistical modeling to provide clinical administrators with clear, data-backed insights that enhance patient care continuity while mitigating regulatory penalties.

✓ outcome

Identified top 4 statistically significant drivers of unplanned readmission (p < 0.01)

✓ outcome

Projected potential $350K penalty reduction through targeted discharge protocols

✓ outcome

Streamlined patient risk stratification from days of manual chart review to real-time queries