Skip to content

About

Data analytics project showcasing customer behavior

Resources

Stars

1 star

Watchers

0 watching

Forks

Repository files navigation

Customer Shopping Behavior Analysis

End-to-end analysis of 3,900 retail transactions using Python, MySQL, and Power BI.

Tech Stack

Python (Pandas) · MySQL · Power BI

Workflow

  • Python — Data cleaning, median imputation, feature engineering, loaded to MySQL
  • MySQL — 10 business queries (segmentation, revenue analysis, discount behavior, product rankings)
  • Power BI — Interactive dashboard with KPI cards and filters

Key Insights

  • 2,518 repeat buyers are unsubscribed → biggest retention opportunity
  • Young Adults drive the highest revenue ($62,143)
  • Hats & Sneakers have ~50% discount rates → margin concern
  • 80% of customers are Loyal, but only 27% are subscribed

Recommendations

Boost subscriptions · Loyalty programs · Review discount policy · Targeted marketing toward Young Adults

Author

Nishant Pareek · [www.linkedin.com/in/nishant-pareek-3a4612330] · [nishantwork102@gmail.com]

About

Data analytics project showcasing customer behavior

Resources

Stars

1 star

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages