E-commerce Customer Purchase Behavior Dashboard in Tableau -- 2
Budget: $30 – $250 USD
Budget: $50
Time Estimate: 3–4 hours
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 segments and optimize marketing strategies.
Key Requirements:
1- Data Import and Cleaning: Import the dataset into Tableau, ensuring data is cleaned and prepared for analysis (e.g., handle cancellations and filter out incomplete transactions).
2- Data Analysis and Visualization:
- Sales Trend: Build a line chart showing the monthly sales trend to track performance over time.
- Product Popularity: Create a bar chart showing the top 10 most frequently purchased products.
- Customer Purchase Patterns: Develop a scatter plot comparing the number of products purchased per transaction to the total spending, segmented by customer type (individual vs. small business).
- Profitability by Segment: Use a bar or pie chart to identify the most profitable customer segments, focusing on metrics like total revenue by country.
3- Interactive Dashboard: Design a user-friendly dashboard combining these visualizations, with filters for Country, Customer Type, and Product Category. Include an interactive feature to isolate specific time periods or product types.
Insights Summary:
Add a summary text box in the dashboard to highlight key findings, such as trends in high-volume purchases, top-performing products, and recommendations for targeting profitable customer segments.
Deliverables:
1- A link to a Tableau Public dashboard with:
- Cleaned and organized data.
- Interactive visualizations as specified, clearly labeled and easy to interpret.
2- A summary of key insights and recommended strategies for increasing profits (e.g., "Focus marketing efforts on Product X and countries with the highest profitability").
Dataset:
Use the E-commerce Business Transaction dataset from Kaggle, available here: https://www.kaggle.com/datasets/gabrielramos87/an-online-shop-business
Time Estimate: 3–4 hours
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 segments and optimize marketing strategies.
Key Requirements:
1- Data Import and Cleaning: Import the dataset into Tableau, ensuring data is cleaned and prepared for analysis (e.g., handle cancellations and filter out incomplete transactions).
2- Data Analysis and Visualization:
- Sales Trend: Build a line chart showing the monthly sales trend to track performance over time.
- Product Popularity: Create a bar chart showing the top 10 most frequently purchased products.
- Customer Purchase Patterns: Develop a scatter plot comparing the number of products purchased per transaction to the total spending, segmented by customer type (individual vs. small business).
- Profitability by Segment: Use a bar or pie chart to identify the most profitable customer segments, focusing on metrics like total revenue by country.
3- Interactive Dashboard: Design a user-friendly dashboard combining these visualizations, with filters for Country, Customer Type, and Product Category. Include an interactive feature to isolate specific time periods or product types.
Insights Summary:
Add a summary text box in the dashboard to highlight key findings, such as trends in high-volume purchases, top-performing products, and recommendations for targeting profitable customer segments.
Deliverables:
1- A link to a Tableau Public dashboard with:
- Cleaned and organized data.
- Interactive visualizations as specified, clearly labeled and easy to interpret.
2- A summary of key insights and recommended strategies for increasing profits (e.g., "Focus marketing efforts on Product X and countries with the highest profitability").
Dataset:
Use the E-commerce Business Transaction dataset from Kaggle, available here: https://www.kaggle.com/datasets/gabrielramos87/an-online-shop-business
Related categories:
Data Processing
SQL
Business Analysis
Market Research
Database Administration
QlikView