Analyzing sales and customer behavior for actionable insights
This project leverages SQL queries to analyze an e-commerce dataset. The primary focus includes identifying sales trends, segmenting customers, and providing actionable insights into revenue and profitability. The analysis also visualizes key performance indicators (KPIs) using tools like Power BI.
The database was designed to organize e-commerce data efficiently, with tables representing customers, categories, products, orders, and order details. Relationships between these tables were established to allow comprehensive analysis.
This query identifies the top-selling products by summing quantities sold and calculating total revenue.
Analyzes revenue generated by each category to determine the most profitable segments.
Displays customer order histories, including names, order dates, and total amounts.