Network Speed Dashboard
The dashboard above is data regarding network speed, latency, and other performance metrics. Below is a list of techniques, technologies, and methodologies used to bring this dashboard to life:
- Data Source
- MySQL – Results from latency and speed testing are stored in a MySQL database
- Data Flow – The MySQL data is uploaded into a Power BI Data Flow 8 times per day
- Data Connection
- PHP – The MySQL database is accessed via a self-written PHP data connector which outputs the data to a CSV file or JSON file
- Data Collection
- Speedtest-cli – Every hour the speedtest-cli command is run with the JSON output which is then parsed and written to the database as above
- Ping – a standard ping command is issued every 5 minutes and the output is parsed and the data is stored in the database as above
- Python – the two tests (speed and ping) are scripted in python to execute, parse, and write to the database