HR Analytics
Â
Description
HR Analytics 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:
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).
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 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).
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.
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).
Â
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:
New Hire List
The following list can be downloaded to Excel.
Coming Soon - Position Occupancy
This view displays all active Pitt Worx positions filterable by Occupancy, RC/Department and Position Name. The vacant positions may or may not be posted as open in Talent Center to be filled. If a position is no longer needed, take the appropriate action within Pitt Worx. Open positions can be listed in the Operating Funds Forecasting or Grants Forecasting applications as placeholder records to budget accordingly.
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