تحليل يانات لسوبر ماركت

1. Products Analysis

Insights:

*Total Quantity by Category: Technology for 60.48% of total quantity, indicating it is the most demanded category, while Furniture (18.32%) has the lowest demand.

*Total Profit by Sub-Category: Categories like "Binders" and "Paper" generate more profits, whereas sub-categories like "Tables" and "Bookcases" show lower profitability.

*Total Sales by Category: Each category contributes equally to sales (33.33%), suggesting a balanced distribution of revenue.

-Weak Area:

Furniture's quantity is significantly lower (7k), even though its sales are equal to the other categories, indicating inefficiency in volume sales.

Sub-categories like "Tables" and "Bookcases" require strategies to improve profitability.

2-Customers Analysis

Insights:

-Sales by Segment: The "Consumer" segment contributes the most to sales (1.16M), while the "Home Office" segment contributes the least (0.43M).

-Sub-category by Segment: "Binders" and "Paper" dominate in terms of sub-category sales across all segments. Sub-categories like "Copiers" and "Machines" have significantly lower sales.

-Weak Area:

-The "Home Office" segment is underperforming compared to other segments. Marketing and sales strategies need to be revisited for this segment.

-Sub-categories like "Copiers" and "Machines" have minimal sales; reasons should be identified (e.g., pricing, availability, or demand)

3-Location Analysis

Insights:

-Sum of Quantity by Region: The "South" region accounts for 29.04% of quantities sold, the highest among regions. The "West" region (16.38%) has the lowest quantity share.

-Sum of Sales by Region: Sales are highest in the "Central" region (31.58%) and lowest in the "West" region (17.0%).

-Sum of Sales by Ship Mode: Standard Class shipping is the most popular and effective, whereas "Same Day" contributes the least to sales.

*Weak Area:

The "West" region has both the lowest sales and quantities sold. Marketing efforts should focus here.

"Same Day" shipping has low sales and might need cost optimization or targeted promotions.

4-Recommendations

Furniture Improvement:

Introduce promotional campaigns or bundle offers to increase sales volume.

Optimize pricing strategies for low-profit sub-categories like "Tables" and "Bookcases."

Regional Focus:

Allocate resources to boost sales in the "West" region with targeted advertising.

Evaluate supply chain effectiveness and product availability in underperforming regions.

Shipping Optimization:

Assess the feasibility of reducing "Same Day" shipping costs.

Encourage customers to opt for faster delivery through incentives