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:
github.com/Agb...
29 сен 2024