ETL Project (AdventureWorks 2022)
تفاصيل العمل
Extracted data from AdventureWorks 2022 database Designed and created 4 dimension tables: Dim_Customer, Dim_Territory, Dim_Product, Dim_Date Created a Fact_Sales table as the fact table to store transactional data Built a complete ETL pipeline with data transformations, lookups, and data cleansing Loaded the transformed data into SQL Server and verified the data integrity Developed an interactive Power BI dashboard to visualize sales insights, KPIs, and trends
مهارات العمل
