E-commerce Customer Retention Analysis and Dashboard Development

Category: Data Science

Budget: 1675–1675 USDC

We are seeking a data analyst to analyze our Shopify store's historical sales data to identify churn patterns and improve customer retention. The project involves cleaning six months of transaction data, performing cohort analysis, and calculating CLV (Customer Lifetime Value). You will be responsible for identifying high-value customer segments and providing actionable insights on discount sensitivity. The final deliverables include a comprehensive technical report in PDF format and an interactive executive dashboard built in Tableau or Power BI. We expect the initial data audit to be completed within 3 days, with the final dashboard and insights presentation delivered within 14 days. Success will be measured by the clarity of the visualization and the feasibility of the marketing recommendations provided. Candidates should have experience working with retail datasets and possess strong storytelling abilities to translate complex metrics for our non-technical marketing team.

Skills required

• SQL
• Python
• Tableau
• Cohort Analysis
• Data Cleaning

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