cohort-analysis

An enterprise e-commerce database system with advanced analytical reporting (LTV, Recency Churn, Cohorts) and performance optimization built on PostgreSQL

SQL cohort retention analysis case study with PostgreSQL, Docker, validation checks, retention heatmap, and A/B test readout.

End-to-end e-commerce analytics on ~100K Olist orders, PostgreSQL star schema, analytical SQL (window functions, cohort retention, RFM), and a published Power BI dashboard.

An enterprise-grade PostgreSQL Data Warehouse implementing a Medallion Architecture to calculate SaaS MRR and Cohort Retention.

End-to-end SQL + Power BI analytics on a synthetic food-delivery platform: 3NF schema, ETL/cleaning, advanced SQL (window fns, recursive CTEs, cohort retention, RFM, KPIs), query tuning, and a Power BI star schema.

SQL & Power BI analysis of e-commerce marketplace revenue, customer cohorts, and retention to identify growth levers and churn risk.

Amazon Redshift SQL ETL pipeline for mobile game acquisition analytics with SCD2 attribution, incremental loads, DQ checks, and ROAS cohorts.

SQL portfolio project analyzing mobile gaming LTV, ROAS, funnel conversion, payback period, and budget allocation in PostgreSQL.