Visual Tracert: How to use GeoTraceroute to analyze, visualize and embed internet traffic routes

Visual traceroute from Frankfurt to Ukraine shows redirection via Russia
Visual traceroute (aka. tracert) from Frankfurt to Ukraine shows redirection via Russia

Earlier today I read the news from NetBlocks (via Reuters) that since the weekend parts of the Ukrainian internet traffic are rerouted via Russia. To be precise, it’s about Ukrainian Kherson Oblast, which is occupied by Russia since March.

Now I wanted to trace the internet route myself and ideally visualize it. Here I came across the service of GeoTraceroute, which does a great job in visualizing traceroutes (aka. tracert). For the trace, I chose Frankfurt as starting point, and skynet.ua, the local internet provider in Kherson, as the endpoint.

Of course, you can also include the URL of GeoTraceroute as a web element in your Power BI report or Tableau dashboard and parameterize it for dynamic interactions. You can see the format as in my example:

https://geotraceroute.com/?node=2021&host=skynet.ua

Our Research featured in Der Spiegel: An Overview of Russia’s Cyberattack Activity in Ukraine

Der Spiegel features Microsoft AI for Good Research Lab Ukraine report
Der Spiegel features Microsoft AI for Good Research Lab Ukraine report

Our research was picked up by German news magazine Der Spiegel, one of the largest investigative journals in Europe. We analyzed incredibly large amounts of data to gain insights into Russia’s cyberattacks in Ukraine.

Read the Spiegel article, which in turn has a link to our report: Microsoft zählt bisher 237 Hackerangriffe auf die Ukraine

And here’s a direct link to the underlying report, which was produced by Microsoft’s Digital Security Unit and is based on insights from the Microsoft Threat Intelligence Center and data analysis from our Microsoft AI for Good Research Lab: Special Report: Ukraine – An overview of Russia’s cyberattack activity in Ukraine

Thank you fellow Microsofties, Merry Christmas and a Happy New Year 2022

Alexander Loth's Microsoft Achievements: the book Decisively Digital with a personal note from Satya Nadella
Alexander Loth’s Microsoft Achievements: the book Decisively Digital with a personal note from Satya Nadella

As we approach the end of 2021, I would like to take a moment to reflect on the incredible achievements we’ve made at Microsoft and to extend my heartfelt gratitude to my fellow Microsofties.

❤ My dear fellow Microsofties, I have learned a lot from you and would like to thank you for the great teamwork, it was a lot of fun! This year I was able to achieve an incredible amount thanks to your support and the omnipresent growth mindset at Microsoft.

Key Milestones and Microsoft Achievements

🔬 Mixed Reality for Life Sciences: This year, we elevated mixed reality for our life sciences customers like Ottobock, making the world more inclusive and healthier.

📚 Literary Accomplishments: As you may know, I love to write. I was able to finish two book projects: for the book Decisively Digital, I interviewed 24 thought leaders on Digital Transformation. We also finished the German-language book Datenvisualisierung mit Power BI.

🎓 Technical Leadership Development Program (TLDP): Graduating from TLDP, a sort of tech MBA, was a fantastic experience, enhancing my next-gen tech focus.

👾 Microsoft Global Hackathon Award: Together with over 40 colleagues, we won an award at Microsoft Global Hackathon, the world’s largest privately-organized hackathon. Patent pending!

🐦 15,000 Followers on Twitter: Reaching this significant milestone reflects not only my journey in data and digital strategy but also the power of community engagement. Catch up on my journey to 15k Twitter followers here.

Stay Connected: Follow Me for More Insights

Keep up with my insights and adventures in the tech world by following me on Twitter and LinkedIn.

🎄 Now it’s really time for some reflective days. Merry Christmas and a Happy New Year to all of you! I’m sure 2022 will be a blast…

Microsoft Global Hackathon 2021 Award Winner

Microsoft Global Hackathon 2021 Award Winner Ceremony

The Microsoft Global Hackathon is the world’s largest private hackathon. This year’s hackathon witnessed participation from 67,633 hackers from 92 countries working on 6,394 projects.

I am very pleased to announce that the project I led during the Microsoft Global Hackathon 2021 was awarded for the Hack for Hybrid Work Executive Challenge. The focus of this challenge was on using data and technology to help make #hybridwork more inclusive, effective, and fun!

Now I’m very excited to see what our hack will look like in the final product and how it will influence a healthy lifestyle. A patent for the project has already been filed. (That would be my very first patent! 🙂 )

In total, 46 hackers across many time zones worked on this project. Congratulations to the great team – I will always value the opportunity to work with you on such a meaningful project:

Datenvisualisierung mit Power BI: das essenzielle Power BI-Buch ist jetzt erhältlich

Das deutschsprachige Power BI-Buch ist ab sofort im Handel erhältlich
Das deutschsprachige Power BI-Buch ist ab sofort im Handel erhältlich

Die Welt der Datenvisualisierung ist um ein wertvolles Werk reicher: Unser Power BI-Buch, Datenvisualisierung mit Power BI: Der schnelle Einstieg in die Welt von Power BI, ist jetzt im Handel verfügbar! Dieses umfassende Buch dient als Brücke zwischen Technologie und Geschäftsverständnis. Es wurde speziell entwickelt, um sowohl Einsteigern als auch erfahrenen Anwendern eine robuste Basis für den effektiven Einsatz von Power BI zu bieten.

Das Buch ist ab sofort erhältlich bei:

  • Ihrer lokalen Buchhandlung,
  • Amazon (als gedrucktes Buch und als Kindle Edition)

Datenvisualisierung mit Power BI tritt nun in die Fußstapfen seines erfolgreichen Schwesterwerks Datenvisualisierung mit Tableau. Dabei wurde das didaktische Konzept sorgfältig übernommen, ohne die spezifischen Merkmale und Funktionen von Power BI aus den Augen zu verlieren.

Ein herzliches Dankeschön geht an meinen Co-Autor Peter Vogel sowie an Sophia Cullen und Thomas Treml für die Vorworte. Ebenfalls möchten wir unseren zahlreichen Reviewern danken, die uns mit ihren wertvollen Ideen und Anregungen unterstützt haben.

Für weitere Informationen zu „Datenvisualisierung mit Power BI“ besuchen Sie bitte die Webseite zum Power BI-Buch! Wir freuen uns auch über Feedback, Ideen und Anregungen via LinkedIn: