An interactive data analysis project built using Microsoft Excel to evaluate annual retail sales performance and generate business insights through visualization and dashboard reporting.
This project analyzes 2022 retail sales data to understand customer purchasing behavior, regional performance, and product trends.
The goal was to convert raw transactional data into an interactive dashboard that supports business decision-making.
The dashboard allows stakeholders to monitor KPIs, filter data dynamically, and identify revenue growth opportunities.
- Track annual sales performance
- Identify profitable customer segments
- Analyze regional contribution to revenue
- Support marketing and sales strategy decisions
- Create an easy-to-use business dashboard
- Microsoft Excel
- Pivot Tables & Pivot Charts
- Slicers & Interactive Filters
- Data Cleaning & Transformation
- Exploratory Data Analysis (EDA)
- Business Intelligence Visualization
- Women aged 30–49 contributed the highest sales share.
- Major revenue originated from Maharashtra, Karnataka, and Uttar Pradesh.
- Online marketplaces significantly influenced total sales performance.
Based on analysis, targeted marketing campaigns and promotional offers were recommended to increase customer engagement and overall sales growth.
MANISH SHARMA