Simple Flask App

Build an ETL pipeline using Python with three data sources:

customers.csv

orders.parquet

products.csv — retrieved from an API Link

Clean, transform, merge the data, load the final Sales table into SQL Server, and display it using a Flask dashboard.

🔄 Transformations

Customers

Remove duplicates

Standardize city

Validate age

Handle missing email

Create full_name

Orders

Remove duplicate order_id

Validate quantity

Convert order_date to datetime

Validate customer_id

Products

Remove duplicates

Standardize product/category

Validate unit_price

Convert price to numeric

💰 Sales

Merge the three datasets and calculate: