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
- The map shows the vaccination and covid-19 cases state-wise in India.
- From the above plot we can see an exponential rise in vaccination count over time. Lets hope this trend continues.
- From the above plot we can infer that most of the people got vaccinated with Covishield rather than Covaxin
OUTLINE
- Data used in this project can be found in the data directory.
- Under analysis_on_covid_vaccine_statewise you can find the queries used and the result csv files for COVID-19 VACCINATION DATA.
- Under analysis_on_StatewiseTestingDetails you can find the queries used and the result csv files for COVID-19 TESTING DATA.
- Under analysis_on_covid_19_india you can find the queries used and the result csv files for COVID-19 INDIA DATA.
- Under data visualisation you will find both PDF and PPT versions of the Visualizations.