The Excel Unicorn Marathon "Top 10"

The Problem:
- When you have bucket-loads of complex data, how do you narrow down the meaningful insights effectively and efficiently?

The Solution:
- A useful tool is the "Top N" records from the data - where N is any number you'd like to investigate.
- To demonstrate this, let's look at the "Top 10" filters of my favourite sport - running!
- I wrote a PowerBI query to web-scrape all road running data from 1963 to 2022 from www.worldathletics.org.
- This resulted in a unique database of 77 300 data points, where the "Top 10" records were filtered for: Key Metrics, Race Winners, Nationality, and Venue.
- From here we can easily track the top runners of our time, the quickest marathon running times, which courses are the the most conducive for a quick finish, and who are highest ranked runners.

The Data Tool:
- Data preparation and visualization in Power BI.