Problem Statment Vrinda store is selling their products online through diffrent channels like Amazon, Flipkart etc. They have a sales data of year 2022 & they want us to analyse this data to understand their customers to grow more sales in 2023.
Task List
• Data Cleaning : Go through the given dataset & check for the duplicates, null & inconsistent values.
• Data Processing : Add a calculated columns basis on the values from the existing columns.
• Exploratory Data Analysis : Understand the given data by using aggrigate functions & pivot tables.
• Data Visualisation : Crate a appropriate charts to understand the data easily.
• Dashboard : Make a dashboard by placing a different charts on a single page.
• Insights : Provide a relevant insights to the stakeholders.
Overall Analysis View Some Important Insights from the Dashboard
• Women are more likely to buy compared to men (65%)
• Maharashtra, Karnataka and Uttar Pradesh are the top 3 states (35%)
• Adult age group (31-50 yrs) is max contributing (50%)
• Amazon, Flipkart and Myntra channels are max contributing(80%)
Final Conclusion Vrinda Store should target women customers of age group (31-50 yrs) living in Maharashtra, Karnataka and Uttar Pradesh by showing ads/offers/coupons available on Amazon, Flipkart and Myntra.