Case Study:

Customer E-commerce Analysis Dashboard

Introduction:

A leading e-commerce company has commissioned a study to analyze their customer data. They want to know the performance of their business in terms of sales and revenue. To present the findings of the study in a clear and understandable manner, we will create a dashboard that showcases key performance indicators.

Dashboard Requirements:

The customer e-commerce analysis dashboard will include the following metrics:

1. Month wise revenue: This metric will show the company's total revenue on a month-to-month basis. We will use a line graph to display the revenue over time.
2. Revenue per state: This metric will show the company's revenue generated by each state. We will use a map to display this metric.
3. Region wise revenue share: This metric will show the percentage of revenue generated by each region. We will use a pie chart to display this metric.
4. Gender wise sales analysis: This metric will show the company's sales performance based on gender. We will use a bar graph to display this metric.
5. Age wise sales analysis: This metric will show the company's sales performance based on age groups. We will use a histogram to display this metric.
6. Quantity Discount correlation: This metric will show the relationship between the quantity of items sold and the discount given. We will use a scatter plot to display this metric.

Conclusion:

The customer e-commerce analysis dashboard will provide valuable insights to the company about their sales and revenue performance. With this dashboard, the company can track their progress over time, identify areas of growth, and make data-driven decisions to improve their business.

See it also on Tableau Public (Click Me)