Need assistance? Contact the HR Analytics and Reporting team
Spotlight! HBS Managing the Future of Work Podcast
Hot Topics: 7 Steps to Improve your Analytical Thinking Skills
Position Tracking and Reporting – Workforce Analytics Qlik Improvements and HR Position Data Models!
My Positions and University Positions
Empl Class and Job Function filters: Users can now easily find and select Empl Class and Job Function on the common filters panel.
Positions by Major Affiliation: A stacked bar chart has been added to the Positions Details, Incumbents and Vacancies applications. The charts display total positions, total incumbents and total vacancies by Major Affiliation and by Empl Class, Job Function and Sub Affiliation. Clicking the cycle down button below will change the data elements for each chart.
New! HR Position Data Model to support the Workforce Qlik Position applications:
- SHR_PS_POSITION_DATA_E_SV
- OHR_POSN_DATA_SV
- OHR_POSN_DATA_NOCOMP_V
- OHR_POSN_ACTN_SV
- OHR_POSN_ACTN_NOCOMP_V
- OHR_POSN_INCUMB_CURR_SV
- OHR_POSN_INCUMB_CURR_NOCOMP_V
- OHR_POSN_ALL_CURR_SV
- OHR_POSN_ALL_CURR_NOCOMP_V
- OHR_POSN_VACANT_CURR_SV
- OHR_POSN_VACANT_CURR_ NOCOMP_V
Enhancements to existing HR Workforce Job and Employee data models:
- OHR_JOB_ACTN_ALL_DEPT_SV
- OHR_JOB_ACTN_ALL_SV
- OHR_JOB_ACTN_AUDIT_NOCOMP_V
- OHR_JOB_ACTN_AUDIT_V
- OHR_JOB_ACTN_DEPT_SV
- OHR_JOB_ACTN_NOCOMP_V
- OHR_JOB_ACTN_SV
- OHR_JOB_ACTN_V
- OHR_JOB_CURR_ALL_SV
- OHR_JOB_CURR_AUDIT_NOCOMP_V
- OHR_JOB_CURR_AUDIT_V
- OHR_JOB_CURR_NOCOMP_V
- OHR_JOB_CURR_V
- OHR_JOB_HIST_ALL_DEPT_SV
- OHR_JOB_HIST_ALL_SV
- OHR_JOB_HIST_AUDIT_NOCOMP_V
- OHR_JOB_HIST_AUDIT_V
- OHR_JOB_HIST_DEPT_SV
- OHR_JOB_HIST_NOCOMP_V
- OHR_JOB_HIST_SV
- OHR_JOB_HIST_V
Data Access/Governance Enhancements- Reminder!
The existing Absence Management, Demographics Historical and Demographics Costing QlikView applications have been renamed and will be assigned to new security roles/zones effective Monday, July 15th. The changes are being made to better align data access to business process specific applications. See below for the new name and role required to access each application:
University Absence Management: HDW^HRO^TUB^Absence No Comp
University Demographics - Historical: HDW^HRO^TUB^Dem No Comp
University Demographics Costing: HDW^HRO^TUB^Costing No Comp
Learning and Development
Harvard Training Portal
The Harvard Training Portal offers online Excel courses through LinkedIn Learning, while the Center for Workplace Development offers in-person Excel courses from introductory to advanced levels.
- Current Excel Courses Offerings:
- Introduction to Excel
- Intermediate Excel
- Advanced Excel
Workforce Analytics Qlik
We recommend the Introduction to QlikView using HR Data class.
Select SHOW INTEREST.
QlikView Tutorial available in the HR Analytics and Reporting Group.
For information about HR QlikView Applications, please visit the HR Workforce Analytic applications portfolio and data access roles document. Please contact your authorized requester to request access to one or more of the applications.
