HR Analytics

Questions

With reference to an HR issue, interpret analytical data using appropriate analysis tools and methods and demonstrate calculations/methods of analysis
Interpret and demonstrate calculations using analytical tools (functions in Excel; percentages; translating data sets) to review “absence” data (Table 1) and provide findings of the following 5 categories: –

Trends across departments,
Absence by types,
Absence by gender,
Total days lost through absence,
Annual costs through absence based on a 37- hour week – Table 1 in brief
Interpret and demonstrate calculations using analytical tools to review “employee feedback scores to the Manager” – Table 2 in brief and provide findings

Present key findings for stakeholders from people practice activities and initiatives
Present all findings (Table 1 and Table 2) to identify key insights (patterns and trends) in people practice issues, using diagrammatic formats (e.g., pie charts; line graphs, bar charts) with some written explanation.

Make justified Human Resource Management (HRM) recommendations based on the evaluation of the benefits, risks, and financial implications of potential solutions from the findings in Tables 1 and 2.
Evaluate the data with the justification of two HRM recommendations considering the rationale, benefits (e.g., achievement of objectives; enhanced work productivity), risks (e.g., legal), and financial implications (e.g., indirect costs) of the recommendations.