Skip to main content
Case Study

GlobalRetail Data Analysis

End-to-end retail analytics on 50,000 orders including time-series analysis, profitability analysis, customer segmentation (RFM), returns analysis, and predictive modeling.

PythonPandasJupyterMachine Learning

Simulation Note: This project uses a synthetic/sample dataset. Financial impact, savings, ROI, and SLA-cost estimates are modeled scenarios for analytical demonstration and do not represent actual NTC financial figures.

Modeled Estimate (synthetic data)

50,000
Orders
$87.3M
Total Revenue
$18.1M
Total Profit
24.9%
Return Rate

Analysis Charts

Time-Series Analysis

Monthly Revenue Trends
Monthly Revenue Trends
Seasonality Pattern
Seasonality Pattern
Year-over-Year Comparison
Year-over-Year Comparison
YoY Growth Rate
YoY Growth Rate

Profitability Analysis

Discount-Profit Correlation
Discount-Profit Correlation
Negative Profit Orders
Negative Profit Orders
Profit Margin Distribution
Profit Margin Distribution

Customer Segmentation

Pareto Analysis — Top Customers
Pareto Analysis — Top Customers
RFM Segmentation
RFM Segmentation
RFM Segment Distribution
RFM Segment Distribution

Returns & Shipping Analysis

Return Breakdown by Category
Return Breakdown by Category
Revenue Lost to Returns
Revenue Lost to Returns
Return Rate by Product
Return Rate by Product
Shipping Mode vs Return Rate
Shipping Mode vs Return Rate
Payment Method Distribution
Payment Method Distribution
Shipping Mode Preferences
Shipping Mode Preferences
Shipping Rating Analysis
Shipping Rating Analysis

Salesperson & Advanced Analysis

Salesperson Performance
Salesperson Performance
Cohort Retention Heatmap
Cohort Retention Heatmap
Feature Importance (Logistic Regression)
Feature Importance (Logistic Regression)
RFM Tiers Distribution
RFM Tiers Distribution

Business Problem

A global retailer was struggling with declining profitability despite growing revenue, high return rates eating into margins.

Methodology

Step 1

Data Collection

Step 2

Data Cleaning

Step 3

Exploratory Data Analysis

Step 4

SQL Analysis

Step 5

Visualization

Step 6

Insights

Step 7

Recommendations

Key Insights

01

Revenue declined 2.8% YoY — need for growth strategy reversal

02

Top 20% of customers generate ~29.5% of total revenue

03

Return rate of 24.94% resulting in $4.5M in lost profit

04

Discount-profit margin correlation of -0.365 — higher discounts hurt margins

05

RFM segmentation created 3 customer tiers for targeted marketing

Business Recommendations

Modeled Estimate (synthetic data)
01

Cap discounts at ~20% for margin-sensitive categories to protect profitability.

02

Review Same Day shipping returns and consider restricting it to high-value repeat customers or adding a restocking fee.

03

Study top salesperson strategies and convert them into training material for underperformers.

04

Use the RFM tiers to run targeted retention campaigns on High-value and At-risk segments.

Technical Highlights

Python

  • ▸Pandas data wrangling
  • ▸Time-series analysis
  • ▸RFM customer segmentation
  • ▸Logistic regression modeling

Analysis

  • ▸YoY growth analysis
  • ▸Profitability decomposition
  • ▸Return rate analysis
  • ▸Pareto (80/20) customer analysis

Visualization

  • ▸22+ charts generated
  • ▸Interactive dashboards
  • ▸Cohort & RFM heatmaps
  • ▸Presentation-ready slides

Dataset

50,000 orders from 2024-2025, spanning 2,000 customers, $87.3M revenue, across multiple regions and product categories.

Project Outcome

Modeled Estimate (synthetic data)

Identified estimated $2M+ profit recovery opportunity across 50K orders by analyzing return patterns, customer segments, and discount impact on margins.