Data. Learning. Creativity.

Hey! Welcome to my portfolio website!

- Sherlock Holmes

layout

By default, the <title> tag for this page is determined by the title field (in the Content group). You can override the tag value here.

metaTitle

media

bottomSections

By default, the description tag for this post is taken from the Excerpt field. You can override the tag value here.

metaDescription

By default, the "og:image" meta tag set for social sharing this post points to the Featured Image field (in the Content group). You can override that image here.

socialImage

markdown_content

If enabled, the title suffix defined in the site configuration is appended to the title tag of this page.

addTitleSuffix

To add or override any meta tag for this page, add entries to this list. Entries defined here take precedence over any other defaults.

metaTags

title

colors

date

author

excerpt

featuredImage



## Queries in SQL

**Total number of employees** 

```
Select Count(NAME) AS Total_Employees

From CrimeData..City_of_Cincinnati_Employees_w__Salaries
```

**Average Salary** 

```
Select AVG(ANNUAL_RT) AS Average_Salary
```

```

From CrimeData..City_of_Cincinnati_Employees_w__Salaries
```

**Number of people by gender**

```

Select Gender, Count(Gender) AS Employees_By_Gender

From CrimeData..City_of_Cincinnati_Employees_w__Salaries

Group by Gender
```

**Average salary by gender**

```

Select GENDER, AVG(ANNUAL_RT) AS Average_Salary

From CrimeData..City_of_Cincinnati_Employees_w__Salaries

Group By GENDER
```

**Number of people by race**

```

Select RACE, Count(Race) AS Number_Employees_Race

From CrimeData..City_of_Cincinnati_Employees_w__Salaries

Group By Race
```

**Average pay by race**

```

Select RACE, AVG(ANNUAL_RT) AS Average_Pay_Race

From CrimeData..City_of_Cincinnati_Employees_w__Salaries

Group By Race

Order By 2,1
```

**Average pay by pay group**

```

Select PAYGROUP, AVG(ANNUAL_RT) --AVG(ANNUAL_RT) AS Pay_By_Job

From CrimeData..City_of_Cincinnati_Employees_w__Salaries

GROUP BY PAYGROUP
```

**New Jobs each year**

```

Select Year(Hire_Date) As Year , Count(NAME) As Number_Of_New_Jobs

From CrimeData..City_of_Cincinnati_Employees_w__Salaries

Group By Year(Hire_Date)

Order by 2,1
```



Creating A Cincinnati City Employee Dashboard Using SQL And Tableau

## Motivation

Covid-19 is a terrible and deadly virus that has wreaked havoc over the world over the last 3 years. Thanks to the brilliant and diligent work done by researchers throughout the world to create a vaccine and the companies and governments that facilitated the administration of the vaccine, the number of infections, hospitalizations, and deaths reduced dramatically leading us as a world to be able to enjoy day to day life again. With the initial vaccine coming out a few years ago I wanted to look and see how not only the United States did when it came to vaccinations but how countries around the world did and how they compare. Additionally, I wanted to look at how each state in the United States compared when it comes to vaccinations. To use the interactive dashboard of both the worldwide trends and United States trends click [here](https://public.tableau.com/app/profile/kevahn.mcdonald/viz/U_SandWorldCovid-19VaccineTrends/Dashboard1)

## Code

SQL queries for worldwide dashboard

**–-Removing unneeded row**

```
DELETE
```

```
FROM VaccineData..WorldVaccine
```

```
WHERE Country IN ('World', 'iran')
```

\*\*--Getting total amount of vaccination in the world \*\*

```
Select SUM(Doses_Administered) AS Total_Vaccines
```

```
FROM VaccineData..WorldVaccine
```

**--country with the least amout of vaccines given per capita**

```
Select Country, Doses_per_1000
```

```
FROM VaccineData..WorldVaccine
```

```
WHERE Doses_per_1000 != 0
```

```
ORDER BY Doses_per_1000 DESC
```

**--country with the most amount of vaccines given per capita**

```
Select TOP 1 Country, Doses_per_1000
```

```
FROM VaccineData..WorldVaccine
```

```
WHERE Doses_per_1000 != 0
```

```
ORDER BY Doses_per_1000 DESC
```

**-- AVG amout of vaccines given per capita**

```
Select AVG(Doses_per_1000) AS Avg_Vac_Per_Capita
```

```
FROM VaccineData..WorldVaccine
```

```
WHERE Doses_per_1000 != 0
```

**--Percent of world vaccinated by country**

```
Select Country, AVG(Fully_Vaccinated_Population) AS Percent_World_Vaccinated_By_Country
```

```
FROM VaccineData..WorldVaccine
```

```
WHERE Fully_Vaccinated_Population != 0
```

```
Group by Country
```

**--Trend of fully vaccinated per month by continent per 100**

**--Asia**

```
SELECT continent, date, people_fully_vaccinated_per_hundred
```

```
FROM VaccineData..DailyVaccine
```

```
Where continent = 'Asia'
```

**--NA**

```
SELECT continent, date, people_fully_vaccinated_per_hundred
```

```
FROM VaccineData..DailyVaccine
```

```
Where continent = 'North America'
```

**--SA**

```
SELECT continent, date, people_fully_vaccinated_per_hundred
```

```
FROM VaccineData..DailyVaccine
```

```
Where continent = 'South America'
```

**--Europe**

```
SELECT continent, date, people_fully_vaccinated_per_hundred
```

```
FROM VaccineData..DailyVaccine
```

```
Where continent = 'Europe'
```

**--Africa**

```
SELECT continent, date, people_fully_vaccinated_per_hundred
```

```
FROM VaccineData..DailyVaccine
```

```
Where continent = 'Africa'
```

**--Oceania**

```
SELECT continent, date, people_fully_vaccinated_per_hundred
```

```
FROM VaccineData..DailyVaccine
```

```
Where continent = 'Oceania'
```



Hey! Welcome to my portfolio website!

“It is a capital mistake to theorize before one has data.”

Projects

Creating A Cincinnati City Employee Dashboard Using SQL And Tableau

Recent Covid-19 Vaccine Trends Dashboard Using Tableau and SQL Queries

Home

Hey! Welcome to my portfolio website!

“It is a capital mistake to theorize before one has data.”

Projects

Creating A Cincinnati City Employee Dashboard Using SQL And Tableau

Recent Covid-19 Vaccine Trends Dashboard Using Tableau and SQL Queries