dimensional modeling of AdventureWorks2017 for sales, creating a DataMart. It includes an ETL pipeline that loads the data from AdventureWorks2017 to AdventureWorksDM using SQL Server Integration Services (SSIS) and implements Slowly Changing Dimension (SCD) handling using the SCD wizard and Merge statement.
- DimCustomer_TSQL: This package loads data into the DimCustomer dimension table using a Merge statement for handling Slowly Changing Dimension (SCD).
2. DimProduct_Wizard: This package loads data into the DimProduct dimension table using the SCD Wizard to handle SCD.
3. DimSalesPerson_Wizard: This package loads data into the DimSalesPerson dimension table using the SCD Wizard to handle SCD.
4. FactSalesOrder: This package loads data into the FactSalesOrder fact table.
Multidimensional OLAP CUBE Project See AdvenutreWorksDM_SSAS
Overview Dashboard for sales and sales quantity using Tableau could be found here
