SSIS Purchase Data ETL Project

Introduction

Welcome to the SSIS Purchase Data ETL (Extract, Transform, Load) project. This project aims to implement a robust ETL process using SQL Server Integration Services (SSIS) to extract data from the AdventureWorks database, transform it, and load it into a Data Warehouse named "Datawarehouse." The Data Warehouse will serve as a foundation for creating insightful dashboards on purchasing activities.

Features

Data Extraction: Extracts relevant purchase data from the AdventureWorks database.
Transformation: Applies necessary transformations to clean, enrich, and structure the data.
Data Loading: Loads the transformed data into the Datawarehouse Data Warehouse.
Fact Table: Implements a Fact Table named FactPurchase capturing key purchasing metrics.
Dimension Tables: Creates Dimension Tables for DimEmployee, DimProduct, DimVendor, and DimShipMethod.
Documentation: Comprehensive documentation detailing project structure, data models, and ETL processes.

Getting Started

Prerequisites

Before getting started, ensure the following are installed:

SQL Server with AdventureWorks database
SQL Server Data Tools (SSDT) or SQL Server Management Studio (SSMS)
SQL Server Integration Services (SSIS)

Installation

Clone the repository:
```
https://github.com/Sahar-dev/SSIS.git
```
Open the SSIS project in SQL Server Data Tools.
Update connection strings and configurations in SSIS packages as needed.

Usage

Execute the SSIS packages in the correct order for data extraction, transformation, and loading.
Monitor SSIS execution logs for any issues or errors.
Explore the generated Datawarehouse Data Warehouse for insights.

Documentation

For detailed information on the project, including project structure, data models, and ETL processes, refer to the full documentation.

Sahar-dev/SSIS