An example of what you can accomplish by using real time data
This use case is not restricted to ship traffic, but we see that this solution could be used for other industries, such as car and bike rental services, asset tracking for anti-theft solutions, following customer journeys in stores or tracking pets.
The aim of the project was to present a case where we use an API with real time data. For this purpose I used an API provided by the Norwegian Coastal Administration showing the position of all ships in the Norway coasts and sea area.
The data is fetched from Barentswatch API (https://www.barentswatch.no/en/articles/open-data-via-barentswatch/) every hour, read as json files and uploaded to our SQL database. From there the data is visualized in a map in a Power BI dashboard, so that you anytime can access the position of all ships outside Norway. Besides keeping track of all ships and see nice animations of moving ships, the data can also be used to answer questions like how many ships are moving and how many are standing still, where are we expecting heavier traffic, how many ships do we predict to be at sea or at a specific location at a specific timepoint, or when do we expect a ship to reach it’s destination.
ANNA LUNDMARK
Anna has 8+ years of experience in processing and structuring data, machine learning, and analysis of large-scale data. She has experience from working with various types of data in different industries, and she finds motivation in expanding her knowledge and learning new things.
Anna has a certification in Azure Data Engineering and her goal is to broaden her skillset within Data Engineering.
