Situation

I wanted to do two things :

1. I wanted to understand how fast the International Space Station travels around the earth

2. I wanted to create an ETL pipeline and visualize 1 hour of traveling time of the ISS

Task

I build an ETL pipeline first by extracting the data through an API, then transformed the data using python(I used the Requests library and Pandas) and then prepared it for a tableau visualization

Action

I wrote a script with several functions, this snippet is of a function that captures the position of the ISS from an API

ISS Tracking - 1 hour over the Earth

• The script bellow asks for the amount of time we want to track the ISS for and the time interval between data points. Finally it outputs a .csv file which then is uploaded to Tableau for visualization

Result

The outcome is a dashboard with the map of the world and the path of the ISS throughout One Hour of flight .
My intention here is to show how incredibly fast the ISS goes around planet earth.