3CO02 Principles of Analytics Assignment Case Study : Applying People Analytics to Drive Evidence-Based HR Decisions at Company X

3CO02 Task

Answer the eight questions below, referring to the case study.

Case Study

You have applied for the post of People Analytics Administrator at Company X, a leading provider of HR solutions to businesses in your region. Company X offers a diverse range of people management and business services to meet the needs of its customers and are now looking for a People Analytics Administrator, as currently there is limited experience of data management in the team. The successful applicant will be accountable for managing the analysis of data, ensuring that Company X makes informed data-driven decisions for its clients. You have received an assessment pack to complete for the first stage of the selection process. The pack contains eight questions, which have been designed to demonstrate your knowledge and understanding of how professional people can use data and analytics to support decision-making and improve people practices.

The questions are as follows:

Q1. Explain what evidence-based practice is and provide two examples of how Company X could apply it. (AC 1.1)

Q2. Explain the importance of using data at Company X to accurately determine problems and issues. (AC 1.2)

Q3. Explain the different types of data measurements that people professionals at Company X could use. (AC 1.3)

Q4. Explain how the application of policies and procedures can inform Company X’s decisions. (AC 1.6)

Q5. Explain how the people professionals at Company X can create value for their people, their organisation and their wider stakeholders. (AC 2.1)

Q6. Imagine that you have been successful in your application for the role at Company X. Summarise the ways that you could be customer-focused and standards-driven in your new role, drawing on your previous experience, as necessary. (AC 2.2)

Q7. The Excel table inserted below shows the hours of overtime worked over four weeks for one of Company X’s clients, Blue Mountain Patisserie.

Your task is to:

• Calculate the average number of overtime hours worked by each employee during the four weeks.
• Calculate the average overtime hours as a percentage of the normal working hours.
• analyse the results and provide written comments on any issues that the data has revealed, suggesting potential problems and solutions. (AC 1.4)

Q8. Finally, present your findings using at least two different types of diagrammatic forms (for example, pie charts, bar graphs, or line graphs) to make the information easier to understand. (AC 1.5)