- Title : VRINDA STORE ANALYSIS
- Created By : Shalinee Sahoo
The Vrinda Store wants to create an annual sales report for 2022. So that, the owner of the Vrinda store can understand their customers and grow more sales in the coming year.
- Taken the dataset from kaggle which contain data of vrind store.
- Clean the data by removing null, created new columns for analysis, corrected the spelling errors.
- Made sure data is consistent and clean with respect to data type, data format and values used.
- Created pivot tables according to the requirements.
- Merge all pivot tables into one dashboard and apply slicer to make the dashboard interactive and dynamic.
https://1drv.ms/x/s!AigX8h7oaiZteahyHqlEgnZX54s?e=ovuNQH
- Women exhibit a higher propensity for purchasing products compared to men, constituting approximately 65% of the customer base.
- The highest sales occur in the month of March.
- The states of Maharashtra, Karnataka, and Uttar Pradesh emerge as the top three regions in terms of product consumption.
- Within the adult age group of 30 to 49 years, approximately 50% of the total contributions are made, making it the most significant buyer demographic.
- 80% of the customer's maximum product orders are made through channels like Amazon, Flipkart, and Myntra.
In order to enhance the sales performance of Vrinda Store, a strategic approach involves directing marketing efforts towards women customers within the age range of 30 to 49 years, specifically those residing in the states of Maharashtra, Karnataka, and Uttar Pradesh. This can be achieved by showcasing tailored advertisements, exclusive offers, and enticing coupons through prominent e-commerce platforms such as Amazon, Flipkart, and Myntra. Implementing this targeted marketing strategy is likely to effectively capture the attention and interest of the identified demographic, thereby driving increased sales for Vrinda Store.