Data Engineering/Modeling and ETL
Data Analytics and BI, Topic 2:
Activities:
-Download sample OLTP adventure works Database
-Restore Database
-Business Requirement: Sales by territory
-Data Modeling based on Bus requirements
-Create Data Vault or Staging, Schema
-Create SSIS Packages to load from Source to Destination
-Run ETL
-Run Truncate SQL Task
Source Code:
https://github.com/AgbonAgb/Data-Anal...