Ecommerce-SQL-Analytics

The goal was to design a structured relational database that transforms raw business data into meaningful analytical insights.

بدل ما تكون Data Engineering concepts مجرد نظرية، المشروع ده ساعدني أطبقها بشكل عملي فعلي.

Here is the workflow I implemented:

1️⃣ Database Design — 5 related tables (Customers, Products, Orders, Order Items & Payments) connected through Primary & Foreign Keys

2️⃣ Data Insertion — realistic sample data across customers, products, orders and payments

3️⃣ Analytics Queries — 7 business-driven queries:

• Top 3 customers by spending

• Customer segmentation (Frequent / Regular / New)

• Orders above average value

• Monthly revenue report

• Top-selling products & more

الخطوة دي كانت مهمة جداً عشان أفهم إزاي نحول البيانات لـ insights حقيقية بتخدم قرارات بيزنس.

Key insights from the data:

• Highest order value: 17,000 EGP

• Revenue peaked in April 2024

• Credit card is the dominant payment method

Through this project I practiced:

✔️ Relational Database Design

✔️ Aggregate Functions & Subqueries

✔️ CASE WHEN Logic / Segmentation

✔️ Multi-table JOINs