I have analyzed the dataset using MS Excel delves into creating an interactive dashboard for Vrinda Store, aiming to generate a detailed sales report for 2022. The objective is to empower informed decision-making, foster business expansion, and gain profound customer insights for 2023. Excel project delves into creating an interactive dashboard for Vrinda Store, aiming to generate a detailed sales report for 2022. The objective is to empower informed decision-making, foster business expansion, and gain profound customer insights for 2023.
📊 Project Objective: The Vrinda store aims to generate a comprehensive sales report for the year 2022 with the goals of making informed decisions, expanding their business, and gaining deeper insights into their customers in 2023.
📊Implementation: • Data Cleaning • Data Processing • Data Analysis • Dashboard Creation
📊Data Interpretation: • Amazon, Myntra, and Flipkart channels are contributing to Max (~90%). • 92% of orders have Delivered Status. • March month has the highest count of orders. • The Adult age group (30 to 49) has contributed to Max (~50%). • Women are more likely to purchase compared to Men (~64%). • Maharashtra, Karnataka, and Uttar Pradesh are the Top 3 states are contributed Maximum sales
📊Key areas for enhancing sales in 2023: • Launch different sales/ads/coupons in the month of March. • Increase stock levels on Amazon, Flipkart, and Myntra. • Target the women customers of the adult age group living in Maharashtra, Karnataka, and Uttar Pradesh states