<?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 Josh Emmanuelaudu on Medium]]></title>
        <description><![CDATA[Stories by Josh Emmanuelaudu on Medium]]></description>
        <link>https://medium.com/@joshemmanuels?source=rss-2ee04d113b5f------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*tB73BF0rUfeibc6dzFh4kA@2x.jpeg</url>
            <title>Stories by Josh Emmanuelaudu on Medium</title>
            <link>https://medium.com/@joshemmanuels?source=rss-2ee04d113b5f------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 20:53:28 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@joshemmanuels/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[Data Analysis using SQL and Tableau: A Look at COVID Cases after the Pandemic]]></title>
            <link>https://medium.com/@joshemmanuels/data-analysis-using-sql-and-tableau-a-look-at-covid-cases-after-the-pandemic-683effc41ce8?source=rss-2ee04d113b5f------2</link>
            <guid isPermaLink="false">https://medium.com/p/683effc41ce8</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[tableau]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[covid19]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Josh Emmanuelaudu]]></dc:creator>
            <pubDate>Fri, 16 Sep 2022 10:12:19 GMT</pubDate>
            <atom:updated>2022-09-16T11:33:18.639Z</atom:updated>
            <content:encoded><![CDATA[<h3>Introduction</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XtX08yyGWTMckPBcAlesMQ.jpeg" /></figure><p>Covid, the dreaded disease that took the world by surprise. Unprepared and shook, nations of this world had no defense against this contagious monster. This disease indiscriminately affected different races and ages with an intent to weaken the immune system and in most cases cause death.</p><p>Since 2020, nations have pulled through the most difficult times, this analysis would be looking into the insights of the covid dataset provided by the amazing team in <a href="https://ourworldindata.org/coronavirus.">https://ourworldindata.org/coronavirus.</a> Encompassing all the information needed to conduct this analysis.</p><h3>Dataset</h3><p>The dataset used for this analysis contains data from the 4th of February 2020 till 12th September 2022. This project will contain analysis of Covid Cases that occurred in the nations of the world and was carried out using Excel &amp; SQL and the visualization was done on Tableau.</p><p>The columns as seen in the dataset gotten when viewed on Excel are:</p><pre>[&#39;iso_code&#39;, &#39;continent&#39;, &#39;location&#39;, &#39;date&#39;, &#39;total_cases&#39;, &#39;new_cases&#39;, &#39;new_cases_smoothed&#39;, &#39;total_deaths&#39;, &#39;new_deaths&#39;, &#39;new_deaths_smoothed&#39;, &#39;total_cases_per_million&#39;, &#39;new_cases_per_million&#39;, &#39;new_cases_smoothed_per_million&#39;, &#39;total_deaths_per_million&#39;, &#39;new_deaths_per_million&#39;, &#39;new_deaths_smoothed_per_million&#39;, &#39;reproduction_rate&#39;, &#39;icu_patients&#39;, &#39;icu_patients_per_million&#39;, &#39;hosp_patients&#39;, &#39;hosp_patients_per_million&#39;, &#39;weekly_icu_admissions&#39;, &#39;weekly_icu_admissions_per_million&#39;, &#39;weekly_hosp_admissions&#39;, &#39;weekly_hosp_admissions_per_million&#39;, &#39;total_tests new_tests&#39;, &#39;total_tests_per_thousand&#39;, &#39;new_tests_per_thousand&#39;, &#39;new_tests_smoothed&#39;, &#39;new_tests_smoothed_per_thousand&#39;, &#39;positive_rate&#39;, &#39;tests_per_case&#39;, &#39;tests_units&#39;, &#39;total_vaccinations&#39;, &#39;people_vaccinated&#39;, &#39;people_fully_vaccinated&#39;, &#39;total_boosters&#39;, &#39;new_vaccinations&#39;, &#39;new_vaccinations_smoothed&#39;, &#39;total_vaccinations_per_hundred&#39;, &#39;people_vaccinated_per_hundred&#39;, &#39;people_fully_vaccinated_per_hundred&#39;, &#39;total_boosters_per_hundred&#39;, &#39;new_vaccinations_smoothed_per_million&#39;, &#39;new_people_vaccinated_smoothed&#39;, &#39;new_people_vaccinated_smoothed_per_hundred&#39;, &#39;stringency_index&#39;, &#39;population&#39;, &#39;population_density&#39;, &#39;median_age&#39;, &#39;aged_65_older&#39;, &#39;aged_70_older&#39;, &#39;gdp_per_capita&#39;, &#39;extreme_poverty&#39;, &#39;cardiovasc_death_rate&#39;, &#39;diabetes_prevalence&#39;, &#39;female_smokers&#39;, &#39;male_smokers&#39;, &#39;handwashing_facilities&#39;, &#39;hospital_beds_per_thousand&#39;, &#39;life_expectancy&#39;, &#39;human_development_index&#39;, &#39;excess_mortality_cumulative_absolute&#39;, &#39;excess_mortality_cumulative&#39;, &#39;excess_mortality&#39;, &#39;excess_mortality_cumulative_per_million&#39;]</pre><p>Having seen this, using Excel we conducted some formatting and cleaning by splitting the dataset into two tables because we won’t be needing this many columns for the analysis. CovidDeaths and CovidVaccinations.</p><p>The columns in the First table which is the CovidDeaths table are:</p><pre>[&#39;iso_code&#39;, &#39;continent&#39;, &#39;location&#39;, &#39;date&#39;, &#39;population&#39;, &#39;total_cases&#39;, &#39;new_cases&#39;, &#39;total_deaths&#39;, &#39;new_deaths&#39;]</pre><p>The columns in the Second table which is the CovidVaccinations table are:</p><pre>[&#39;iso_code&#39;, &#39;continent&#39;, &#39;location&#39;, &#39;date&#39;, &#39;total_vaccinations&#39;, &#39;new_vaccinations&#39;]</pre><p>Majorly the CovidDeaths table will be used for the most part.</p><h3>Data Analysis</h3><p>Moving forward to the analysis phase having formatted and organized the tables needed, there would be no need for further cleaning as we do not want to tamper with any of the values gotten.</p><p>We then import the newly created tables to the database created on the SQL Server.</p><p><strong>CovidDeaths Table</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/053928010e9af532b9fde6015f4c67ef/href">https://medium.com/media/053928010e9af532b9fde6015f4c67ef/href</a></iframe><p><strong>Result:</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/c9261d36541ad17abc60cbecff375b59/href">https://medium.com/media/c9261d36541ad17abc60cbecff375b59/href</a></iframe><p><strong>CovidVaccinations Table</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/97b13b75f79c6fa488a0546a798dcf4d/href">https://medium.com/media/97b13b75f79c6fa488a0546a798dcf4d/href</a></iframe><p><strong>Result:</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/6364c869f9e556690c353eac830624b2/href">https://medium.com/media/6364c869f9e556690c353eac830624b2/href</a></iframe><ol><li>Looking at the total number of deaths — Global Numbers</li></ol><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/a44f8aebafb762f7e6793d31483af3aa/href">https://medium.com/media/a44f8aebafb762f7e6793d31483af3aa/href</a></iframe><p><strong>Results:</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/485/1*T1cZr0gPgAar0Pf3Gl-3xg.png" /></figure><p>2. Looking at the total death rate per continent</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/7b97e039d2fb719270539f651e9d89e7/href">https://medium.com/media/7b97e039d2fb719270539f651e9d89e7/href</a></iframe><figure><img alt="" src="https://cdn-images-1.medium.com/max/452/1*T4iBm1Pd_puTYRcyvWSlDA.png" /></figure><p>3. Looking at Percent Infected Population per Location</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/7e977c27332ad2cf8c414e4d616e343f/href">https://medium.com/media/7e977c27332ad2cf8c414e4d616e343f/href</a></iframe><p><strong>Result:</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/56df547d84765f6f6a5c827fb023888b/href">https://medium.com/media/56df547d84765f6f6a5c827fb023888b/href</a></iframe><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZM9wXbQ3wKlnzlT5fe3mwQ.png" /><figcaption>Picking Just 4 Countries for the Visualization</figcaption></figure><p>4. Looking at the Total Population vs amount of people vaccinated</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/7fb0d4c76e178d8c487d330c80d727f5/href">https://medium.com/media/7fb0d4c76e178d8c487d330c80d727f5/href</a></iframe><p><strong>Results:</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/0f87c9db88ff4748992a4bd75b94bf38/href">https://medium.com/media/0f87c9db88ff4748992a4bd75b94bf38/href</a></iframe><p>5. Looking at the Percentage of people vaccinated per country Using CTE</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/74b1d12f797d40f59721186650d2e817/href">https://medium.com/media/74b1d12f797d40f59721186650d2e817/href</a></iframe><p>Results:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/6c7c2edd4ffd896f935f74e684e60555/href">https://medium.com/media/6c7c2edd4ffd896f935f74e684e60555/href</a></iframe><p>Creating a Temp Table for the percentage of people vaccinated over time</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/ed52e71af605c073bcd1e80997c0bfb1/href">https://medium.com/media/ed52e71af605c073bcd1e80997c0bfb1/href</a></iframe><p><strong>Summary</strong></p><p>According to the results from the analysis, the following insights can be derived:</p><ol><li>The total covid cases till date is 607,945,643 and the total death is 6,477,340 which makes the global death percent to be 1%</li></ol><p>2. Europe and North America has the highest number of deaths since covid broke out. Although the disease is said to have originated from Asia. It’s rather surprising to see this.</p><p>3. As time went by, more people were getting vaccinated as confirmed in the analysis.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*HT-5LiBTP_qEwvsSxgtqgw.png" /><figcaption>Covid Dashboard</figcaption></figure><p>For a detailed look on the project, look at the <a href="https://github.com/Joshemmy/Portfolio/blob/main/Covid%20Portfolio%20Project.sql">GitHub</a> repository.</p><p>If you have feedback, suggestions, or questions about this post, feel free to comment on GitHub or to add to it, or reach out to me on <a href="https://www.linkedin.com/in/joshemmy/">LinkedIn</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=683effc41ce8" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>