Applying Data Modeling & ETL Concepts Using SSIS

This project allowed my teammate ‏‏‏Malak Hamido ‏and me to design and implement a complete end-to-end data solution.

Key contributions:

Automated ETL pipelines in SSIS with incremental loads and SCD Type 2.

Designed a Star Schema for optimized analytics.

Wrote SQL queries to uncover sales and customer insights.

Built Power BI dashboards to deliver KPIs and business reports.

Added a Python streaming component for real-time data processing