Online Sales Analysis

Online Sales Dashboard

(This is the random Dataset from internet, basis on the dataset assume some questions and get some Insights)

OBJECTIVE: Let's create an annual sales report for 2022. So that, we can understand their customers and how to grow more sales in 2023.

Alongwith, we will work on some questions as well:

1. Which Month got the highest sales and orders?
2. who purchased more- Men or Women?
3. List Top 5 states contributing to the sales?
4. Which Channel is contributing to maximum sales?

Basic Steps which I have taken: Data cleaning Data processing Data analysis Interactive Dashboard Insights

So,come to insights which I got:

1. In March Month we have Highest sales and 2819 Orders.
2. Women purchased with 64%.
3. The 5 States which are giving more sales are Maharastra, Karnataka, Uttarpradesh, Telangana and Tamil Nadu.
4. Amazon Channel is contributing to maximum sales.
5. Young Age Group (Below 45) is contributing maximum.

Final Conclusion:

Target Women customers of age below 45 yrs, living in Maharastra, Karnataka, Uttarpradesh by giving them offers, coupons on Amazon, Flipkart, and Myntra.