Sales-Report-Using-Excel

An Insight to a company's sales using Microsoft Excel

OBJECTIVE: A store wants to create an annual sales report for the year 2022, so that they can understand thier customers more and can make more sales in the year 2023.

Questions answered in this report:

1. Compare the sales and orders using a single chart.
2. Which month got the highest sales and orders?
3. Who does more shopping, men or women?
4. List the top 5 states contributing to the sales.
5. Relation between age and gender on number of orders
6. Which channel is contributing to maximum sales?
7. Highest selling category.

Insights shared with the company:

1. Women are more likely to buy as compared to men.
2. Maharashtra, Karnataka and Uttar Pradesh are the top 3 states.
3. Adult age group(30 to 49 yrs) are max contributing.
4. Amazon, Flipkart and Myntra are max contributing.

Verdict

ABC store should target women customers of age group(30-49 years) licing in Maharashtra, Karnataka and Uttar Pradesh by showing ads, offers, coupons available on Amazon, flipkart and Myntra.