E-Commerce Revenue & Product Performance Analysis

SQL • BigQuery

Cloud-based SQL analytics project using Google BigQuery and the public thelook_ecommerce dataset (100K+ orders) to uncover revenue trends, product performance patterns, and seasonal demand drivers.

100K+ orders 35% revenue from top 10 3x holiday spike

Key Insights Delivered

  • Identified top 10 products generating 35% of total revenue
  • Analyzed daily revenue fluctuations revealing 3x spike during holiday periods
  • Calculated product category contribution showing Outerwear and Jeans as consistent top performers

Technical Approach

  • Wrote optimized SQL JOINs across orders, order_items, and products tables
  • Built CTEs for daily aggregations and time-series revenue tracking
  • Created BigQuery visualizations for stakeholder-ready reporting
  • Structured queries for repeatability and business user accessibility
Tools: SQL, BigQuery, Public Datasets, Data Visualization Domain: E-commerce / Retail Analytics
← Back to Projects