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

Implement a simple data warehouse to store Saklia data - Create data pipelines for extract, transform and load data from source to warehouse - Retrieve data in warehouse to explore and do several analysis

Integrated Data Warehouse Solution for Airbnb Analytics: ETL Automation, SQL SERVER: Data Warehouse Modelling, OLAP Cube, and PowerBI Reporting

ETL for creating a Data Mart using SSIS on the AdventureWorks dataset.

Create Tables Dynamically from Flat Files and load Data using SSIS Package

Presentation Slide Decks & Demos

Business Intelligence Project

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

SQL Server, Analysis Services, and BI tools are utilized to build a data warehouse, create OLAP reports, and visualize insights. Actions also include finding datasets, defining star/snowflake schemas, populating tables, and designing cubes. Steps, challenges, and solutions are documented, showcasing reports and visualizations for presentation.

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.

This project uses SSIS ETL pipeline to extract data from multiple sources and load it into SQL database.

I store all my personal Data projects here :)

ETL Pipeline using SSIS

An SSIS ETL pipeline that transfers CSV files from FTP server to a Postgres database.

Business Intelligence Workshops

Designing a pipeline in SSIS

Repo for Data Visualization Competition: Analyzing global carbon emissions with Python, SQL, and Power BI

Transforming entertainment analytics with Agence-Fantastic BI Revolution. Using SSIS, SSMS, and Power BI, we empower "Fantastic" with predictive insights and dynamic strategies. Join us in shaping the future of entertainment analytics.