Creating A Cincinnati City Employee Dashboard Using SQL And Tableau

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