// E-commerce Sales and Business Operations Analysis
Project Overview
This project provides a comprehensive analysis of e-commerce sales and business operations, combining insights from sales trends, product performance, customer segmentation, and profitability metrics. It is designed to help businesses optimize operations, maximize profits, and make data-driven decisions.
Objectives
– Identify monthly and yearly sales trends.
– Highlight top-performing and underperforming categories, sub-categories, and products.
– Assess profitability using metrics like Profitability Index (PI) and Sales-to-Profit Ratio.
– Generate actionable insights for strategy, inventory planning, and marketing.
Core Descriptive Analysis (Business Overview)
A. Monthly Sales Trend
– Highest sales month: November – 352,461
– Lowest sales month: February – 59,751
– Observation: Sales are variable, with spikes in March (205,005) and September (307,650).
B. Category-Level Performance
– Technology leads sales: 836,154.03
– Office Supplies close second: 719,047.03
– Furniture third: 741,999.79
C. Sub-Category Deep Dive
– High-performing: Chairs, Phones, Copiers
– Underperforming: Fasteners, Art, Envelopes
D. Monthly Profit Analysis
– Profit peak in Month 12: 43,369.19
– Lowest in Month 1: 9,134.44
– Notable growth in Q3-Q4 months.
E. Profit by Category
– Highest Profit: Technology 145,454.94
– Lowest Profit: Furniture 18,451.27
F. Customer Segmentation
– Consumer segment dominates: 1,161,401 sales, 134,119 profit
– Home Office smallest contributor.
G. Sales-to-Profit Ratio
– Consumer segment most efficient (8.65)
– Home Office least efficient (7.12)
Advanced analysis
A. Year-over-Year Growth
– Strong YoY growth in 2023
– Some months show negative YoY (e.g., Feb 2023, Apr 2023)
B. Profitability Index
– Furniture high sales but low profit efficiency (PI = 40.21)
– High-efficiency sub-categories: Chairs, Phones, Storage
C. Pareto Analysis
– Top contributors: Copiers, Phones, Accessories, Paper
– Focus on optimizing low-profit items like Tables & Bookcases
D. Pareto + Profitability Index
– Items with high profit but low efficiency need attention for margin improvement
– Example: GBC DocuBind TL300 (high PI, moderate profit)
teachnlogy used
SQL
Python
excel
MY BRAIN
MATLOIB
PANDAS
scikit-learn
– Data Storage & Extraction: SQL, Excel, CSV files
– Data Cleaning & Transformation: Python (pandas, NumPy)
– Data Visualization: Plotly (Python), Power BI, Excel charts
– Analytics Methods:Descriptive analytics (sales trends, category performance) Ratios, YoY growth, Pareto analysis, profitability index