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 ETL implementation on specially formatted Water Quality dataset from DEFRA, UK
A Coding Factory @ AUEB - SQL Project. - Final Project - Camping Database
This is an Oracle DB Data Warehouse and ETL implementation on specially formatted Water Quality dataset from DEFRA, UK
Using ETL process to Extract, Transform, and Load local data into a PostgreSQL database
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
Data Warehouse creation using MySQL and R
Data Engineering on GCP and Mage AI
Cube Creation using VIsual Studio, OLAP Reports and Power Bi
Add a description, image, and links to the fact-table topic page so that developers can more easily learn about it.
To associate your repository with the fact-table topic, visit your repo's landing page and select "manage topics."