Built a data warehouse on AWS and an ETL pipeline for a database hosted on Redshift. The data is loaded from S3 to staging tables on Redshift and modeled into fact and dimensions tables to perform analytics and obtain meaningful insights.
Created a Postgres database and built an ETL pipeline to optimize queries on song play analysis. The fact and dimension tables for a star database schema for a particular analytic focus are defined, and an ETL pipeline that transfers data from files in two local directories into these tables in Postgres using Python and SQL was developed.
Add a description, image, and links to the dimensions-tables topic page so that developers can more easily learn about it.
To associate your repository with the dimensions-tables topic, visit your repo's landing page and select "manage topics."