Grocery Stores are a vital part of everyday life, providing us with the food and essentials as we need. Many people utilizes grocery delivery applications to order their products making it easy to shop from home.
Each transaction made through these applications is recorded in detail creating a valuable dataset. This project looks at data from these transactions to understand how well these stores are performing.
Dataset
The dataset is sourced from Kaggle which simulates grocery sales activities within Tamil Nadu state of India.
The dataset includes various columns that provide detailed information about each transaction at the Supermarket.
Link to the Dataset : Supermarket Sales Dataset
Problem Statement
• To gain insights into Supermarket Sales Performance understanding the patterns and trends in customer behavior, product categories and regional sales.
• This Exploratory Data Analysis (EDA) aims to address the following key questions :
âž© Customer Behavior Analysis : What are the purchasing patterns of customers based on different categories and sub-categories? How does customer spending vary across cities and states?
âž© Sales Trends : Are there observable trends in sales over time? How do sales figures fluctuate across different months or seasons?
âž© Discount Impact : What is the relationship between discounts and sales? How do discounts influence the profit margins across different categories and regions?
âž© Profit Analysis : What are the profit margins associated with various product categories and sub-categories? How do these margins vary by city and state?
âž© Regional Performance : How do sales and profit performance differ across different regions and states? Are there specific regions that contribute more significantly to overall sales and profits?
âž© Category Insights : What are the most and least popular product categories and sub-categories? How does the popularity of these categories vary by location and over time?
• This analysis will provide a deeper understanding of supermarket sales dynamics revealing trends and patterns that can inform inventory management, promotional strategies and regional marketing efforts.
Link to the Notebook : Supermarket Sales Analysis