GitHub - Aaronjill/customer-retention-cohort-analysis: Complete Customer Retention Cohort Analysis using SQL (PostgreSQL), Power BI, Python & DAX

Aaronjill / customer-retention-cohort-analysis Public

Notifications You must be signed in to change notification settings
Fork 0
Star 1

Complete Customer Retention Cohort Analysis using SQL (PostgreSQL), Power BI, Python & DAX

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 4 Commits
SAMPLE SCREENSHOT		SAMPLE SCREENSHOT
Customer Retention Cohort Analysis - Power BI.pbix		Customer Retention Cohort Analysis - Power BI.pbix
README.txt		README.txt
SQL_Cohort_Query.sql		SQL_Cohort_Query.sql

Repository files navigation

-Customer Retention Cohort Analysis-

I- Tools Used:
- SQL (PostgreSQL)
- Power BI
- DAX
- Python (optional data prep)

II- Project Overview:
- Extracted cohort data from ecommerce transaction table using PostgreSQL
- Calculated cohort start dates and weekly offsets
- Built Cohort Retention Matrix in Power BI
- Created DAX measures to calculate:
  - Total Users
  - Cohort Size
  - Week 1 Retention %
  - Long Term Retention %

III- Date Range:
- 2010 - 2011 ecommerce data

IV- Files Included:
- `Customer-Retention-Cohort-Analysis.pbix` (Power BI dashboard)
- `SQL_Cohort_Query.sql` (Cohort calculation SQL query)
- Sample screenshots

V- Author:
- Aaron Jillundra
- [LinkedIn - https://www.linkedin.com/in/aaron-jillundra-a3ab3a224/ ]
- [GitHub - https://github.com/Aaronjill]