baky0905 / data-modeling-with-postgres Goto Github PK
View Code? Open in Web Editor NEWIn this project, as a part of data engineering nanodegree (Udacity) I preformed data modeling with Postgres and built an ETL pipeline using Python. I defined fact and dimension tables for a star schema for a particular analytic focus, and written an ETL pipeline that transfers data from files in two local directories into these tables in Postgres using Python and SQL.