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 key drivers of customer churn and lifetime value. The project requires cleaning a dataset of approximately 50,000 transactions, performing cohort analysis, and identifying patterns in repeat purchasing behavior. The final deliverables include a comprehensive technical report summarizing findings, a predictive model for churn probability, and an interactive dashboard in Tableau or Power BI that our marketing team can use for weekly performance monitoring. We expect the project to be completed within three weeks, including a midpoint check-in to review preliminary insights. The ideal candidate will have strong SQL skills and experience in retail analytics. You must be able to translate complex data findings into actionable business recommendations for our stakeholders.

Skills required

• Python
• SQL
• Tableau
• Cohort Analysis
• Data Visualization

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