This repository contains data and Excel files related to the tutorial videos by Rishabh Mishra on YouTube, focusing on sales data analysis for Vrinda Store.
- Data Validation: Checked for missing values and anomalies; cleansed the dataset to ensure accuracy.
- Data Cleaning: Standardized data types, formats, and values for consistency.
- Pivot Tables: Created pivot tables tailored to answer specific business questions.
- Dashboard Creation: Integrated all pivot tables into a cohesive and interactive dashboard. Applied slicers to enable dynamic filtering and exploration.
- Dashboard Preview:
View the interactive dashboard image
- Women lead purchases: Approximately 65% of buyers are women, highlighting a strong preference in this segment.
- Top states for sales: Maharashtra, Karnataka, and Uttar Pradesh dominate in terms of product purchases.
- Prime age group: Customers aged 30-49 years contribute nearly 50% of total sales, indicating the most active buying group.
- Popular sales channels: Amazon, Flipkart, and Myntra are the top platforms driving product orders.
Deep dive into the project and Excel techniques by watching the video here:
Excel Data Analytics Project - Vrinda Store | Rishabh Mishra
- Cleaned Excel data files
- Pivot tables and dashboard Excel workbook
- Supporting documentation and process notes
If you want, you can also try analysing in Raw Data file.
If you'd like me to add contributing guidelines, licensing info, or FAQs, just let me know!