E-Commerce Analytics Project

**Advanced SQL E-commerce Customer Analytics Project**

Developed an end-to-end SQL-based analytical project to extract business insights from an e-commerce dataset. The analysis combined transactional, customer demographic, pricing, and delivery data to support data-driven decision-making.

Key contributions:

* Performed data quality assessment including missing values and duplicate detection

* Analyzed customer behavior across gender, tenure, and purchasing patterns

* Identified high and low-performing product categories

* Evaluated delivery charges and their impact on product performance

* Detected unit price anomalies and potential data inconsistencies

* Created reusable SQL views to support invoice-level reporting

Tools used: SQL (CTEs, Window Functions, Joins, Aggregations, Subqueries)

Delivered actionable business insights to support pricing strategy and customer segmentation decisions.