Sales
14,956,982across all recorded ordersRetail analytics · Tamil Nadu, India
Grocery sales,
made visible.
A first look at four years of order-level sales: where revenue comes from, which categories return the most profit, and what the discount patterns can—and cannot—tell us.
9,994 orders7 product categories5 recorded regions
Executive conclusion
Sales climbed; profitability stayed broadly consistent.
Across 9,994 recorded orders, the dataset reports 14,956,982 in sales and 3,747,121.20 in profit, for a 25.1% overall margin. Annual sales increased 67.3% from 2015 to 2018. Eggs, Meat & Fish led sales, while Snacks generated the most profit. Discount bands show similar average margins, but this comparison alone cannot establish a discount effect.
Profit
3.75Mreported profit unitsProfit margin
25.1%profit ÷ salesAverage discount
22.7%mean discount per order01 / Dataset
Source & sample
Source attribution and a small, unmodified sample are shown before the cleaning notes and analysis.
Primary data source
- Dataset
- Supermart Grocery Sales – Retail Analytics Dataset
- Platform / publisher
- Kaggle · Mohamed Harris
- Source file
- Supermart Grocery Sales - Retail Analytics Dataset.csv
- Records and fields
- 9,994 order rows · 11 columns
- Coverage
- January 2, 2015 – December 30, 2018 · Tamil Nadu, India
- Currency
- Not specified in the source; values are shown without a currency symbol
- Dataset page
- Open the Kaggle dataset page ↗
10 sample records from the downloaded source CSVSource order preserved · dates and numeric fields shown as stored
| # | Order ID | Customer | Category | Subcategory | City | Order date (raw) | Region | Sales | Discount (raw) | Profit | State |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | OD1 | Harish | Oil & Masala | Masalas | Vellore | 11-08-2017 | North | 1,254 | 0.12 | 401.28 | Tamil Nadu |
| 2 | OD2 | Sudha | Beverages | Health Drinks | Krishnagiri | 11-08-2017 | South | 749 | 0.18 | 149.80 | Tamil Nadu |
| 3 | OD3 | Hussain | Food Grains | Atta & Flour | Perambalur | 06-12-2017 | West | 2,360 | 0.21 | 165.20 | Tamil Nadu |
| 4 | OD4 | Jackson | Fruits & Veggies | Fresh Vegetables | Dharmapuri | 10-11-2016 | South | 896 | 0.25 | 89.60 | Tamil Nadu |
| 5 | OD5 | Ridhesh | Food Grains | Organic Staples | Ooty | 10-11-2016 | South | 2,355 | 0.26 | 918.45 | Tamil Nadu |
| 6 | OD6 | Adavan | Food Grains | Organic Staples | Dharmapuri | 06-09-2015 | West | 2,305 | 0.26 | 322.70 | Tamil Nadu |
| 7 | OD7 | Jonas | Fruits & Veggies | Fresh Vegetables | Trichy | 06-09-2015 | West | 826 | 0.33 | 346.92 | Tamil Nadu |
| 8 | OD8 | Hafiz | Fruits & Veggies | Fresh Fruits | Ramanadhapuram | 06-09-2015 | West | 1,847 | 0.32 | 147.76 | Tamil Nadu |
| 9 | OD9 | Hafiz | Bakery | Biscuits | Tirunelveli | 06-09-2015 | West | 791 | 0.23 | 181.93 | Tamil Nadu |
| 10 | OD10 | Krithika | Bakery | Cakes | Chennai | 06-09-2015 | West | 1,795 | 0.27 | 484.65 | Tamil Nadu |
02 / Data preparation
How the data was cleaned
The raw CSV is retained. Cleaning prepares dates and analysis fields while preserving the original order-level records.
Load and inspect
Read the 11 source columns, checked data types, null counts, duplicate rows, unique order IDs, and numeric ranges. Found 0 missing cells, 0 duplicate rows, and 9,994 unique IDs.
Standardize dates
The source mixes hyphen and slash formats. Hyphenated dates were parsed as day-month-year; slash dates were parsed as month/day/year. All 0 dates parsed successfully (2015-01-02 to 2018-12-30).
Create analysis fields
Derived year, month, and profit margin (profit ÷ sales) for grouping and comparison. Kept sales, profit, discounts, and categories unchanged; no rows were dropped or imputed.
03 / Analysis
Sales and profit patterns
Explore the time trend, category mix, and regional concentration, then compare the detailed totals below.
Monthly sales 2015—2018
Monthly totals show the overall trajectory; annual comparisons are less sensitive to month-to-month variation.
Sales by category total sales
Eggs, Meat & Fish is the largest category by sales, narrowly ahead of Snacks.
Profit by category total profit
Snacks contributes the most total profit, even though it is second in sales.
Sales by region total sales
West is the largest represented region. North appears once in the data.
Analysis takeaways
Signals in the records
These are descriptive patterns in the available records, not forecasts or causal estimates.
01 — MOMENTUM
Sales grew 67.3%
Annual sales rose from 2.98M in 2015 to 4.98M in 2018. The data shows a strong upward trend across the period.
02 — CATEGORY MIX
Sales leader ≠ profit leader
Eggs, Meat & Fish led sales at 2.27M; Snacks led profit at 568.2K. Revenue rank alone misses differences in profitability.
03 — DISCOUNTS
Margins look steady
Average profit margin ranges from 24.8% to 25.6% across discount bands. This simple comparison does not establish a discount effect.
03 / Detail
Category & region scorecard
Totals are shown alongside order-weighted margin and order counts for context.
Product categories
Sorted by recorded sales
| Category | Sales | Profit | Mean margin |
|---|---|---|---|
| Eggs, Meat & Fish | 2,267,401 | 567,357.22 | 24.9% |
| Snacks | 2,237,546 | 568,178.85 | 25.3% |
| Food Grains | 2,115,272 | 529,162.64 | 25.0% |
| Bakery | 2,112,281 | 528,521.06 | 25.1% |
| Fruits & Veggies | 2,100,727 | 530,400.38 | 25.2% |
| Beverages | 2,085,313 | 525,605.76 | 25.1% |
| Oil & Masala | 2,038,442 | 497,895.29 | 24.4% |
Regions
Order volume varies sharply
| Region | Orders | Sales | Profit |
|---|---|---|---|
| West | 3,203 | 4,798,743 | 1,192,004.61 |
| East | 2,848 | 4,248,368 | 1,074,345.58 |
| Central | 2,323 | 3,468,156 | 856,806.84 |
| South | 1,619 | 2,440,461 | 623,562.89 |
| North | 1 | 1,254 | 401.28 |