Villo! Power BI Real Time Report

Browsing the web i found an interesting dataset created by Opendata , it’s the rea time avability of Villo! bicycle station in some cities fo Europe. I used it to created this report:

Immagine 106.png

I Try to explain how i do it!

First the dataset

If you go to this link you found the dataset. Location of the Villo! stations in the Brussels Capital Region with indication of the availability (bikes, bike stands) in real time. The table i very simple:

Immagine 107.png

We have this attribute:

  • Name of station
  • address of station
  • position by latitute and longitude
  • Status
  • Contract ( itis the city name)
  • NUmber of bike stand
  • available bike stand
  • available bike
  • Last Update

If you want you can click on export and have the tabular form of this data bu i prefered use API service. If you use Api you can read their document and filter data as you wish. i have used this api link:

https://public.opendatasoft.com/api/records/1.0/search/?dataset=jcdecaux_bike_data&rows=10000&sort=last_update&facet=banking&facet=bonus&facet=status&facet=contract_name&facet=position

This query return 10000 rows of data  from different contracts.

How To use it?

Simple with power Bi!

  1. Open Power bi
  2. Select Other as data source and Web
  3. Insert the API link
  4. select Anonymous credential and click ok.

CreateConnection

After that you can play with your data. if you don’t want to waste your time to prepare you data it’s my power query code.

And now?

Play with your dataset and create your perfect Report. If you refresh your data you have the latest data about Villo! and Try my version

 

Annunci

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...