This project is a complete data analysis case study on a fictional retail business named Vrinda Store. It was built using Microsoft Excel to demonstrate skills in data cleaning, data processing, pivot analysis, and dashboard creation.
This Excel-based data analysis project focuses on customer and sales data from Vrinda Store. It includes cleaning raw data, processing it into meaningful structures, analyzing it through pivot charts, and presenting insights in an interactive dashboard.
To analyze Vrinda Store's data and generate valuable business insights by creating a clean, structured, and interactive Excel dashboard.
- Microsoft Excel
- Data Cleaning (Remove nulls, format)
- Data Processing (Date & Age Group)
- Pivot Tables & Charts
- Interactive Dashboard (Slicers, Charts, KPIs)
- Removed null values
- Formatted date columns
- Arranged and structured the dataset properly
- Created a Month column from the purchase date
- Added Age Group categorization using formulas
- Created PivotTables for:
- Sales by Month
- Sales by Age Group
- Product performance
- Customer segmentation
- Built an interactive dashboard using:
- PivotCharts
- Slicers
- Conditional formatting
- KPIs and insights summary
- Identify top-selling products
- Recognize sales trends over months
- Understand customer age demographics
- Compare performance across product categories
- Dashboard View:
- Women are more likely to buy compared to men (~65%)
- Maharashtra, Karnataka and Uttar Pradesh are the top 3 states (~35%)
- Adult age group (30-49 yrs) is max contributing (~50%)
- Amazon, Flipkart and Myntra channels are max contributing (~80)
This project demonstrates the power of Excel in handling end-to-end data analysis—from cleaning to delivering business insights. It's perfect for those learning Excel or looking to build their portfolio with real-world scenarios.
Created by Ritesh Bhanat
📧 Email: riteshbhanat1807@gmail.com
🔗 LinkedIn: www.linkedin.com/in/ritesh-bhanat-67725325b