Automated analytics pipeline for order-level data using Python and Excel.
- ETL pipeline reads and cleans raw order data.
- Aggregates KPIs: Revenue, Profit, Quantity by Region.
- Generates Excel summary and visual chart.
- GitHub Actions automates daily refresh.
- Dashboard and Excel file hosted on Hostinger.
- Python (pandas, matplotlib, openpyxl)
- Excel
- GitHub Actions
- Hostinger