Skip to content

About

This project demonstrates a full, industry-standard end-to-end data analytics workflow that reflects the real-world responsibilities of professional analysts. It covers every key stage of the analytics process, including data cleaning and preparation, modeling, insight generation, visualization, and final reporting.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Repository files navigation

Customer Shopping Behavior Analysis

Project Overview

This project demonstrates a complete, industry-style end-to-end data analytics workflow designed to mirror real-world analyst responsibilities. It covers every major phase of the analytics lifecycle—from data cleaning and modeling to insight generation, visualization, and reporting.

The goal of this project is to analyze customer shopping behavior data to uncover purchasing trends, customer segments, and business insights that can help improve marketing, sales strategy, and customer retention.


Objectives

  • Clean and preprocess raw customer shopping data
  • Perform exploratory data analysis (EDA)
  • Identify key purchasing patterns and trends
  • Build SQL queries to extract business insights
  • Create dashboards and visualizations
  • Present findings in a professional report format

Dataset

File: customer_shopping_behavior.csv From Amlan Mohanty

The dataset contains customer transaction information such as:

  • Customer ID
  • Gender
  • Purchase Amount
  • Discount Applied
  • Product Information
  • Other behavioral indicators

This dataset is used to simulate real-world retail analytics scenarios.


Tools & Technologies

  • Python – Data cleaning, analysis, and modeling
  • Pandas / NumPy – Data manipulation
  • Matplotlib / Seaborn – Visualization
  • SQL – Querying and business insight extraction
  • Power BI / Excel – Dashboarding and reporting
  • Jupyter Notebook – Workflow development and documentation

Current Project Structure

CustomerAnalytics/
│
├── CustomerAnalysis.ipynb
├── customer_shopping_behavior.csv
├── SQLQuery3.sql
└── README.md

Analysis Being Performed

Examples of business questions explored:

  • Revenue comparison by gender
  • Impact of discounts on purchase behavior
  • Customers spending above average
  • High-value customer identification
  • Trends across product categories

Sheet #1 - Customer Analysis Dashboard

image

Sheet #2 - Raw Data Analysis

image

Example Skills Demonstrated

  • Data cleaning and preprocessing
  • SQL query development
  • Business analytics thinking
  • Dashboard design and storytelling
  • End-to-end analytics workflow

Author

Matthew Yu Systems and Computing Engineering Student University of Guelph


About

This project demonstrates a full, industry-standard end-to-end data analytics workflow that reflects the real-world responsibilities of professional analysts. It covers every key stage of the analytics process, including data cleaning and preparation, modeling, insight generation, visualization, and final reporting.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages