Project: Customer Shopping Behaviour

Problem

Business needed insights into customer purchasing patterns, sales trends, and product performance to support data-driven decisions.

Dataset

Sales transaction dataset containing customer details, product categories, order dates, quantity, and revenue.

Tools

Python, SQL, Power BI

Key Steps

  • Cleaned and preprocessed raw sales data using Python and Pandas
  • Performed EDA to identify trends and patterns
  • Analyzed customer behavior and product performance
  • Created interactive Power BI dashboard to visualize KPIs and sales trends
  • Used SQL queries to extract and aggregate relevant data

Impact

Identified top-performing products, peak sales periods, and customer purchase patterns, helping improve business decision-making and sales strategy.