Skip to content

Mayowa-Taiwo/Data-Warehousing-OLTP-to-DWH-NorthWind-OLTP

Repository files navigation

			### IMPLEMENTING AN ENTERPRISE DATA WAREHOUSE USING SSIS

About Project

  • This project aims to explain the processes involved in building data warehouses for organizations looking to create their first Enterprise Data Warehouse (EDW), assuming they currently have a data repository that can be used as the data source for the ETL (Extract, Transform, and Load) pipelines. The OLTP source used for this project is the Northwind Database, which represents a small company or department within a large organization. This database serves as an example for converting an OLTP Database to an Enterprise Data Warehouse using SQL Server Integration Services (SSIS)."

     			Northwind Database Diagram
    

NorthWInd OLTP Diagram

					Staging area

Northwind_DataStagingLayer

				Final Datwarehouse Tables

Northwind_DW_Tables

				Dataware house Diagram

Northwind_DW_Diagram

Releases

No releases published

Packages

No packages published