The dataset contains various attributes related to orders, customers, and products, providing a comprehensive view of the sales process.
This project focuses on analyzing e-commerce order data to identify patterns, trends, and insights related to customer purchases, sales performance, and profitability. The dataset contains various attributes related to orders, customers, and products, providing a comprehensive view of the sales process.
The primary objectives of this analysis are:
- Understanding customer purchasing patterns.
- Identifying top-performing products and categories.
- Analyzing sales trends across different regions and markets.
- Evaluating the impact of discounts on profitability.
- Extracting insights into customer segmentation and behavior.
- Tableau for data visualization and analysis
- Excel for initial data cleaning and exploration
- Sales Performance :
- Total Sales: 6.5M
- Latest Year Sales: 2.2M
- Sales Growth: +23.8% from the previous year.
- Total Profit: 1.07M
- Latest Year Profit: 279.9K
- Profit Growth: -12.2% from the previous year.
- Growth Trends :
- Sales Growth consistently surpasses the 20% annual target.
- Quantity sold grew steadily, indicating strong demand growth (+24.2% in 2023).
- Customer Segmentation :
- Corporate Segment contributes 58.93% of total sales.
- Consumer Segment contributes 32.94%, while Self-Employed accounts for 8.13%.
- Corporate Segment exceeds the 30% target, making it a key focus for growth.
- Product & Category Performance :
- Body care accounts for ~50% of total sales, making it the top category.
- Face care records the lowest sales (6.84%).
- Regional & Market Insights :
- Asia Pacific leads in sales, followed by Europe and USCA.
- Africa falls below the 400K target, requiring strategic focus.
- Profitability varies significantly across regions, requiring region-specific strategies.
- Best-Selling Products :
- Top-selling product is 'Herbal Essences Bio'.
- Other bestsellers include various jewelry and accessories like 'Sterling Wave Earrings' and 'Golden Blaze Necklace'.
