Analysis of Covid-19 daily results and information about patients using SQL and PowerBi

Abstract

COVID-19 is a contagious disease caused by a virus, the severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2). The first known case was identified in Wuhan, China, in December 2019. The disease quickly spread worldwide, resulting in the COVID-19 pandemic. The outburst of COVID-19 pandemic had tremendous effect on the whole world and analysis of the data can be meaningful in many ways to better understand the effect it had in our society. This paper aims in the direction of analysis of COVID-19 daily information based on country and continent level in terms of understanding the number of cases and deaths and their relationship, besides this is aims to better understand the vaccination number by country and effect of cases/death how they have affected these numbers. The solution was created on analysis of a dataset that contains daily information on each country, and using MySQL, SQL and PowerBi to generate the results for this work in way of query results which have been transformed to visuals using PowerBi for better understanding for further research work on this topic.