GitHub - radatu/Crowdfunding-ETL_Ch8: Crowdfunding-ETL DU-VIRT-DATA-PT-10-2022-U-B-MW—Module 8 Challenge—PostgreSQL database and tables—Python 3.9.13

Crowdfunding-ETL DU-VIRT-DATA-PT-10-2022-U-B-MW—Module 8 Challenge—PostgreSQL database and tables—Python 3.9.13

Tasks performed include: Extracting and transforming the data from the large Excel file into four separate CSV files

Creating a PostgreSQL database and tables by using an ERD

Loading the CSV files into the database

Performing SQL queries to generate reports for stakeholders

Name		Name	Last commit message	Last commit date
Latest commit History 9 Commits
.ipynb_checkpoints		.ipynb_checkpoints
.DS_Store		.DS_Store
Crowdfunding_database_setup.ipynb		Crowdfunding_database_setup.ipynb
Extract_Transform_final_code.ipynb		Extract_Transform_final_code.ipynb
QuickDBD-Crowdfunding ETL Challenge.png		QuickDBD-Crowdfunding ETL Challenge.png
README.md		README.md
backer_info.csv		backer_info.csv
backer_info_parsed.csv		backer_info_parsed.csv
backers.csv		backers.csv
campaign.csv		campaign.csv
category.csv		category.csv
crowdfunding.xlsx		crowdfunding.xlsx
crowdfunding_SQL_Analysis.sql		crowdfunding_SQL_Analysis.sql
crowdfunding_db_schema.sql		crowdfunding_db_schema.sql
email_backers_remaining_goal_amount.csv		email_backers_remaining_goal_amount.csv
subcategory.csv		subcategory.csv

Provide feedback