Skip to content

Latest commit

 

History

History
28 lines (21 loc) · 1.31 KB

README.md

File metadata and controls

28 lines (21 loc) · 1.31 KB
Raw

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:

Screenshot (8)

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.