E-commerce Customer Purchase Behavior Dashboard in Tableau -- 2
Budget: $30 – $250 USD
Create an interactive dashboard in Tableau to visualize customer purchase behavior and sales trends for an online UK-based gift and homewares shop. The dashboard should offer insights into monthly sales trends, popular products, and customer purchasing patterns, helping the business identify profitable products, customers, and optimize marketing strategies.
Key Requirements:
Data Import and Cleaning: Import and clean the provided dataset if needed (500K rows, 8 columns).
Address negative quantities related to cancelled transactions, and ensure data consistency and accuracy for analysis.
Data Analysis and Visualization:
Monthly Sales Trends: Line or bar chart displaying total sales revenue over time to identify seasonal trends or sales spikes.
Popular Products: Bar chart showing top-selling products by total sales and/or quantity.
Customer Purchase Patterns: Scatter plot comparing the number of products per transaction to total spending, highlighting purchase behavior patterns.
Profitability Analysis: Bar chart illustrating total revenue by country to highlight geographical profitability differences.
Interactive Dashboard: Include filters allowing users to drill down by product ID, customer number, and country.
Insights Summary: Add a summary text box in the dashboard to highlight key findings and recommendations for targeting profitable customer segments.
Deliverables:
A link to a Tableau Public dashboard containing:
Cleaned and organized dataset.
Interactive visualizations clearly labeled and easy to interpret.
A brief summary outlining key insights and actionable recommendations to optimize sales and marketing strategies.
Dataset:
Use the E-commerce Business Transaction dataset from Kaggle, available here.
https://www.kaggle.com/datasets/gabrielramos87/an-online-shop-business/data
Compensation: $50
First draft submission for the task is on Mar 27
Final task submission is on Mar 31st
Key Requirements:
Data Import and Cleaning: Import and clean the provided dataset if needed (500K rows, 8 columns).
Address negative quantities related to cancelled transactions, and ensure data consistency and accuracy for analysis.
Data Analysis and Visualization:
Monthly Sales Trends: Line or bar chart displaying total sales revenue over time to identify seasonal trends or sales spikes.
Popular Products: Bar chart showing top-selling products by total sales and/or quantity.
Customer Purchase Patterns: Scatter plot comparing the number of products per transaction to total spending, highlighting purchase behavior patterns.
Profitability Analysis: Bar chart illustrating total revenue by country to highlight geographical profitability differences.
Interactive Dashboard: Include filters allowing users to drill down by product ID, customer number, and country.
Insights Summary: Add a summary text box in the dashboard to highlight key findings and recommendations for targeting profitable customer segments.
Deliverables:
A link to a Tableau Public dashboard containing:
Cleaned and organized dataset.
Interactive visualizations clearly labeled and easy to interpret.
A brief summary outlining key insights and actionable recommendations to optimize sales and marketing strategies.
Dataset:
Use the E-commerce Business Transaction dataset from Kaggle, available here.
https://www.kaggle.com/datasets/gabrielramos87/an-online-shop-business/data
Compensation: $50
First draft submission for the task is on Mar 27
Final task submission is on Mar 31st