A comprehensive guide to building a modern data warehouse with SQL Server, including ETL processes, data modeling, and analytics.

This repository contains analysis of IMDB data from multiple sources and analysis of movies/cast/box office revenues, movie brands and franchises.

DIRECT, the Data Integration Run-time Execution Control Tool, is a data logistics control framework that can be used to monitor, log, audit and control data integration / ETL processes.

Business Intelligence and Data Warehousing Project

Starter project for building an ETL pipeline using SSIS in Visual Studio 2019

CWTS OpenAlex ETL data pipeline.

This repository contains analysis of IMDB data from multiple sources and analysis of movies/cast/box office revenues, movie brands and franchises

Design and Implementation of a data warehouse on the "Northwind" database.

This repository contains all the assignments, workshops and mini-projects of course - DAMG7370 Designing Advanced Data Architectures for Business Intelligence

Data Warehouse Repositories

Designed Multi Star schema with 10 Fact & 33 Dimension tables & developed Data Integration Pipeline by ETL workflow to load all tables (380M+ rows) from multiple sources such as CSV, MySQL, MSSQL & PostgreSQL by using Talend. Implemented Data Profiling, Error Handling, Load Statistics, Cleansing and Performance Tuning to address data quality gap…

Repository for tutorials, information, notes and projects about data engineering.

Modeling a database using the Star Schema, applied to the context of "CFB Pharmacy", which seeks to develop decision support systems for revenue analysis. The project was carried out in two stages: (A1) involved the creation of the relational and conceptual model; (A2) focused on the implementation of the dimensional model and Data Warehouse (DW).

ETL Pipeline using SSIS

Project involves merging customer reviews from Fudgemart and FudgeFlix to create a unified data warehouse using Kimball's approach. Utilizing Power BI, it aims to extract actionable insights for Fudge Inc., guiding strategic decisions, product enhancements, and market expansion based on comprehensive business intelligence.

This repository contains modeling of the Sakila ERD to a star schema using the Kimball approach and performs ETL (Extract, Transform, Load) from the source ERD to the destination star schema to optimize BI queries.

Data warehouse project for imaginary huge online learning company - WiseWay

Build a Real-Time Streaming ETL Pipeline with Apache Kafka, Kafka Connect, and ksqlDB

This project is a complete Sales, Customers, and Products Data Mart built in SQL Server, structured following Medallion Architecture (Bronze → Silver → Gold). Showcases the end-to-end process of designing a scalable data warehouse by transforming raw transactional data into clean, analysis-ready views, for visualization via Tableau Public.