ETL-Project Documentation:

Resources (Folder):

• Retail Data Analytics: https://www.kaggle.com/manjeetsingh/retaildataset

  • Features Data Set ---> Features data set.csv
  • Holidays Data Set ---> holidays.csv
  • Sales Data Set ---> sales data-set.csv
  • Stores Data Set ---> stores data-set.csv

MongoDB ETL (Non-Relational Folder):

• MongoDB ETL Technical Summary Write-Up ---> Walmart MongoDB ETL Doc.docx

• MongoDB ETL Jupyter Notebook ---> weeklysales_markdown_mongodb.ipynb

PostgreSQL ETL (Relational Folder):

• PostgreSQL Technical Summary Write-Up ---> Walmart_PostgreSQL_ETL_Doc.docx

• PostgreSQL ETL Jupyter Notebook ---> postgresql_etl.ipynb

• PostgreSQL Schema (Folder):

  • PostgreSQL retail_db Schema ---> QuickDBD-retail_db.sql

  • PostgreSQL retail_db Schema Image ---> retail_db_schema.png

  • PostgreSQL retail_db Total Weekly Sales w/ Join ---> sql_queries.sql