The HR Basic Dashboard gives users the capability to slice and dice employee data by demographic, employment details, RC, department, job type, job family, job class, assignment status, full/part-time status, and tenure status among other categories.

Some question that can be answered by this dashboard are:

• How many employees work in my RC?

• Who are the employees that work in my department?

• What is the age breakdown of the employees at Pitt?

• How may terminated employees did we have this fiscal year verses the last two years?

• What employees started employment at Pitt this fiscal year?

• What is the salary breakdown for employees in my department?

• Who are the faculty members for SCI?

• What is the breakdown for years of service at Pitt?

• What is the gender breakdown of staff members in SVC Research?

• What employees are on short term disability?

• How many part-time employees do we have?

• What is the ethnicity breakdown of voluntary terminations last fiscal year?

• What are the home addresses and work phone numbers for employees in my department?

There are seven dashboards available in Tableau:

Headcount – Here you will find employee counts based on various dimensions, some of which include ethnicity, gender, campus, percentage of effort, FLSA status, and Full time/Part time.  You can also filter the data you have access to by using the filters on the right hand side of the page.  Some of the filters included are fiscal year, month, department, job type, and assignment status. 

Current Roster – Here you will find a list of employees and their details for which you have access.  You can filter the data by using the filters at the top of the page.  Some of the filters included are fiscal year, month, department, job type, and assignment status. 

Employee Profile – Here you will find a snapshot of employee information, which is similar to the previous paper employee record (ER).  This dashboard includes Demographics, Employment Dates, Employment Info, Salary Info, Faculty Info, and Termination Info sections.

Terminations – Here you will find termination counts based on various dimensions, some of which include ethnicity, gender, campus, percentage of effort, FLSA status, and full-/part-time status. You can also filter the data to which you have access by using the filters on the right hand side of the page. Some of the filters included are fiscal year, month, department, job type, assignment status, and leaving reason.

Terminations List – Here you will find a list of terminated employees and their details for which you have access. You can filter the data by using the filters at the top of the page. Some of the filters included are fiscal year, month, department, job type, and assignment status.

New Hires - Here you will find new hire counts based on various dimensions, some of which include ethnicity, gender, campus, percentage of effort, FLSA status, and full-/part-time status. You can also filter the data to which you have access by using the filters on the right hand side of the page. Some of the filters included are fiscal year, month, department, job type, and full-/part-time.

New Hire List - Here you will find a list of new hires and their details for which you have access. You can filter the data by using the filters at the top of the page. Some of the filters included are fiscal year, month, department, job type, and full-/part-time.

Headcount is defined as the number of unique individuals that did not have a Terminated assignment status for the As of time period (first filter).

Open

This dashboard has three general sections:

Drop-down menus along the right-side allow you to filter all visualizations on the page. Be sure to click the Apply button after selecting the desired values in your filter.

The large number in the upper-right of the screen provides a count of the total number of employees represented (subject to the filters applied).

Back to Top

The employee roster contains employment and demographic details about employees, filterable by RC/Department, Job Classification. Clicking on an individual person in this list will navigate to the Employee Profile. This list can also be downloaded to Excel, for other uses (e.g., mailing lists).

Open

The list includes the following fields:

Back to Top