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.
- 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
, andDimShipMethod
. - Documentation: Comprehensive documentation detailing project structure, data models, and ETL processes.
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)
-
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.
-
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.
For detailed information on the project, including project structure, data models, and ETL processes, refer to the full documentation.