dataanalytics

analytics case studies & insights

Production data pipelines, predictive attrition models, cohort retention analyses, and interactive executive dashboards.

3 featured studies
[01]Predictive Analytics
Customer Churn & Retention Intelligence

Customer Churn & Retention Intelligence

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%.

Python (Pandas, NumPy, Scikit-learn)PostgreSQLPower BI & DAXSeaborn & Matplotlib
[02]Business Intelligence
E-Commerce Cohort & Revenue Analytics

E-Commerce Cohort & Revenue Analytics

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.

PostgreSQL (Window Functions, CTEs)Tableau Desktop & ServerPython (Pandas, Plotly)RFM Customer Segmentation
[03]Healthcare Analytics
Clinical Readmission & Risk Stratification

Clinical Readmission & Risk Stratification

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.

Python (Statsmodels, SciPy, Pandas)Looker StudioSQL (BigQuery)Multivariate Logistic Regression