Skip to content
Abdelrahman Elaref
All work

Project

Sales Analytics ETL & Power BI

Robust ETL pipeline processing 20,000+ rows of sales data, surfaced through an interactive Power BI dashboard.

  • Python
  • PostgreSQL
  • Power BI
Sales Analytics ETL pipeline output preview

Built a production-style ETL pipeline that ingests sales data, normalizes it through PostgreSQL, and surfaces it via an interactive Power BI dashboard for downstream analysis.

What I did

  • Python-driven ETL with explicit data validation and error handling at each stage.
  • PostgreSQL as the analytical store, with a star-schema model designed for BI consumption.
  • Power BI dashboard layered on top with drill-downs, filters, and KPI cards for sales performance views.
  • 20,000+ rows processed; pipeline designed to scale linearly with input volume.

Tools & techniques

  • Python
  • PostgreSQL
  • Power BI
  • DAX
  • Star schema