Skip to content

In this project we do EDA on covid-19 data using SQL. We use tableau for data visualization.

Notifications You must be signed in to change notification settings

srikanth2102/COVID-19-Data-Analysis

Repository files navigation

COVID-19 DATA ANALYSIS

DATA

The data used in this covid-19 data analysis is taken from kaggle covid-19 in India.

OBJECTIVES

COVID-19 VACCINATION DATA

  • Gender-wise vaccination details.
  • People who experienced side effects.
  • State-wise vaccination details.
  • State-wise covaxin covishield sputnik details.
  • Age-wise vaccination details.

COVID-TESTING DATA

  • Percentage of people tested postive w.r.t to testing.
  • State-wise covid-19 cases.
  • State-wise covid-19 testing.

COVID-19 INDIA DATA

  • Positive cases, deaths and cured count state-wise
  • State-wise recovery percentage
  • State-wise deaths due to covid-19

OVERVIEW

  • In this project we perform Data Analysis and Data Visualisation on COVID-19 dataset to get insights.
  • Data Analysis is done using SQL and the results are saved as csv files and shared here.
  • The queries written to perform Data Analysis is also shared under the directory Queries.
  • Data Visualisation is done using Tableau.
  • Tableau is an Data Visualization tool. Using Tableau is simple.
  • Using Tableau you can visualize your data in a structured way that is easier to get insights from.
  • To learn more about Tableau click here.

SAMPLE VISUALIZATION

  • Dashboard
  • The map shows the vaccination and covid-19 cases state-wise in India.
  • VACCINATION CURVE
  • From the above plot we can see an exponential rise in vaccination count over time. Lets hope this trend continues.
  • Covishield or Covaxin
  • From the above plot we can infer that most of the people got vaccinated with Covishield rather than Covaxin

OUTLINE