Analysis of Customer Ratings Across Supermarket Locations
Distribution of customer ratings by location
We analyzed the distribution of customer ratings for different supermarket locations. Here's a summary of the findings:
Yangon: The ratings are moderately high with some outliers on the lower end.
Naypyitaw: This location has a slightly higher median rating compared to others, with a tight distribution indicating consistent customer satisfaction.
Mandalay: Similar to Yangon, the ratings here are also moderately high with some lower outliers.
The box plot visualization provides a clear comparison of customer satisfaction across these locations.
Total sales by product category, by gender and by location
Summary of Total Sales by Product Category, Gender, and Location
Electronic Accessories: Highest sales in Yangon for both genders.
Fashion Accessories: Highest sales in Naypyitaw for females and in Yangon for males.
Food and Beverages: Highest sales in Naypyitaw for both genders.
Health and Beauty: Highest sales in Naypyitaw for females and in Mandalay for males.
Home and Lifestyle: Highest sales in Yangon for both genders.
Sports and Travel: Highest sales in Yangon for males and in Naypyitaw for females.
This breakdown provides insights into which categories are most popular in different cities and among different genders, helping to tailor marketing strategies accordingly.
Visualize this for me
We have successfully visualized the total sales by product category, gender, and location using a grouped bar chart. This visualization helps in understanding how sales performance varies across different categories, genders, and cities.