Implemented Data Warehouse and Business Intelligence project using different structured and unstructured data sources of various Incidents and Mortality rates of Tuberculosis for 197 countries around the world. The aim was to analyze the trends in mortality and incidence rates in countries around the world for tuberculosis. Data was web scrapped, cleansed and loaded using ETL designed star schema and deployed OLAP cube. Non-trivial BI queries were generated. First of all the data was extracted, cleaned and transformed using R language and further injected and loaded into SSMS where dimension tables were created using Insert query task. Kimbell's bottom-up approach was used to design the star schema in SSIS. Finally the cube was deployed in SSAS. Tableau was used for visual analytics to create dashboards. Technologies used: MS SQL, SQL Server Integration Services, SQL Server Analysis Services, Tableau. Video link of execution with explanation is available.

SSIS (SQL Server Integration Services) project for building a data warehouse solution

No description available

The project involves building a comprehensive data warehouse from the AdventureWorks2022 source system, creating staging and dimensional tables, and Designing a Tabular model using a combination of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and Power BI, and creating a report with SSRS

This mini project showcase how to spin up Microsoft SQL Server container with SSIS (SQL Server Integration Service) features. This also shows how to build SSIS project via SSDT (SQL Server Data Tools) tools in Visual Studio

Develop a modern data warehouse using SQL Server, incorporating a full ETL (Extract, Transform, Load) pipeline, optimized data modeling, and advanced analytics. The project will involve designing a scalable schema, integrating data from multiple sources, implementing efficient ETL processes using SQL Server Integration Services (SSIS).

This project is an ETL pipeline built with SQL Server Integration Services (SSIS) to process raw telecom transaction data (IMSI, IMEI, LAC, CELL, Event Type, Event Timestamp, etc.). It focuses on data cleaning, transformation, and loading into SQL Server for analytics and reporting.

The main objective of this project is to Develop a predictive model logic based algorithm in SQL in accordance to the predictive model developed earlier with R, to predict the possibilities of Delayed discharges and secondly to analyse the Delayed Discharges of the patients in Govt.Hospital and provide forecasts of various indicators for future months. The scope of the project can be divided into two different phases as stated below, 2.1 Phase1: The main objective of this phase is to automate (SSIS package integration) the data (features of the patients) extraction from the integrated data storage which was previously loaded into data base through various integration jobs in Microsoft SQL server. Develop a new predictive model with Machine Learning algorithm in R . To support the model developed to predict the possibilities of a patient delaying discharge based on the previous historic data by automating the data analysis (required features of the patient by the model) and providing a daily automatic email Discharge team based on the output from the newly developed Patient Score calculating algorithm. SQL Reporting Services will be used for this work. 2.2 Phase 2: The main objective of this phase is to analyse the historic data to find trends and seasonality measures in order to foresee the occurrences of the delayed discharges and associated indicators e.g. care home availability over a short or long term as expected by Gov.Uk Hospitals. Various forecasting techniques can be used based on the data availability.

Stores my SQL Server Integration Services (SSIS) projects

No description available

ETL Case Study Project for Telecom Company using SQL Server Integration Services (SSIS)

This project consists of creating an aggregate package in Microsoft SQL Server Integration Services SSIS.

A data integration project using SQL Server Integration Services (SSIS) to populate data warehouse dimensions from electrical companies' data.

This SQL Server Integration Services (SSIS) project processes electrical company data from monthly Excel files and loads it into SQL Server databases.

The project aims to implement SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS) technologies to create a complete Business Intelligence (BI) solution for Toyota Tunisia with test data.

This project showcases SQL Server Integration Services (SSIS) packages designed for the WideWorldImporters database. It provides ETL (Extract, Transform, Load) workflows to facilitate data integration and manipulation, making it easier to work with the WideWorldImporters sample data.

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."

Created basic ETL Project using SQL Server Management Studio and SQL Server Integration Services. The data pipeline basically flows in following manner: Data will be extracted from Demo CSV file and will be transferred (Using SSIS) into an empty table ("RepPerformanceTargets") located in AdventureWorks database (SQL Server Management Studio). The Demo ETL Package is also deployed in SQL Server for future updates. To get refreshed data every time, I also utilized "Execute SQL Query Task" in SSIS to truncate table data everytime new data is uploaded in database. Control Flow in SSIS

No description available

Project to build integration Using - SSIS - SQL Server Integration Services

No description available

No description available

ETL Projects using SQL Server Integration Service(SSIS)

Project of my SSIS (SQL Server Integration Services) course - Teacher Elena Lopez

SSIS Packages (5 Assignments)

ETL Case Study Project for Telecom Company using SQL Server Integration Services (SSIS)

This repository contains a beginner-friendly SSIS (SQL Server Integration Services) project designed for training and learning ETL concepts. It demonstrates how to extract, transform, and load data using SSIS packages, making it ideal for students, interns, and anyone starting with data integration workflows

SSIS ETL Project - Data Integration & Transformation Extract, Transform, Load operations using SQL Server Integration Services Data migration and workflow automation with SSIS packages

Data Warehouse and data mining project implementing ETL processes using SQL Server Integration Services (SSIS).

A simple SSIS —SQL Server Integration Services— project including two SQL Server Database Projects as source and target.