20 Years | Tracking dashboard

In an earlier blog, we announced that this year, to celebrate our 20th anniversary, we are getting on our bikes and heading for Aarhus. We'd love to give our customers and business contacts the chance to follow our bike ride to Aarhus. That is why our colleagues Niek Guijt and Ben van der Helm used GPS trackers to build a tracking dashboard in Microsoft Power BI. In this dashboard, you can follow the different groups on their journey.

E-mergo is going to Aarhus

The reason we're cycling to Aarhus is that our partner TimeXtender was founded in that city. As TimeXtender Partner of the Year (2019&2020), we thought it would be fun to cycle there for our 20th anniversary. We will set off from our office in Delft on Wednesday 29 September, so that we arrive in Aarhus on the day of our anniversary. Read more about the journey here.

We'd love to give our customers and business contacts the chance to follow our bike ride to Aarhus. That is why our colleague Ben, using GPS trackers (read more about the GPS trackers here), built a dashboard in Power BI together with colleague Niek. In this dashboard, you can follow the group of cyclists at any moment. The cyclists are also supported by an equipment van and a camper. Both are also fitted with a GPS tracker, so they can be followed in the dashboard too.

But not everyone is cycling to Aarhus. Besides the group of cyclists, there are also two groups travelling by car to Hamburg and Legoland on their way to Aarhus. These two groups are also equipped with a GPS tracker. In total, there are around 5 groups to follow in the dashboard, so you can easily see where everyone is at any given moment. That's fun for customers and business contacts as well as for our colleagues themselves.

What do you see in the dashboard?

On the dashboard's ‘General info’ landing page, you'll see a map tracking the route covered by the E-mergo employees on their trip to Aarhus. Colours on this map show where each group has been and where they are now. Although there are several groups, the visuals on the right-hand side of the pages focus on our cyclists. The ‘Speed’ visual tracks the cyclists' speed and also shows a line marking 25 km/h, making it easy to see whether the cyclists are going faster or slower than expected. Below this visual, you'll see the top speed reached and the average speed of the cyclists. Further down, there is a gauge visual showing how much distance the cyclists have covered compared with the goal. The goal of 856 km is arriving in Aarhus. Finally, at the top of the page you'll see various filters that can be used to adjust the page to your preferences. Next to the filters, you'll also see the ‘Route info’ button, which takes us to the second page.

The second page, ‘Route info’, looks a lot like the first, but is actually very different! On this page, you'll find more information about the cyclists in relation to the route and the schedule. The map visual therefore only shows the cyclists, the route and the stopovers. At the top of the page, we again see a filter, but this time for the cyclists themselves. When you select a cyclist, you'll only see the cycling route and the distance covered by that cyclist. In the top right, you'll also see how the cyclists are performing against the original schedule. Below that, you'll see an analysis of the route, which goes into more detail on plan versus reality. Further down, various KPIs about the cyclists are displayed. The recommended speed is based on how fast the cyclists would need to ride to arrive in line with the original schedule. Finally, in the bottom right, you can see who is currently cycling.

Tracking dashboard

Open the dashboard in a new tab

Want to stay up to date on our adventure?

Would you like to stay up to date on our bike ride to Aarhus? Then follow us on LinkedIn or Instagram.

LinkedInInstagram

E-mergo & TimeXtender