E-Commerce Customer Churn Analysis and Power BI Dashboard

Category: Data Science

Budget: 1150–1150 USDC

We are an established direct-to-consumer apparel brand looking for an experienced data analyst to analyze our customer purchase history and behavioral data over the past 24 months. The primary objective is to identify key drivers of customer churn, segment our user base using RFM analysis, and provide actionable retention strategies. Deliverables include a clean, documented Python/SQL data pipeline, an interactive Power BI dashboard tracking monthly active users, churn rates, and LTV cohorts, as well as a concise executive summary report (PDF/PPT) highlighting key findings. We will provide clean CSV exports from Shopify and Google Analytics 4. The ideal candidate has strong expertise in statistical modeling, cohort analysis, and executive data storytelling. We expect the project to be completed within 3 weeks, including one intermediate check-in milestone and a final handover presentation.

Skills required

Python
SQL
Power BI
Customer Segmentation
Cohort Analysis
Data Visualization

Milestones are funded into USDC escrow on Polygon before work begins.