HR Basic Dashboard

Owned by Stacy Ash, created
Last updated: Apr 14, 2023 by Nalyn Siripong
7 min read

 

Description

The HR Basic Dashboard supplements human resources reporting from the PittWorx system.  Use this dashboard to analyze trends over time for head counts, terminations, and new hires; view distributions by employment detail or demographics; export contact lists of current employees by RC/department; or inspect an individual employee’s record in-detail.

 

Key Business Questions

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?

Navigating and Using Tableau Dashboards

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

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).

This dashboard has three general sections:

This line tracks the headcount captured at each snapshot. To inspect the data behind a specific point on that line, simply update the filter labeled As of to view the employees who make up that date.

These bar charts show the count of employees (as of the filtered date and as specified by other filters) broken down by:

  • Age

  • Disability status

  • Educational attainment

  • Ethnicity

  • Generation

  • Gender

  • Veteran status

When the filters identify a population smaller than 5 individuals, visualizations may not render to protect individual-level privacy.

  • Campus

  • Department

  • % Effort

  • FLSA Status

  • Full-time/Part-time

  • Job Type

  • Job Family

  • Job Class

  • Responsibility Center

  • Senior Officer

  • Supervisor

  • Tenure Stream

  • Years at University

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

Current Roster

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).

The list includes the following fields:

  • Employee Number

  • First Name

  • Last Name

  • Middle Name

  • Work Email

  • Address Line 1

  • Address Line 2

  • City

  • State

  • Zip

  • Personal Phone

  • Work Phone

  • Date First Hired

  • Latest Start Date

  • Adjusted Service Date

  • Provisional

  • Assignment Status

  • RC

  • Department

  • Position Number

  • Working Title

  • Payroll

  • Salary Basis

  • Full-Part Time Status

  • Percent of Effort

  • Working Hours

  • CDC Code

  • Staff Work Months

  • Pay Year Type

  • External Affiliation

  • FSLA

  • Supervisor

  • Bargaining Unit

  • Annual Salary

  • Monthly Hourly Amount

  • Faculty Contract Begin Date

  • Faculty Contract End Date

  • Faculty Contract Salary

  • Tenure Status

  • Date Entered Tenure Stream

  • Tenure Stream Transfer

  • Date Left Tenure Stream

  • Returned Tenure Stream

  • Date Awarded Tenure

  • Member Graduate Faculty

  • Joint Appointment

  • English Language Frequency

  • Faculty Emeritus

  • Legacy July

Back to Top

Employee Profile

This page shows details of a selected employee. To view an employee's profile, select the Employee Name (Employee Number) dropdown list and type in the employee name or number that you need to access, or select a person from the list. Selecting the employee name will immediately update to their profile information (there is no Apply button on this filter).

Back to Top

Terminations

Terminations include employee who has moved to the Terminated (Paid) or Terminated (Unpaid) assignment statuses in PittWorx.

Like the Headcount and New Hires dashboards, drop-down menus along the right-side allow you to filter all visualizations on the page. The page has three visualizations.

This line tracks the headcount captured at each snapshot. To inspect the data behind a specific point on that line, simply update the filter labeled As of to view the employees who make up that date.

These bar charts show the count of employees (as of the filtered date and as specified by other filters) broken down by:

  • Age

  • Disability status

  • Educational attainment

  • Ethnicity

  • Generation

  • Gender

  • Veteran status

When the filters identify a population smaller than 5 individuals, visualizations may not render to protect individual-level privacy.

Back to Top

Termination List

The following list can be exported to Excel. This list can also be downloaded to Excel, for other uses (e.g., mailing lists).

Back to Top

 

New Hires

New hires are people who have newly joined the University. This count includes people who were terminated from a prior position at the University (though these individuals can be excluded using the Rehires filter).

Like the Headcount and Termination dashboards, drop-down menus along the right-side allow you to filter all visualizations on the page, and the page is divided into three sections:

Back to Top

New Hire List

The following list can be downloaded to Excel.

Back to Top

What is the source of this information?

The data for this dashboard comes from Pitt Worx. The data from Pitt Worx is copied, transformed, and loaded into our data warehouse each weekday night. The data is then further processed for use by Tableau. A Tableau extract is refreshed each weekday morning so that the data is available before the start of business. As such, the data available today is as of what was in Pitt Works yesterday and won’t be refreshed until tomorrow morning. If a change is made in Pitt Worx today, you will not see that change until tomorrow.

How do I get access?

Anyone with access to the PY Mart will have access to the HR Basic Dashboard. All users can see rolled up demographics. However, permission is required to see individual demographics as well as salary, leaving reasons and any other restricted fields. Users will only see their RC/Department (unless otherwise approved on their Federated Authorization form).

To request access to the HR Basic Dashboard (including restricted fields), complete the Employee Mart Federated Authorization Request online.

 

Status

PRODUCTION

 

Need help? Contact the Pitt IT Helpdesk