Simple ETL Project for beginners

Setting up PostgreSQL using docker

Vasav

1 minute read

Python Tutorial

  1. Corey Schafer - python basics
  2. Data School - pandas

Pandas Tutorial

  1. pandas - practice
  2. Corey Schafer - pandas
  3. first-python-notebook

Docker resources

  1. techgeekbuzz
  2. why docker
  3. learn-docker

Cheatsheets

  1. pandas - uidaho
  2. pandas - dev
  3. python-scheatsheet

ETL Task

  1. Extract data from the data source cricket
  2. Transform the data into tablular format
  3. postgres with docker
  4. Optional: create a dashboard either using apache superset, metabase or streamlit