shopping trends data analysis

Key Findings:

Average Shopper Age: 44 years

Average Spend: $59.76 per purchase

Customer Ratings: Avg. 3.75/5

Gender Distribution: Nearly equal between male & female shoppers

What Can We Learn?

How discounts & promo codes influence buying decisions

Spending habits across different age groups

Customer preferences for payment & shipping methods

How Can Businesses Use This Data?

Optimize targeted marketing strategies Identify seasonal bestsellers

Enhance customer experience based on ratings

Techniques Used:

SQL data extraction with pyodbc

Statistical analysis using pandas & numpy

Data visualization with Plotly Express & Matplotlip