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.