Online Retail Analysis

Exploratory Data Analysis (EDA) and Customer Segmentation Project

Project Overview: This project involves performing comprehensive Exploratory Data Analysis (EDA) and Customer Segmentation using transaction data from a UK-based online retail store. The dataset includes crucial information such as invoice numbers, stock codes, product descriptions, quantities sold, invoice dates, unit prices, customer identifiers, and transaction countries.

Skills and Concepts

• Data Cleaning and Preparation: Handled missing values by dropping rows with missing CustomerID, removed duplicates, filtered out transactions with negative quantities and prices, and converted InvoiceDate to datetime format for accurate time-based analysis.
• Exploratory Data Analysis (EDA): Analyzed sales trends, product popularity, and customer purchasing patterns across different countries using various visualizations like box plots, heatmaps, line and bar charts, and pie charts.
• Cohort Analysis: Created cohort-based features and visualized customer retention over time using heatmaps.
• Sales Performance Analysis: Analyzed time-based features and visualized monthly and daily sales trends. Conducted a detailed analysis of specific periods, such as November 2011, to understand sales dynamics.
• Customer Segmentation: Performed RFM (Recency, Frequency, Monetary) analysis to segment customers based on purchasing behavior, identifying high-value customers and tailoring marketing strategies accordingly.
• Product Analysis: Identified top-selling products, analyzed return patterns, determined revenue-generating products by country, and highlighted key revenue drivers.

Conclusion

This project demonstrates the ability to derive actionable insights from raw data, optimize business strategies, and create user-friendly visualizations. Key tasks included data cleaning, EDA, customer segmentation, time series analysis, and product analysis, ultimately informing and enhancing business performance.

GitHub Project

You can view the full project on GitHub here.

Back to Portfolio