E-Commerce Sales Database & Analysis (SQL)

Developed a comprehensive E-Commerce Sales Database using SQL to simulate a real-world online store, demonstrating skills in data modeling, relational database design, and data analysis. The project includes multiple interconnected tables for Customers, Products, Orders, and Order_Items, allowing for efficient storage and retrieval of transactional data.

Key features include:

Designing a normalized relational database with proper relationships and constraints

Performing advanced SQL queries to extract insights such as top-spending customers, most-sold products, and monthly sales trends

Utilizing Python and Pandas to run SQL queries and present analysis in a clean, readable format

Demonstrating practical Data Engineering skills by managing structured data and generating actionable insights

This project highlights the ability to build, manage, and analyze relational data, showcasing proficiency in SQL, database design, and data-driven decision making—essential skills for data engineering and analytics roles.