AdventureWorksDM
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.
DataMart Schema
SSIS Packages
- 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.
Analysis
Multidimensional OLAP CUBE Project See AdvenutreWorksDM_SSAS
Reporting
Overview Dashboard for sales and sales quantity using Tableau could be found here