Project Info

This project explains the pandemic of our times Covid-19 with the most accurate data. In order to understand better what countries have the most victims , deaths and active cases a database will be created where i can present all of the above. Also, i will use the R programming language, Power-Bi and MS Excel for the visualizations.

Continents with most cases

Deaths by country on Treemap

Deaths of global cases

Data Provider

The data for the project are provided by

World Health Organization
European Centre for Disease Prevention and Control

Setup

  1. Start Microsoft SQL Server Management Studio
  2. Click Databases
  3. New Database 
  4. Give your new database a name 
  5. Start designing

  1. Start R Studio 
  2. Setting the working directory
  3. Import the dataframe 
  4. Load the libraries

Environment

RStudio
SQL Server Management Studio

Languages Used

 1. SQL
 2. R

Data Visualization tools

1. MS Power-Bi
2. MS Excel

anekar/CovidPerCountry