📊 Explore the Dashboard: View Dashboard
📄 Complete Analysis (PPT): Download PPT
This analysis evaluates the sales performance of Urban Grocers Pvt. Ltd. over two years in the Hyderabad market. Using a dataset of daily transactions, the study identifies key trends, measures the impact of promotions, and provides actionable insights to improve operations, profitability, and customer satisfaction.
The dataset contains 240,000 transaction-level records from 2023 and 2024.
| Feature | Description | Data Type |
|---|---|---|
Date |
Transaction date | Date |
Store_ID |
Supermarket identifier (A, B, C, D) | Categorical |
Transaction_ID |
Unique transaction identifier | Numeric |
Food_Category |
Product category (Bread, Milk, Fruits, Vegetables, Meat) | Categorical |
Units_Sold |
Number of units sold | Numeric |
Price_per_Unit |
Price per unit | Numeric |
Promotion |
Flag indicating promotion (0 = No, 1 = Yes) | Binary |
Holiday_Weekend |
Flag for holiday/weekend (0 = No, 1 = Yes) | Binary |
Weather |
Weather condition (Sunny, Rainy, Cloudy) | Categorical |
Mode_Purchase |
Payment method (Cash, UPI, Credit Card, Debit Card) | Categorical |
- Peak Sales Periods: Identify high-sales days, weeks, and months.
- Promotion Effectiveness: Evaluate how promotions impact sales.
- Holiday & Weekend Impact: Understand which categories see sales uplift.
- Volatile Stores: Determine stores with unpredictable demand.
- Demand Forecasting: Predict future sales trends for key categories.
- Investment Analysis: Assess the ₹20 crore investment against generated profit.