Daniel_Portfolio

Data Analytics Portfolio

Project 1: Covid Analyses as of January 2022

• Downloaded full Covid database from https://ourworldindata.org/covid-deaths (Feb 15, 2020 to Jan 20, 2022) on Feb 21, 2020
• Converted file from CSV to XLSX and cleaned the data by changing values with periods (.) as decimal separators to commas (,) in order to be compatible with the Brazilian Excel format
• Separated the database into two different databases, one for Covid Deaths and the other for Covid Vaccinations and then imported them to the SQL Server
• Checked big numbers to validate if the data is coherent
• Scripted main analyses
• Copied and saved each scripts’ resulting tables to different Excel files
• Imported each file to Tableau and created the following data visualizations:

• 1. Covid Global Numbers

• 2. Covid Deaths by Continent

• 3. Percent of Population Infected by Covid per Country

• 4. Percent of Population Infected by Covid

• 5. Total Vaccines Applied per Continent

• 6. Total Vaccines Applied in Relation to Population