160
of the projects I have worked on. Projects: 1. Cohort analysis and user retention to assess engagement. Task: Assess user retention trends over 6 months in organic and paid traffic segments. My role: Cleaning and standardizing non-standard date formats; developing a cohort model in SQL with monthly offset calculations (month_offset); calculating retention KPIs and creating an interactive reporting dashboard. Tools: SQL (PostgreSQL),…
