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

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.

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…

Production-ready data pipeline with Jupyter notebook, SQLite database modeling (star schema), and automated ETL workflows for customer churn analysis and segmentation.

Complete materials for "Data Warehousing and Modeling" uni course: lectures (Inmon, Kimball, Dimensional Modeling, NoSQL), PostgreSQL labs (Star Schema), exam questions, and practical SQL solutions.

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.

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.

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.

End-to-end ETL and data warehouse pipeline implementing star schema design, SCD Type 2 dimensions, and fact tables for analytical reporting. Built with SQL and structured for scalable analytics.

This project presents a complete Data Warehouse & ETL solution for analyzing European football leagues across multiple seasons.

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

A dimensional data warehouse and ETL pipeline for analyzing movie rental activity, revenue, customer behavior, store performance, and inventory availability.

Data Warehouse creation using MySQL and R

Data Engineering on GCP and Mage AI

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

This project showcases how i helped VelociMart shift from Excel-based reporting to a robust data infrastructure using SQL Server and Tableau. Built around Sales, Customers, and Products Data Marts, it follows the Medallion Architecture (Bronze → Silver → Gold) to deliver clean, analysis-ready views for effective business insights.

Cube Creation using VIsual Studio, OLAP Reports and Power Bi