This project is about data exploration and analysis of Covid dataset using SQL queries in BigQuery and creating visualizations of the analyzed data in Tableau.
- SQL
Joins,Agrregate functionsGROUP BYPARTITION BYTemp tables
- Creating visualization dashboard in
Tableau.
Covid Data Analysis - Tableau Dashboard
- Understanding the data and it's components first is helpful before starting to clean and analyze it.
- Exploring the large dataset with sorting and using different filters in SQL narrows the search and gets to the required information easily.
- Understanding the question I am trying to answer first helps me save time to write appropriate queries.
- Selecting appropriate visualizations for different types of data makes it easier to convey the information.
- Last but not the least, it's crutial to save work periodically after finishing it to avoid losing work and having to redo it.
- It took me some time to figure out that query results can be saved in new tables in the dataset which I can use them later for future queries and creating visualizations.
- I was unable to save the complete query results of some of my queries in spreadsheets which I wanted to use them for visualizations in tableau later. Hence, I decided to filter my query results and focus on visualizations for covid data for a specific continent.
- Dataset
- Alex The Analyst portfolio tutorial on SQL Data exploration
- Alex The Analyst portfolio tutorial on Tableau Visualization
I am a healthcare professional who is passionate about the use of data and emerging technology to help people and businesses reach their goals and improve healthcare.
