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. You will be responsible for creating a comprehensive report that highlights segment-specific trends and providing actionable recommendations for our marketing team. The final deliverable must include a dynamic Power BI or Tableau dashboard that allows our stakeholders to filter data by region, product category, and acquisition channel. We expect this project to be completed within three weeks, including a mid-point check-in to review initial data cleaning and exploratory findings. Successful candidates will have experience with retail analytics and the ability to translate complex data into clear business insights.

Skills required

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

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