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

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

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.

Building Data Warehouse and ETL pipelines using Amazon S3 and Redshift

This is an MSSQL Data Warehouse and manual ETL demo on a specially formatted Water Quality dataset from DEFRA, UK. It is a personal academic-grade exercise to explore the basic concepts of data warehousing and manual ETL process from an academic perspective.

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

Proposta de implementar um sistema ETL robusto na Super Store para otimizar a gestão de dados desestruturados, melhorar a tomada de decisões e fortalecer a vantagem competitiva.

This is an Oracle DB Data Warehouse and manual ETL demo on a specially formatted Water Quality dataset from DEFRA, UK. It is a personal academic-grade exercise to explore the basic concepts of data warehousing and manual ETL process from an academic perspective.

Data Warehouse creation using MySQL and R

Data Engineering on GCP and Mage AI

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

Cube Creation using VIsual Studio, OLAP Reports and Power Bi