analytics case studies & insights

Predictive subscriber attrition modeling and interactive Power BI executive dashboard

End-to-end data analytics workflow on 70,000+ subscription records. Uncovered primary drivers of customer attrition using SQL and Python, built an ensemble classification model, and deployed an executive Power BI dashboard enabling targeted retention campaigns that lowered churn by 18%.

Customer Lifetime Value (LTV), RFM segmentation & basket affinity analysis across 500k+ transactions

Comprehensive retail transactional analytics using advanced PostgreSQL window functions and Tableau. Delivered granular cohort retention heatmaps, Recency-Frequency-Monetary (RFM) customer segmentation, and product affinity models to optimize promotional spend and inventory allocation.

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

Statistical modeling and health analytics study examining 30-day inpatient readmissions. Performed multivariate logistic regression, hypothesis testing, and risk stratification to identify clinically significant predictors of preventable readmissions, presented in an interactive Looker Studio dashboard.