{"id":274,"date":"2022-01-01T16:34:06","date_gmt":"2022-01-01T21:34:06","guid":{"rendered":"https:\/\/cv.lucasrobb.com\/?page_id=274"},"modified":"2022-12-06T18:32:49","modified_gmt":"2022-12-06T23:32:49","slug":"portfolio","status":"publish","type":"page","link":"https:\/\/cv.lucasrobb.com\/index.php\/portfolio\/","title":{"rendered":"Portfolio"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Network Speed Dashboard<\/h3>\n\n\n\n<iframe loading=\"lazy\" title=\"Net Speeds\" width=\"100%\" height=\"525\" src=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiYzA4NjA0OGQtNzNjYS00ZTc1LTgxMDctYTUwYTgyYjNmYjU2IiwidCI6IjExZDA0YTBkLTVhZjAtNDA2MS1hZWQ5LTg5MzVkMTJmOTJhNSJ9&amp;pageName=ReportSection\" frameborder=\"0\" allowfullscreen=\"true\"><\/iframe>\n\n\n\n<p>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:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Data Source\n<ul class=\"wp-block-list\">\n<li>MySQL &#8211; Results from latency and speed testing are stored in a MySQL database <\/li>\n\n\n\n<li>Data Flow &#8211; The MySQL data is uploaded into a Power BI Data Flow 8 times per day<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Data Connection\n<ul class=\"wp-block-list\">\n<li>PHP &#8211; The MySQL database is accessed via a self-written PHP data connector which outputs the data to a CSV file or JSON file<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Data Collection\n<ul class=\"wp-block-list\">\n<li>Speedtest-cli &#8211; Every hour the speedtest-cli command is run with the JSON output which is then parsed and written to the database as above<\/li>\n\n\n\n<li>Ping &#8211; a standard ping command is issued every 5 minutes and the output is parsed and the data is stored in the database as above<\/li>\n\n\n\n<li>Python &#8211; the two tests (speed and ping) are scripted in python to execute, parse, and write to the database<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Fuel Mileage Report &#8211; Coming Soon<\/h3>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Network Speed Dashboard The dashboard above is data regarding network speed, latency, and other performance metrics. Below is a list<\/p>\n<p><a href=\"https:\/\/cv.lucasrobb.com\/index.php\/portfolio\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\">Portfolio<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-274","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/cv.lucasrobb.com\/index.php\/wp-json\/wp\/v2\/pages\/274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cv.lucasrobb.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cv.lucasrobb.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cv.lucasrobb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cv.lucasrobb.com\/index.php\/wp-json\/wp\/v2\/comments?post=274"}],"version-history":[{"count":16,"href":"https:\/\/cv.lucasrobb.com\/index.php\/wp-json\/wp\/v2\/pages\/274\/revisions"}],"predecessor-version":[{"id":319,"href":"https:\/\/cv.lucasrobb.com\/index.php\/wp-json\/wp\/v2\/pages\/274\/revisions\/319"}],"wp:attachment":[{"href":"https:\/\/cv.lucasrobb.com\/index.php\/wp-json\/wp\/v2\/media?parent=274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}