{"id":316,"date":"2020-12-03T11:07:09","date_gmt":"2020-12-03T07:37:09","guid":{"rendered":"http:\/\/mahshad.pro\/?p=316"},"modified":"2022-01-08T20:12:40","modified_gmt":"2022-01-08T16:42:40","slug":"reporting-dashboard-torontos-covid-19-data-visualization-using-power-bi","status":"publish","type":"post","link":"https:\/\/mahshad.pro\/?p=316","title":{"rendered":"Reporting dashboard: Toronto&#8217;s COVID-19 data visualization using Power BI"},"content":{"rendered":"\n<p>Data visualization plays a crucial role in conveying the covert message laid in the large amounts of data to the audience. Not only the message should be right to the point and easy to understand, visualization should be designed according to the needs of the audience. Questions such as &#8220;who&#8221; will be looking at the visualization and &#8220;why&#8221; are we making such visualization should be asked at the first place which leads the designer to gain an understanding over the user, and to design the report to fulfill users&#8217; needs and preferences in an appropriate fashion.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"607\" src=\"http:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_2-1024x607.jpg\" alt=\"\" class=\"wp-image-319\" srcset=\"https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_2-1024x607.jpg 1024w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_2-300x178.jpg 300w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_2-768x455.jpg 768w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_2-1870x1109.jpg 1870w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_2-400x237.jpg 400w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_2-800x474.jpg 800w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>In this visualization, the City of Toronto&#8217;s COVID-19 dataset is analyzed through different points of view. A location-based evolvement is visualized to represent how was the spread evolved  through the weeks of the year.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"607\" src=\"http:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_3-1024x607.jpg\" alt=\"\" class=\"wp-image-318\" srcset=\"https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_3-1024x607.jpg 1024w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_3-300x178.jpg 300w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_3-768x455.jpg 768w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_3-1870x1109.jpg 1870w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_3-400x237.jpg 400w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_3-800x474.jpg 800w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Other insights such as different sources of infection, Age and outcome, and outbreak associated cases are also available in different pages for further analysis:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"607\" src=\"http:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_4-1024x607.jpg\" alt=\"\" class=\"wp-image-320\" srcset=\"https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_4-1024x607.jpg 1024w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_4-300x178.jpg 300w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_4-768x455.jpg 768w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_4-1870x1109.jpg 1870w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_4-400x237.jpg 400w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_4-800x474.jpg 800w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"607\" src=\"http:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_5-1024x607.jpg\" alt=\"\" class=\"wp-image-321\" srcset=\"https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_5-1024x607.jpg 1024w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_5-300x178.jpg 300w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_5-768x455.jpg 768w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_5-1870x1109.jpg 1870w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_5-400x237.jpg 400w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_5-800x474.jpg 800w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"607\" src=\"http:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_6-1024x607.jpg\" alt=\"\" class=\"wp-image-322\" srcset=\"https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_6-1024x607.jpg 1024w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_6-300x178.jpg 300w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_6-768x455.jpg 768w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_6-1870x1109.jpg 1870w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_6-400x237.jpg 400w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_6-800x474.jpg 800w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"607\" src=\"http:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_7-1024x607.jpg\" alt=\"\" class=\"wp-image-323\" srcset=\"https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_7-1024x607.jpg 1024w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_7-300x178.jpg 300w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_7-768x455.jpg 768w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_7-1870x1109.jpg 1870w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_7-400x237.jpg 400w, https:\/\/mahshad.pro\/wp-content\/uploads\/COVID-19-in-Toronto-Nov_Page_7-800x474.jpg 800w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>The live dynamic version of the dashboard can be accessed here:<\/p>\n\n\n\n<p><a href=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiMjMwMzdlYzgtMDgxMy00YmIxLWEyNmEtZTlhOTE3Y2Q1Nzg4IiwidCI6ImZmNTk2YTk3LTg3NTItNDAzMy1iNDZmLWRjMjgwNWVjZmRiZSJ9&amp;pageName=ReportSection8784dc9a7058055700c3\">COVID-19 in the City of Toronto Dashboard<\/a><\/p>\n\n\n\n<p>Data Source: <a href=\"https:\/\/open.toronto.ca\/dataset\/covid-19-cases-in-toronto\/\">Toronto Open Data<\/a><\/p>\n\n\n\n<div style=\"width:100%; padding-bottom:56.25%; position:relative;\">\n  <iframe src=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiMjMwMzdlYzgtMDgxMy00YmIxLWEyNmEtZTlhOTE3Y2Q1Nzg4IiwidCI6ImZmNTk2YTk3LTg3NTItNDAzMy1iNDZmLWRjMjgwNWVjZmRiZSJ9&#038;pageName=ReportSection8784dc9a7058055700c3\" style=\"position:absolute; top:0px; left:0px; \n  width:100%; height:100%; border: none; overflow: hidden;\"><\/iframe>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>City of Toronto COVID-19 data reporting dashboard using Power BI<\/p>\n","protected":false},"author":1,"featured_media":326,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[40],"tags":[],"class_list":["post-316","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-works","has-thumbnail"],"_links":{"self":[{"href":"https:\/\/mahshad.pro\/index.php?rest_route=\/wp\/v2\/posts\/316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mahshad.pro\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mahshad.pro\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mahshad.pro\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mahshad.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=316"}],"version-history":[{"count":4,"href":"https:\/\/mahshad.pro\/index.php?rest_route=\/wp\/v2\/posts\/316\/revisions"}],"predecessor-version":[{"id":482,"href":"https:\/\/mahshad.pro\/index.php?rest_route=\/wp\/v2\/posts\/316\/revisions\/482"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mahshad.pro\/index.php?rest_route=\/wp\/v2\/media\/326"}],"wp:attachment":[{"href":"https:\/\/mahshad.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mahshad.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mahshad.pro\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}