.png){kind=link}
Vrinda Store Analysis
This project is based on analysis by using Advance Excel.
Data Source: Kaggle
Requirements based on year 2022:
1- Compare sales and orders using Single chart?
2- Months got the highest sales and ordres?
3- Who purchase more Men or Women?
4- What are different order status?
5- List top 10 states for contributing in sales?
6- Relation between age and gender based on number?
7- Which Channel is contributing maximum sales?
8- Heighest selling categories?
Conclusions:
1- Women are more likely to buy compare to men.
2- Maharashtra, Uttar Pradesh & Karnataka are the top three states with 35% share.
3- Adult age group (30-49) is most contributing.(50%)
4- Amazon, Flipkart and Myntra channels are most contributing.(80%)
Final conclusion is that try to target age group of (30-49) and places like Maharashtra, Uttar Pradesh & Karnataka and give them gift broachers, Coupons & offers.