E-commerce Analysis

The main goals of this dashboard to be tracking and analyzing sales performance, customer segments, profitability, and product category trends to support informed business decisions. The dashboard is built with modern data visualization techniques, which enable quick insights into critical business metrics.

Insights from the Dashboard

1. Overall Profit and Sales Performance:
   • The business generated $280K in total profit, which is down by 12.16%, and $2.193M in total sales, which grew by 23.82%. While sales are growing, profitability appears to be dropping, indicating rising costs or inefficiencies.
2. Top Products:
   • The top 5 products are clearly highlighted, with Herbal Essences Bio being the standout performer in terms of quantity sold. This can guide decisions around marketing efforts and future inventory stocking.
3. Customer Segments:
   • The Corporate segment accounts for the majority (58.43%) of total quantity sold, indicating that B2B relationships might be a significant revenue driver.
   • Other segments, like Consumers (33.1%) and Self-Employed (8.39%), show potential for targeted marketing to drive additional growth.
4. Category Performance:
   • Body care leads in terms of sales quantity across categories, making it a strategic category to prioritize.
   • Makeup and Hair care also show significant contributions, but Face care may need further exploration or promotion to boost performance.
5. Yearly and Monthly Trends:
   • A monthly trend graph reveals consistent growth in sales quantity, peaking towards the last months of the year (November). This could imply the holiday season has a major influence on sales.
6. Segment and Category Profit Analysis:
   • The table gives a granular view of sales and profit across segments and categories, with specific months and YoY sales percentages, providing a more nuanced understanding of how different areas of the business are performing. For example, Make-up within the Corporate segment is seeing the highest YoY growth (59.21%).