Download
Practice sales dataset for Excel and Power BI
A synthetic year of orders for a fictional Indian consumer brand — 1,800 rows across cities, channels and categories — with practice questions.
Download dataset (CSV)
Preview
Loading a preview of the first rows…
About the data
The dataset is synthetic: generated by us to look like a year of orders (April 2025 to March 2026, the Indian financial year) for "Nimbu & Co.", a fictional consumer brand selling across eight cities. It contains no real company's data, so you are free to use it in assignments and portfolios.
Columns
| Column | Description |
|---|---|
| order_id | Unique order identifier |
| order_date | Date of order (YYYY-MM-DD) |
| city | One of eight cities |
| region | North, South, East or West |
| channel | Online store, Marketplace or Retail partner |
| category | Beverages, Snacks or Personal care |
| product | Product name |
| units | Units in the order |
| unit_price | List price per unit (₹) |
| discount_pct | Discount applied, as a percentage |
| revenue | units × unit_price × (1 − discount_pct ÷ 100), in ₹ |
| cost | Cost of goods for the order, in ₹ |
Practice questions
Start simple and work down the list.
- What was total revenue for the year? Which month was highest?
- Rank the eight cities by revenue. Does the ranking change if you look at gross profit (revenue − cost) instead?
- Which channel gives the highest average discount? Does it also have the lowest margin?
- Which product has the lowest gross margin percentage?
- Build a pivot of revenue by region and category. Which combination is growing fastest from the first half of the year to the second?
- If discounts on Marketplace orders were capped at 10%, how much would gross profit have changed, assuming the same units sold?
- Build a one-page dashboard answering: where should the brand focus next year?
Question 6 is deliberately simplified — in reality, cutting discounts would likely change how many units sell. Saying so is part of a good answer.