The dashboard provides a comprehensive analysis of sales and inventory for a supermarket, with a focus on customer behavior and product performance:
1. Customer by Most Purchases:
Coralie Brent leads with the highest purchase score of 91%.
Mike Jeff ranks 10th with a purchase score of 50%.
2. Amount by Gender and Birth Year:
Women born in the 1940s are the highest spenders, while those born after the 1980s are the lowest spenders.
Interestingly, younger men spend more than older men, possibly indicating evolving shopping patterns.
3. Quantity, Total Amount, and Unit Price by Product Name and Category:
The scatter plot reveals that although more fruits are sold compared to vegetables, higher spending occurs on vegetables.
This trend may be attributed to the higher price point of vegetables.
4. Top 3 and Bottom 3 by Sale:
Top selling products: Asparagus, Carrot, and Rhubarb.
Least selling products: Cranberry, Peach, and Lemon.
Despite strawberries being more expensive than carrots, carrots remain a customer favorite.
Additional Insights:
The store has completed nearly 4,000 sales, with 952 items sold and around 267 discounts provided to customers.
コメント