Skip to content

mous-mhz/postgresql-dwh

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Overview

This project demonstrates a comprehensive data warehousing and analytics solution using PostgreSQL, from building a data warehouse to generating actionable insights. Designed as a portfolio project, it highlights industry best practices in data engineering and analytics with a medallion architecture.

Features

Data Warehouse: PostgreSQL-based with Bronze, Silver, and Gold layers. ETL Pipelines: Automated data extraction, transformation, and loading using Python and SQL. Analytics: Actionable insights derived via SQL queries and visualizations. Best Practices: Data quality checks, modular design, and documentation.

About

Building a data warehouse with postgresql, ETL, data modeling

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors