E-commerce Customer Retention Analysis and Dashboard Development

Category: Data Science

Budget: 1525–1525 USDC

We are seeking a data analyst to analyze our Shopify store's historical sales data to improve customer retention. The project involves cleaning three years of transactional data and identifying key churn indicators using cohort analysis. The primary deliverable is an automated interactive dashboard in Tableau or Power BI that visualizes monthly recurring revenue (MRR), Customer Lifetime Value (CLV), and repeat purchase rates. You will also be expected to provide a summary report outlining three actionable strategies to reduce churn based on your findings. The timeline for this project is three weeks, with a preliminary data audit due at the end of week one. Success will be measured by the clarity of the visualizations and the statistical significance of the churn drivers identified. Proficiency in SQL and advanced data visualization is essential.

Skills required

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

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