One of the perks of hosting a node for Speedtest.net is that you gain access to all of the test results that go through that server. 5Nines, a local ISP in Madison, WI, hosts one in Madison and Milwaukee.
In an effort to better understand market performance in Dane County, I gathered millions of records from mobile devices, including iOS, Android, Windows Phone, and “regular” tests performed in a web browser. For this presentation, I isolated only cellular test results and analyzed spatial and temporal performance across four years of data.
ETL was done using Python, utilizing the requests framework to download TSVs from the reporting portal, SQLAlchemy for transforms, and PostgreSQL as the RDBMS.
Big_Data_Meetup (the archive never captured this file)As a bonus, here’s a video showing only LTE tests over time (timestamp can be seen in lower right hand corner):
Here the post embedded a YouTube video. It is still on YouTube: watch it there.
QGIS and the Time Manger plugin where used along with FFmpeg to create this video.