<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Odunayo Ajayi on Medium]]></title>
        <description><![CDATA[Stories by Odunayo Ajayi on Medium]]></description>
        <link>https://medium.com/@odun.arowolo?source=rss-31fde77e4988------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*hBi7dQOMOCTiQCLZ5Vwb9A.jpeg</url>
            <title>Stories by Odunayo Ajayi on Medium</title>
            <link>https://medium.com/@odun.arowolo?source=rss-31fde77e4988------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 19:48:57 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@odun.arowolo/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[COVID-19 Dashboard]]></title>
            <link>https://medium.com/@odun.arowolo/covid-19-dashboard-e9b8960ddab9?source=rss-31fde77e4988------2</link>
            <guid isPermaLink="false">https://medium.com/p/e9b8960ddab9</guid>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[covid19]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Odunayo Ajayi]]></dc:creator>
            <pubDate>Thu, 12 Nov 2020 15:47:14 GMT</pubDate>
            <atom:updated>2020-11-12T15:47:14.541Z</atom:updated>
            <content:encoded><![CDATA[<p>On 12th February 2020, <a href="https://twitter.com/WHO/status/1227246758196998145?s=20">WHO</a> named a new virus as SARS-CoV-2 also known as COVID-19. Since then, the world has been battling with a pandemic and looking for various ways to contain the current high death rate and minimize contagion.</p><p>The dashboard below visualizes key global metrics that summarizes the impact of the disease on people’s lives. Some of the indicators captured are: total number of cases, total deaths, mortality rate, growth rate from the previous month, top 10 countries with the highest number of cases, top 10 countries with the highest number of deaths and daily count.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uh_Fb4lBhPxZtnmVCcqRRA.png" /><figcaption>COVID-19 Dashboard /Data Source: data.europa.eu</figcaption></figure><p>Below are the 5 steps I took to create the dashboard:</p><p><strong>Step 1: </strong>I reviewed The COVID-19 <a href="https://data.europa.eu/euodp/en/data/dataset/covid-19-coronavirus-data">data</a> collected by European Center for Disease Prevention and Control. They collect the data on a daily basis on the number of COVID-19 cases and deaths, based on reports from health authorities worldwide.</p><p><strong>Step 2: </strong>Due to large size of the dataset(55,439 observations and 12 attributes), I imported the COVID-19 csv <a href="https://data.europa.eu/euodp/en/data/dataset/covid-19-coronavirus-data">data</a> into a google sheet using the script editor.</p><p><strong>Step3: </strong>I connected my google sheet server data source to Tableau desktop.</p><p><strong>Step 4: </strong>In Tableau desktop, I carried out an audit on the 55,439 observations and 12 attributes of the data to ensure accurate count of the cases and deaths are correct as well as filter the population on a specific date to avoid duplicate count.</p><p><strong>Step 5: </strong>I used Tableau Desktop to generate the following graphs and compiled them into into a dashboard:</p><p>The World Map shows the count of cases in all countries in the world. USA, Brazil and India have the highest cases indicated by 3 large red bubbles. It also interesting to see that African countries have very low number of cases.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hRk3ElYctkFkq89AR23xzQ.png" /><figcaption>World Map showing all countries in the world and their current count of cases/ Data Source: data.europa.eu</figcaption></figure><p>Cases and Deaths by Country show the top 10 countries with highest number of cases and deaths in the world.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NvXvReh8VgN_d8b3ekct9A.png" /><figcaption>Top 10 Countries in the world with highest number of deaths/Data Source: data.europa.eu</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Q0PZv7m89mQMlnHjhgWC4Q.png" /><figcaption>Top 10 Countries in the world with highest number of cases/Data Source: data.europa.eu</figcaption></figure><p>Daily Count shows the number of cases. As of Nov 9th, 2020 the total number of cases worldwide was 462,259.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AbTTi7Tmt7GRTPut6G4SJg.png" /><figcaption>Daily world count of cases/Data Source: data.europa.eu</figcaption></figure><p>You can find the dashboard in my <a href="https://public.tableau.com/profile/odunayo6301#!/">Tableau portfolio</a> to further interact with it. Enjoy!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e9b8960ddab9" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>