The Self Sovereign Identity Service

Aries Framework .NET for building multiplatform SSI services

Microsoft Integration Services (SSIS) Source component

Proxy services, combine origins, use SSI and more during development

A simple set of reports showing execution details in the SQL Server Integration Services (SSIS) catalog

Controller Service for the SSI Agent

Powershell module to deploy SQL Server Integration Services (SSIS) to on premise of Azure. Works with the new ADF v2 SSIS PAAS service.

By using AdventureWorks2022 Dataset I have built a Sales Data Mart using (SQL Server Integration Services SSIS) SQL Server involves leveraging the capabilities of Integration Services (SSIS) and the Modeling of SQL Server, This Data mart offers several benefits, making them valuable components in the main purpose of data management and analytics wi

Simple Task for SSIS (SQL Server Integration Services) to manage, compress and decompress file ZIP/TAR/GZ.

A GitHub action that Installs the latest standalone SQL Server Integration Service (SSIS) devops tools.

Esse repositorio tem como objetivo apresentar um pouco sobre a arquitetura SSIS(SQL Server Integration Services) que é a ferramenta para projetos de Microsoft ETL. Esse repositorio tem como objetivo apresentar um pouco sobre a arquitetura SSIS(SQL Server Integration Services) que é a ferramenta para projetos de Microsoft ETL. Ele faz parte de um projeto em que implemento uma aplicação por completo (backend, frontend, bases de dados e etcs...)

This repository contains a real example of an Extract, Transform, Load (ETL) process using SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), and AdventureWorks2012 data. The objective is to load data into our LightAdventureDW data warehouse.

Web services and applications (including e.g., the Analysis Portal GUI and Dyntaxa) developed by The Swedish Species Information Centre (SSIC, swed.: Artdatabanken)

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.

The complete data pipeline from extraction from source to storage in Datawarehouse of the Dataset of an E-Business, with SQL Server Integration Services (SSIS).

A repository for the practice exercises for Microsoft SQL Server Integration Service (SSIS for short, it is an ETL tool) while digging deep on understanding the tool and practicing.

Position Description The Report Developer will be a key member of a team responsible for implementing a critical reporting initiative. The individual will work with a team in IT to create key financial and operating metrics. Responsibilities include report development, dashboard development, and assisting the business with data requests and analysis. Report and dashboard development requirements will span across multiple systems and will include integration of data from multiple sources. Responsibilities • Design and implement enterprise reporting and business intelligence solutions. • Gather requirements from business users. • Prepare ad hoc customer, product, and labor analysis. • Dashboard development using Dundas Data Visualization software. • Report development using Microsoft SQL Server Reporting Services (SSRS). • ETL using SQL Server Integration Services (SSIS). • Set up routines within SQL Server to consolidate data from multiple data sources. • Maintain data marts of extracted data. • Conceptual, logical and physical data modeling. • Develop optimized stored procedures. Required experience and attributes • At least 3 years of experience in software development and database design, with emphasis on the SQL Server 2008 (primarily SSRS and SSIS). • Solid experience with MS SQL Server development (stored procedures, views, triggers, functions, query optimization). • Experience with web and browser based applications and technologies. • Attention to detail and possession of a *data stewardship* attitude. • Strong problem solving skills. • Ability to write stored procedures and complex SSIS packages. • Proficient with Microsoft Excel, especially pivot tables, reports, and charts. • Self-motivated and a high degree of intellectual curiosity. • Demonstrated organizational skills & ability to multi-task in a fast-paced environment with competing priorities. • Financial and Operating metrics reporting experience a plus!

ETL Projet : SSIS and SQL SERVER - Service Center Data

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

Data flow component to convert datatypes in Sql Server Integration Services (SSIS)

No description available

ETL with SSIS

SSIS_LL_SQL_Server_Integration_Services_Adam_Wilbert

OriginTrail based services for SSI enabled personal knowledge graph management (OpenPKG project)

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

Dive deep into Slowly Changing Dimensions (SCD) ETL in action with this comprehensive tutorial! In this video, we'll explore how to effectively manage changing data using SQL Server Management Studio (SSMS) and 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.

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

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.