Vrinda Store wants to create an annual sales report for the year 2022. Vrinda can understand it's customers and grow sales in 2023.
- Compare the sales and orders using a single chart.
- Which month had the highest sales and orders?
- Who purchased more Men or Women in 2022?
- What are the different order statuses in 2022?
- List the top 10 states with the highest sales and the bottom 10 states with the lowest sales.
- Which channel is contributing to maximum sales?
- Data Cleaning - Check whether any null values are present or not, and check for the formats as well.
- Data Processing - Create the required columns to achieve the target.
- Data Analysis - Analyse the data and create the charts out of it using pivot table.
- Interactive Dashboard - Create a dashboard using the charts created using pivot table.
- Insights - Share the insights with the clients and the stakeholders.
- Women are more likely to buy compared to men.
- Maharashtra, Karnataka, and Uttar Pradesh are the top 3 states with the highest contribution in sales.
- The adult age group (30–49 yrs.) is contributing to maximum growth.
- Amazon, Flipkart, and Myntra are the top 3 channels for maximum contribution.
