Project Overview

This project analyzes over 121,000 e-commerce orders using Google BigQuery, SQL, and Tableau to identify sales trends, customer purchasing behavior, fulfillment performance, and cancellation patterns. The goal was to transform raw transaction data into actionable business insights through data cleaning, KPI development, and dashboard visualization.

Tools

• Google BigQuery

• SQL

• Tableau

Key Insights

• $78.57M total revenue generated.

• 121.15K total orders processed.

• 8.9% cancellation rate.

• Set was the top-selling category ($39.20M), followed by Kurta ($21.29M).

• Dupatta generated the lowest revenue ($915).

• 64.04% of orders were shipped, 23.73% delivered, and 8.88% canceled.

• Maharashtra generated the highest revenue ($13.34M), followed by Karnataka ($10.48M).

• Higher sales states also showed higher cancellation rates.

• Amazon Fulfillment processed 83.62K orders versus 37.53K through Merchant Fulfillment.

• Expedited Shipping handled 82.7K orders, compared to 38.44K through Standard Shipping.

Recommendations

• Increase investment in Set and Kurta categories.

• Review Dupatta performance to identify improvement opportunities.

• Investigate causes of the 8.9% cancellation rate.

• Expand marketing efforts in lower-performing regions.

• Analyze the relationship between high sales and high cancellation rates.

• Encourage greater adoption of Amazon Fulfillment.

• Promote Expedited Shipping while monitoring profitability and service quality.