DVD rental ETL

Purpose

The purpose of this project is to practice:

  • Data Modeling
  • Git/Github (with pre-commit)
  • Python & Pandas
  • S3 and Athena

What

The idea is to get this DVD rentals sample database and make a relation model.

From this:

(transactional)

To this:

relational

In these steps:

steps

How

In each folder one can find a README file explaing how I thought and did each step.