A Python-based ETL pipeline for daily sales performance monitoring with automated alerts.
This system automates daily sales performance tracking with:
- Daily performance briefings (HTML/PDF/Email)
- Real-time alerts for underperforming regions/products
- Data validation to ensure reporting accuracy
| Category | Technologies |
|---|---|
| Core | Python (Pandas, SQLAlchemy) |
| Database | SQLite (PostgreSQL-ready) |
| Orchestration | Apache Airflow |
| Reporting | HTML, CSS, Jinja2 |
| Alerting | Slack/Email (SMTP) integration |
| Feature | Description |
|---|---|
| Automated ETL | Daily data pulls from multiple sources |
| Smart Alerts | Threshold-based notifications (Slack/Email) |
| Data Quality Checks | Null detection, outlier flagging |
| Parameterized Reports | Region/team/department-level filtering |
| Self-healing Pipeline | Auto-retry for failed tasks |
- Python
- Airflow
- SQLite/PostgreSQL