E-Commerce Data Warehouse Analytics using SQL

his project focuses on analyzing e-commerce sales data using a data warehouse approach with SQL. It extracts meaningful insights from structured datasets, including products, customers, and sales transactions, to support business decision-making.

The analysis covers multiple perspectives such as product performance, customer distribution, and sales trends over time. Advanced SQL techniques like Common Table Expressions (CTEs) and window functions are used to perform deep analytical operations.