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.

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

Business Intelligence and Data Warehousing Project

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

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…

Data Warehouse Repositories

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

Building a modern data warehouse with SQL server, including ETL process, data modeling and analysis

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

Constructing a contemporary data warehouse that spans multiple databases, with complete ETL pipelines, structured data models, and robust analytics tools.

Modern data warehouse in SQL Server with GTFS data from Buenos Aires buses and exploratory analysis using Jupyter Notebook, built to facilitate data analysis and to provide clear insights on bus attributes

ETL Pipeline using SSIS

A comprehensive data warehousing and analytics project.