Consumer Shopping Behavior Analysis with Interactive Excel Dashboard

I conducted a comprehensive analysis of consumer shopping survey data (500 respondents across 18 countries). The project included:

Data Cleaning: Removed inconsistencies, standardized categories, and structured the dataset for analysis.

Statistical Insights: Identified key trends in online vs. offline shopping preferences, impulse buying, discount sensitivity, and satisfaction scores.

Interactive Dashboard: Built a dynamic Excel dashboard with filters (age group, country, income range, etc.) and visualizations (pivot charts, KPIs, trend lines) to explore consumer behavior.

Deliverables:

Cleaned dataset in Excel format.

Interactive Excel dashboard with filters and charts.

This package allows stakeholders to explore insights dynamically, compare demographics, and make data-driven decisions about consumer shopping trends.