SARS-CoV-2

In this project, my aim was to use my SQL skills to help analyse some data I attained online.

The website I used to get my data for the project is https://ourworldindata.org/. This was very helpful as it had a lot of information regarding the pandemic.

I analysed the data into three categories for my visualisation:

  1. Global

  2. Continent

  3. Country

SQL is the language I always lean towards for dealing with large datasets. It enables me to quickly gather the information I need for my visualisations.

In this project, I use multiple tools to create queries to obtain the information I need:

  1. Creating Views

  2. CTE's

  3. Temp Tables

  4. Aggregate Functions

    • SUM()

    • MAX()

    • SUM().... OVER (PARTITION BY .....)

    • AVG()

    • Etc...


I really enjoyed working on this project because it enabled me to practice my data cleaning skills as well as my data analysis skills. The link for the code is right here.