Objective: Vrinda Store analysis and Dashboard using Advanced Excel
Key Findings: ✔ Customer demographics: Women are more likely to be buyers compared to men (64%). The adult age group (30-49 years old) contributes the most to overall sales. ✔ Geographic trends: Maharashtra, Karnataka, and Uttar Pradesh are the top 3 states contributing to maximum sales. ✔E-commerce channels: Amazon, Flipkart, and Myntra capture the majority of e-commerce sales at 80%. ✔ Product categories: The top 3 selling categories are Sets (12391 units sold), Kurtas (10446 units sold), and Western Dresses (4066 units sold). ✔ December 2019 saw the highest profit, while March 2020 showed the strongest profit for that year.
Recommendations for Sales Growth: Target 30-39-year-old females in Maharashtra, Karnataka, and Uttar Pradesh with multi-platform ads (Amazon, Flipkart, Myntra, social media) promoting sales and showcasing popular products (Sets, Kurtas, Western Dresses).