E-commerce Sales Data Pipeline (Python, SQLite, SQL)
Cleaned a raw, messy orders dataset (512 rows) using Python and Pandas: removed duplicates, standardized city and customer names, and fixed price, quantity and date formats.
Split the data into normalized customers, products and orders tables stored in a SQLite database.
Wrote SQL queries (GROUP BY, multi-table JOINs) to answer business questions such as sales by city and top products.