Ecommerce Customer Behaviour SQL Analysis

Project Overview

This project analyzes customer purchasing behavior using SQL. The dataset contains customer demographics, product categories, payment methods, device usage, ratings, and revenue information.

Dataset

• Total Records: [17501]
• Source: Ecommerce Customer Behaviour Dataset
• Format: CSV

Tools Used

• MySQL Workbench
• SQL
• VS Code
• GitHub

Database Schema

The database contains customer transaction and behavior data including:

• Customer ID
• Age
• Gender
• City
• Product Category
• Payment Method
• Device Type
• Customer Rating
• Total Amount

SQL Analysis Performed -

1. Total Revenue

2. Top Product Categories

3. Payment Method Usage

4. Device Type Analysis

5. Top Cities by Revenue

6. Top 10 Customers by Spending

7. Average Customer Rating

8. Returning vs New Customers

Key Insights

• Identified the highest revenue-generating product categories.
• Analyzed customer payment preferences.
• Compared revenue across cities.
• Studied device usage patterns.
• Identified top-spending customers.
• Evaluated customer satisfaction using ratings.

Project Structure

dataset ecommerce_customer_behaviour.csv

screenshots total_revenue.png top_productcategory.png payment_method_usage.png device_type_analysis.png top_cities_revenue.png top10_customers_spending.png average_customer_rating.png returning_vd_newcustomers.png

sql ecommerce_customer_behaviour_analysis.sql

README.md

Author

Nikitha Chimala