Sales-Data-Warehouse-End-to-End

This was a guided learning experience, but I made sure to go beyond just following steps — I focused on understanding how and why each component works within the full Business Intelligence lifecycle.

This project helped me connect the dots between data engineering, data modeling, and business insights.

What I worked on:

Designed a Star Schema using Fact & Dimension tables for efficient analytical queries

Built a complete ETL pipeline using SSIS

Implemented Slowly Changing Dimensions (SCD Type 2) to track historical data changes

Applied Incremental Loading using Last Modified Date for optimized performance

Created an interactive Power BI dashboard to visualize:

Revenue trends

Sales performance

Top sales representatives

Tech Stack:

SQL Server , SSIS (SQL Server Integration Services) , Power BI , T-SQL

What I learned:

This project gave me hands-on experience in:

Data Warehouse Design

ETL Development

Data Modeling Best Practices

Turning raw data into actionable insights