Data Analyst for Customer Retention Analysis

Project Overview:
We are seeking a freelance Data Analyst / BI Specialist to perform a detailed customer retention analysis and create an interactive dashboard to track customer behavior, retention, and business performance.

What We’ll Provide:

Complete dataset covering:

Customer data (new, existing, churned)

ATV (Average Transaction Value)

Customer traffic/visits

Company-level performance

Service-level performance

Employee-level performance

Data will be shared in structured files (Excel/CSV) or database exports.

Your Responsibilities:

Data Cleaning & Preparation

Organize and validate all datasets.

Unify multiple data sources into one structured model.

Retention Analysis

Define and apply retention metrics (e.g., 30/60/90 days, gender-based lookbacks).

Analyze retention by:

Month

Center/Branch

Gender

Service type

Employee/therapist

Provide insights into customer churn and loyalty trends.

Dashboard Development

Build an interactive dashboard (preferably in Power BI or Tableau).

Key features:

Retention rates & trends

ATV trends

Customer traffic analysis

Service & employee contribution

Filters for time, center, gender, service type

Ensure dashboard is user-friendly and refreshable with new data.

Deliverables:

Cleaned and structured dataset

Retention analysis summary report (insights & recommendations)

Interactive dashboard

Skills Required:

Strong background in data analysis & visualization

Expertise with Power BI / Tableau / similar BI tools

Proficiency in Excel, SQL, or Python for data cleaning

Experience in customer analytics & retention modeling

Project Timeline:

Analysis: 1–2 weeks

Dashboard delivery: 1 week after analysis approval