MDSH14/Data-Modeling-with-Postgres

In this project, I am using data modeling with Postgres and to build an ETL pipeline using Python. I am defining fact and dimension tables for a star schema for a particular analytic focus, and writing an ETL pipeline that transfers data from files in two local directories into these tables in Postgres using Python and SQL.

Jupyter Notebook