🛒 E-Commerce Order Analysis (Python + Excel Automation)

Automated analytics pipeline for order-level data using Python and Excel.

Workflow

1. ETL pipeline reads and cleans raw order data.
2. Aggregates KPIs: Revenue, Profit, Quantity by Region.
3. Generates Excel summary and visual chart.
4. GitHub Actions automates daily refresh.
5. Dashboard and Excel file hosted on Hostinger.

---

Tech Stack

• Python (pandas, matplotlib, openpyxl)
• Excel
• GitHub Actions
• Hostinger