Data Engineering Project - Python, PySpark & SQL - Azure Data Factory (ADF), DataBricks, Synapse Analytics, Azure Data Lake Storage (ADLS) Gen2, Power BI, Tableau and Looker Studio

A Coding Factory @ AUEB - SQL Project. - Final Project - Camping Database

Using ETL process to Extract, Transform, and Load local data into a PostgreSQL database

This is an Oracle DB Data Warehouse and ETL implementation on specially formatted Water Quality dataset from DEFRA, UK

Data Warehouse creation using MySQL and R

Data Engineering on GCP and Mage AI

Cube Creation using VIsual Studio, OLAP Reports and Power Bi

In this project, I'll apply what I've learned on data modeling with Postgres and build an ETL pipeline using Python. To complete the project, I will define the fact and dimension tables for a star schema for a particular analytic focus, and write an ETL pipeline that transfers data from files in two local directories into these tables in Postgre…

Data Vault model for analyzing the flight activity and reservation processes of a major airline company. Provides SQL scripts, queries, and reports for gaining insights into business operations and improving performance.

This is an MSSQL Data Warehouse and ETL implementation on specially formatted Water Quality dataset from DEFRA, UK

Building Data Warehouse and ETL pipelines using Amazon S3 and Redshift

Irish Property Price Register transformed into a data warehouse via an EtLT pipeline.

This is a business intelligence project on analyzing super market data. Check out the README file for more details.