SQL Covid-19
Data Exploration
In this project, I explored global data on confirmed COVID-19 cases, deaths and vaccinations using SQL.
The dataset is publicly available from Our World in Data and contains valuable information, although the figures may understimate the pandemic's total impact
on mortality worldwide.
Although the dataset is extensive and could provide endless insights, I have not yet extracted it into a visualization.
However, you can access the raw SQL code in my GitHub repository if you would like to explore it yourself.
Tableau Projects
AirBnB Seattle Area
In this Tableau visualization project, we examine a dataset of over 10 million datapoints from AirBnB listings in the Seattle, WA. area in 2016.
The large dataset allows us to explore various details related to zip codes, pricing, and revenue.
The project provides visual information on the number of bedrooms per listing, total revenue by bedroom count, average price per bedroom, zip code prices,
and reported revenue for 2016. One of the visualizations presented is a map of the Seattle area that shows the distribution of AirBnB listings by zip codes.
Some interesting findings include:
- There are more than twice as many single bedroom listings as all multiple bedroom listings combined.
- Single bedroom listings generated over $63m in revenue, more than all two to six bedroom listings combined ($60.3m).
- Reported revenue in December 2016 was more than double the revenue reported in January 2016.
Visit my GitHub repository to access the .twbx file or a PDF showcasing the visualization.
Covid Vaccine Tracker
The Global Vaccine Tracker Tableau visualization is an interactive tool that displays COVID-19 vaccination progress worldwide. The visualization
draws data from the Our World in Data COVID-19 Vaccination Dataset and allows users to select a start and end date from January 1st, 2020 to April 8th 2023,
as well as filter by continent and/or country, and answers the question "What share of the population has been partly or fully vaccinated?"
The visualization includes a horizontal bar chart and world map that shows the share of people fully and partly vaccinated for each country. It also
features a scatter plot that displays the number of people vaccinated per hundred against each country's GDP per capita
Check out my GitHub repository, where you can access the .twbx file or a PDF showcasing the visualization and its dynamic filters.
Power BI - Data
Professionals Survey
In this Power BI visualization project, we analyze the results of a Data Professionals Survey with 504 full-time employees in data-related roles.
We investigate various aspects such as respondents' country of residence, job titles, programming languages, average age, work/life balance, and salary.
Some interesting findings include:
- The treemap shows the distribution of respondents by country of residence. The job titles of "Data Scientist" and "Data Engineer" earn the highest salary and Python is the most popular programming language.
- On a scale of 1-10, respondents' "Happiness with work/life balance" scored 5.72, while "Happiness with salary" scored 4.26.
It is important to look at work/life balance because it is an indicator of job satisfaction and employee well-being.
- When asked "How difficult is it to break into data?" as a profession, 24.35% answered "Easy", while 23.83 responded "Difficult".
Visit my GitHub repository to access the .pbix file or a PDF showcasing the visualization.
Elements
Text
This is bold and this is strong. This is italic and this is emphasized.
This is superscript text and this is subscript text.
This is underlined and this is code: for (;;) { ... }. Finally, this is a link.
Heading Level 2
Heading Level 3
Heading Level 4
Heading Level 5
Heading Level 6
Blockquote
Fringilla nisl. Donec accumsan interdum nisi, quis tincidunt felis sagittis eget tempus euismod. Vestibulum ante ipsum primis in faucibus vestibulum. Blandit adipiscing eu felis iaculis volutpat ac adipiscing accumsan faucibus. Vestibulum ante ipsum primis in faucibus lorem ipsum dolor sit amet nullam adipiscing eu felis.
Preformatted
i = 0;
while (!deck.isInOrder()) {
print 'Iteration ' + i;
deck.shuffle();
i++;
}
print 'It took ' + i + ' iterations to sort the deck.';
Lists
Unordered
- Dolor pulvinar etiam.
- Sagittis adipiscing.
- Felis enim feugiat.
Alternate
- Dolor pulvinar etiam.
- Sagittis adipiscing.
- Felis enim feugiat.
Ordered
- Dolor pulvinar etiam.
- Etiam vel felis viverra.
- Felis enim feugiat.
- Dolor pulvinar etiam.
- Etiam vel felis lorem.
- Felis enim et feugiat.
Icons
Actions
Table
Default
| Name |
Description |
Price |
| Item One |
Ante turpis integer aliquet porttitor. |
29.99 |
| Item Two |
Vis ac commodo adipiscing arcu aliquet. |
19.99 |
| Item Three |
Morbi faucibus arcu accumsan lorem. |
29.99 |
| Item Four |
Vitae integer tempus condimentum. |
19.99 |
| Item Five |
Ante turpis integer aliquet porttitor. |
29.99 |
|
100.00 |
Alternate
| Name |
Description |
Price |
| Item One |
Ante turpis integer aliquet porttitor. |
29.99 |
| Item Two |
Vis ac commodo adipiscing arcu aliquet. |
19.99 |
| Item Three |
Morbi faucibus arcu accumsan lorem. |
29.99 |
| Item Four |
Vitae integer tempus condimentum. |
19.99 |
| Item Five |
Ante turpis integer aliquet porttitor. |
29.99 |
|
100.00 |