Analytics and Reporting (Human Resources)

October 15, 2015

QlikView is an Enterprise Intelligence technology that allows the business to deliver intuitive solutions for self-service data visualization and guided analytics that drive decision-making. 

HR Analytics and Reporting has been working to develop new self-service QlikView applications as well as enhancements to existing applications.  The following QlikView HR Analytical applications are now available:

New HR Analytics applications

  • Benefits Demographics:  Allows the Benefits Services Group to look at enrollment metrics for all employees who are eligible for Medical, Dental, Vision, Health Care FSA, Dependent Care FSA, and Health Spending Account (HSA).  Data are refreshed at the end of each month from the HR DW and HR Analytics star schema since 2002. Access to the Benefits Demographics application is limited to the central Benefits Services Group in HHR.
  • Earnings Distribution:  The earnings distribution application will improve our ability to monitor and measure the effectiveness of Harvard’s $2.2B investment in people and programs; e.g., link talent management programs to retention, analyze/track workforce growth over time, and improve our understanding of trends in salaries and wages.  Data are refreshed monthly from the HR Analytics star schema which is sourced from detail payroll tables since 2002.
  • Recruitment Management Open Requisitions:  Designed to track the open or on hold requisitions and how long the requisitions have been opened or on hold at the end of each month since calendar year 2011.  Data are refreshed monthly from the ASPIRE system. The new open requisitions application will replace the quarterly Open Requisition Excel workbook.

Enhancements to HR Analytics applications

  • Performance Management:
    • Addition of a Goal Status toggle button on the Document Status Sheet, as well as University Wide Goal Status charts.
    • Addition of a Preliminary Ratings toggle button on the Ratings Sheet.
    • New Compensation and Ratings sheets which displays FTE Salary and Compa Ratio with Ratings, as well as custom logic to provide trending around FY Increases and Ratings. 
  • Recruitment Management Closed Requisitions:
    • New Self Service feature has been added so that you can create your own report.
    • The reports and charts can be viewed by Fiscal Year and Fiscal Quarter.
    • New dimensions have been added, such as EEO, Term Appointment Flag, Replacement Flag, Empl Class, Full/Part Time, SIC, Recruiter, New Role, Location, and Grade.
    • The data can be drilled down from Major Affiliation to Sub Affiliation, and finally to Department.

Access to the QlikView HR applications can be requested via your HR Authorized RequestorClick here to access the applications that you have access to via the QlikView portal page.

Browsers:  HR QlikView applications work best with Mozilla Firefox or Google Chrome browsers.

If you have any questions or suggestions, please contact the HUIT Help Desk at 617.496.2001 and ask the attendant to log an incident to the HHR - Analytics and Reporting team.