EXCEL-ANNUAL-REPORT-DASHBOARD_PROJECT_WITH DATA ANALYSIS

In this project i collected the data from Vishrut Store in a mall near to my house which includes the sales, customer Id, Date of order, etc. of the Annual Year 2022. Here I have done Data cleaning, Data Processing, Data Analysis. I also shared them the Insights of the overall sales needed to increase the sales of that store in the upcoming year.

EXCEL FILE LINK:

(Note- Download then open in Ms-Excel of pc for perfect view)

https://docs.google.com/spreadsheets/d/1AkUMsVJrxnECJBxeN-VrAtiu3odVYgws/edit?usp=drive_link&ouid=102796300218919920779&rtpof=true&sd=true

Database and Tools:

1. MS-EXCEL
2. PIVOT TABLES AND CHARTS
3. SLICERS, etc.

DASHBOARD:

INSIGHTS:

1. Women are more likely to buy compared to men (~65%).
2. Maharastra, Karnataka and UP are the top 3 states (~35%).
3. Adult age group that is 39-49 years is max contributing (~50%).
4. Amazon, Flipkart, Myntra channels are max contributing (~80%).

CONCLUSION TO IMPROVE VISHRUT STORE SALES:

--They should target women customers of age group (39-49 years) living in Maharastra, Karnataka and UP by showing ads, offers,copons on amazon, flipkart and myntra.