🚀 Completed a Sales Order Data Warehouse Project
Designed and developed a Sales Order Data Warehouse using SQL Server and SSIS, following the Star Schema approach to support business reporting and analytics.
🔹 Built and loaded Fact and Dimension tables including:
Customer, Product, Category, Market, Location, and Date dimensions.
🔹 Applied dimensional modeling concepts such as:
Role-Playing Dimension for Order Date and Ship Date.
Junk Dimension to organize low-cardinality business attributes.
🔹 Developed ETL pipelines to extract, transform, cleanse, and load data while ensuring data quality and referential integrity.
Technologies: SQL Server | SSIS | ETL | Data Warehousing | Dimensional Modeling
