In this project, we are doing an analysis on Covid 19 dataset of global countries by writing queries using PostgreSQL as a tool to accomplish tasks and extract information in addition to building a dashboard using Tableau to illustrate findings and information found
This is a SQL project written with PostgreSQL and this is basically what we will need:
- PostgreSQL
- Tableau Desktop
- CovidDeaths.csv : Covid-19 data related to the number of infections and deaths.
- Covidvaccinations.csv : Covid-19 data related to vaccinations.
- Nashville Housing Data for Data Cleaning.csv : Data used just for practicing cleaning.
- SQL queries for data exploration and vis.pgsql : Queries of the Covid-19 dataset that answer questions.
- SQL data cleaning.pgsql : Queries of cleaning data
- Covid Dashboard.twbx : Tableau Dashboard in twbx format(Tableau file format).
- Covid dashboard.pdf : Tableau Dashboard in pdf format.
- Direct link to Dashboard.txt : File contains the link to the Dashboard uploaded on Tableau public.