Churn Analysis
Budget: $30 – $250 CAD
1. Project Overview
We are seeking a qualified Tableau developer to design and implement an interactive dashboard to analyze key customer metrics, including average rate of return, churn rate, churn reasons, customer account age, customer distribution by ID and region, cancellation details, and data outliers. The dashboard should incorporate various data visualizations and allow users to filter insights dynamically.
2. Scope of Work
2.1 Data Integration & Processing
Connect and integrate customer data from multiple sources (CRM, databases, CSV files, etc.).
Ensure data accuracy, consistency, and completeness.
Handle data transformation, cleaning, and aggregation as necessary.
2.2 Dashboard Requirements
The Tableau dashboard must include the following key metrics and insights:
Average Rate of Return: Calculate and visualize the return rate across different customer segments.
Churn Rate: Display the percentage of customers who have left over a given period.
Churn Reason: Categorize and analyze the reasons for customer churn.
Customer Account Age: Track how long customers have been active before churning.
Customers by ID: Provide an overview of individual customer IDs and their attributes.
Customer Region: Segment customers by their geographic location.
Cancellation Information: Show details of canceled accounts, including timestamps and reasons.
Outliers: Identify anomalies and deviations in customer behavior.
2.3 Data Visualizations
The dashboard should include the following visual elements:
Bubble Graph – To analyze customer segmentation based on multiple attributes.
Heat Map – To highlight regional churn trends and customer density.
Histogram – To visualize customer account age distribution.
Pie Chart – To show the proportion of different churn reasons.
Cluster Analysis – To group similar customer profiles based on shared attributes.
2.4 Filters & Interactivity
The dashboard must support interactive filtering options, including:
Age Group
Churn Type
Region
Churn Reason
Users should be able to drill down into specific data points and explore trends dynamically.
2.5 Deliverables
Fully functional Tableau Dashboard with all required visualizations and filters.
Documentation outlining the data sources, dashboard structure, and user instructions.
Training Session for key stakeholders to ensure effective usage.
Source Files & Configuration for future modifications.
3. Proposal Requirements
Interested bidders must submit:
Company Profile or Resume (if individual) with relevant Tableau experience.
Portfolio or Work Samples showcasing similar dashboard projects.
Project Approach detailing the methodology for data integration and visualization.
Proposed Timeline for development, testing, and deployment.
Cost Estimate with a breakdown of pricing for development, support, and maintenance (if applicable).
We are seeking a qualified Tableau developer to design and implement an interactive dashboard to analyze key customer metrics, including average rate of return, churn rate, churn reasons, customer account age, customer distribution by ID and region, cancellation details, and data outliers. The dashboard should incorporate various data visualizations and allow users to filter insights dynamically.
2. Scope of Work
2.1 Data Integration & Processing
Connect and integrate customer data from multiple sources (CRM, databases, CSV files, etc.).
Ensure data accuracy, consistency, and completeness.
Handle data transformation, cleaning, and aggregation as necessary.
2.2 Dashboard Requirements
The Tableau dashboard must include the following key metrics and insights:
Average Rate of Return: Calculate and visualize the return rate across different customer segments.
Churn Rate: Display the percentage of customers who have left over a given period.
Churn Reason: Categorize and analyze the reasons for customer churn.
Customer Account Age: Track how long customers have been active before churning.
Customers by ID: Provide an overview of individual customer IDs and their attributes.
Customer Region: Segment customers by their geographic location.
Cancellation Information: Show details of canceled accounts, including timestamps and reasons.
Outliers: Identify anomalies and deviations in customer behavior.
2.3 Data Visualizations
The dashboard should include the following visual elements:
Bubble Graph – To analyze customer segmentation based on multiple attributes.
Heat Map – To highlight regional churn trends and customer density.
Histogram – To visualize customer account age distribution.
Pie Chart – To show the proportion of different churn reasons.
Cluster Analysis – To group similar customer profiles based on shared attributes.
2.4 Filters & Interactivity
The dashboard must support interactive filtering options, including:
Age Group
Churn Type
Region
Churn Reason
Users should be able to drill down into specific data points and explore trends dynamically.
2.5 Deliverables
Fully functional Tableau Dashboard with all required visualizations and filters.
Documentation outlining the data sources, dashboard structure, and user instructions.
Training Session for key stakeholders to ensure effective usage.
Source Files & Configuration for future modifications.
3. Proposal Requirements
Interested bidders must submit:
Company Profile or Resume (if individual) with relevant Tableau experience.
Portfolio or Work Samples showcasing similar dashboard projects.
Project Approach detailing the methodology for data integration and visualization.
Proposed Timeline for development, testing, and deployment.
Cost Estimate with a breakdown of pricing for development, support, and maintenance (if applicable).