The ETL project was a group assignment completed in a week’s time. Myself and one other classmate were tasked with sourcing data based on a topic we chose, transform the data to the specifications we were looking for, and loading the transformed data into JSON and sqlite3 formats.

My partner and I chose NFL Draft data for quarterbacks starting in 2004-2015. We also compiled stats per game per quarterback. The data was averaged, total games played calculated and added to the data, and combined to one table.

The ultimate goal was to design a front-end page that users could then search by either draft year or quarterback name and receive the data. Due to time constraints we were unable to link the front and back ends, but this exceeded the expectations of the project and was not necessary.

Please click here to view the ETL project on GitHub.