Connecting Ships Data API to Microsoft Power BI for Data Analytics

Apr 19, 2021 | API Knowledge zone, Maritime API

Connecting Power BI to Ships Data API

There are multiple ways how to make a use of Maritime Data by analyzing it in PowerBI or any other data analytics program. You can choose either uploading a static excel sheet and analyze the current statistics about the vessels and maritime ports or you can yous Maritime Data API to connect to your PowerBI project.

One of the major benefits of connecting an API rather than an excel sheet is that it is much faster for the analytics formulas and operations to be processed as it loads data directly from the source rather than going though a heavy excel sheet.

Second Maritime Data API benefit for ships data analytics is data continuity that is always up to date. You get the freshest updated information and can watch current and historical maritime data trends in your PowerBI project.

Ideas for your Power BI Ships API Data Analytics Project

  1. Analyze real – time ships movements with Maritime API and PowerBI
  2. Analyze historical vessel trends moves with Maritime API and PowerBI
  3. Create a maritime traffic map with Maritime API and PowerBI
  4. Gather descriptive statistics on active vessels
  5. Analyze maritime ports in the world
  6. Map vessel trends and behaviours
  7. Create maritime vessel data clusters for analyzing data trends
  8. Forecast vessel movements and traffic
  9. Understand global maritime logistics movement
  10. Analyze global ocean and sea polution based on ships movements.

 Having these things im mind, lets see how to actually connect Power BI with ships data from Datalastic Database

Microsoft Power BI and Datalastic
Datalastic Maritime Data API

How to Connect Ships API to Microsoft Power BI for a Data Analytics Project? 

1. Get Data from another source

After you download and install your Power BI application, this is the first windows that you see. Power BI will offer you to add a data source to your report. To add an API you will simply need to click “Add data from another source ->” to add Datalastic Maritime API or any other data API.

Power BI Connecting an API to Power BI

2. Choose Web Source to add API to your Power BI Project

After step 1, by clicking “Add from another source” you will see this pop-up with very extensive data sources connections. Go to “Get Data” and choose “Other” and “Web” to add a data API. 

Choose Web Source to add Maritime API to Power BI

3. Basic Connection of Ships API with Power BI

The next pop-up that you will see will be a Basic or Advanced setup. Generally, the basic setup is enough for Datalastic API to pair with Microsoft Power BI. Just add the URL (endpoint) that you require as instructed in Datalastic API reference.  Add your key and desired vessel to be tracked and you are good to go. If this step works, please, proceed to step 5 in this instruction If it doesn’t, then we should try setting up the connection via an Advanced setup (step 4).

Basic URL add Maritime API to Power BI

3. Advanced Connection of Maritime API with Power BI

 

Add the desired URL (endpoint) with the data type that you would like to connect to Power BI. 

To help Power BI recognizing your API key for Datalastic add ATTP request header parameter with your API key. 

 

Add “Authorization” and Bearer with your API key as in the example on the right. 

 

 

Advanced URL add Maritime API to Power BI

5. Start with Maritime Data Analytics with Power BI

After connecting Power BI with Datalastic Maritime API you are good to go to analyze, process and forecast maritime traffic and to withdraw your own conclusions about vessel industry. 

Vessel Data API connected to Microsoft Power BI

Instantly Get your Maritime API key

Choose your plan

Choose the API plan that fits to your needs

Subscribe

Proceed to the payment and subscribe to the chosen plan

Get your API by email

You will recieve your API key by email. Go ahead and start using it!

Read Other Maritime Articles 

Historical Vessel Tracking Data

Historical Vessel Tracking Data

In this article, we will talk about our Historical Ship Tracking API, possible use cases, types of data the API covers, available API endpoints/filters, and how to subscribe to get started in minutes. We will address to the importance of maritime data and maybe...

Ship Types in Database

Ship Types in Database

Datalastic offers a detailed, extensive vessel information database that covers a very large variety of ship types. We aim to make sure you will find the exact type of vessel information using the database that is available either for one-time download or can or as...

5 Types of Data Endpoints in Datalastic Maritime API

5 Types of Data Endpoints in Datalastic Maritime API

Datalastic provides multiple maritime data endpoints that allow you to retrieve the data from the Datalastic database and further use it for data analysis, applications, software, platforms, and so on.   Datalastic Endpoints: Vessel Information API Maritime Port...

Top 5 Maritime News, Blogs & Magazines

Top 5 Maritime News, Blogs & Magazines

The following list of the best maritime magazines, news, and blog providers is independent and it is selected by Datalastic opinion. Datalastic doesn't own or does not have any formal relationship with any of the mentioned news providers. The following magazines do...

Maritime Data Quality

Maritime Data Quality

Maritime data quality is the key question for any database provider. How to make sure that the vessel data provided is reliable, frequent, and serves the needs in the maritime industry. What is Maritime Data? Maritime data is big data information collected from...

How to Get Maritime Traffic Data?

How to Get Maritime Traffic Data?

Datalastic REST API web services contain historical maritime information, real-live marine traffic overview and future ships traffic forecast.