Reference no: EM132839719

MBS603 Data, Metrics, Reporting and Analytics - Murdoch University

Aims:

1. Provide students with a sound knowledge about HR data, metrics, and analytics

2. Equip students with practical frameworks by which major HRM processes can be analysed and evaluated

3. Provide students with opportunities to apply learnt knowledge and skills to address HRM issues in the real world, and develop evidence-based solutions.

Learning outcome 1: Explain how a system of inter-related functions/departments work, and demonstrate sound knowledge of HR data, metrics, and analytics.

Learning outcome 2: Demonstrate descriptive and prescriptive HR analytics knowledge and skills

Learning outcome 3: Apply HR metrics and analytics in the real-world scenario to address management problems

Learning outcome 4: Generate a business case for HR initiatives through evidence-based analytical reports.

Learning outcome 5: Work collaboratively with team members including communicating effectively, developing a project and demonstrating time management skills.

Assessment 1: Essay based on scholarly articles/books

You will be required to choose from the following topics for your assignment.

Topic 1: Role of HR analytics in aligning HRM to an organisation's strategic goals
OR
Topic 2: Knowledge and skills of HR data, metrics, and analytics are essential for today's HR professionals

These are very broad topics. You can focus on a certain aspect of the topic. Do ensure that the focus you place and the examples you choose are relevant to this Unit. Word length - 1,000 words.

Assessment 2: Data Analysis Report and Presentation

This assignment will be undertaken in a group of three or four depending on the size of the class. In weeks 1 & 2, you will negotiate with other students to form a team. The team need to select a Team coordinator who will inform the Unit coordinator of the names and student IDs of the team members no later than Week 2, Thursday, 5pm. The Team coordinator liaises with team members to organize team meetings for this Assignment. For external students, you may choose to do the assignment individually upon approval by the Unit coordinator.

You will be provided a detailed Excel sheet with consolidated data of an organisation which has two business divisions in four locations. The CEO wants to enhance organizational performance in profitability, and believes that HRM is the key to achieve this goal. The CEO suspects that there are differences in HRM practice and performance across the four locational branches and between the two business divisions, and asks you to investigate.

You, as the HR Manager, are required to do the following:

1. Using the data provided in the SampleDataFile downloadable from the LMS site, choose 2 or 3 metrics from 1) basic staff characteristics (e.g., education & work experience), 2) efficiency measures (e.g., time to fill & salary), 3) effectiveness measures (e.g., performance at 90 day & speed to competency), and 4) business outcome measures (e.g., profitability, productivity, Bradford factor), respectively, which you think are important to organizational performance in profitability.
2. Using Chart/Table/Dashboard, demonstrate the differences, if any, in these metrics across the four locational branches and between the two business divisions to verify the CEO's suspicion.
3. If any differences are found, propose possible explanations from a HR manager perspective.
4. Submit a Data Analysis Report in the form of Powerpoint slides to the CEO to summarize your findings. The report should include the following:
a. Introduction (1 slide)
b. Data and metrics description (2 slides)
c. What do the data tell us about these metrics in the four locational branches and the two business divisions of the organization? (6-10 slides)

d. Conclusion (1 slide)
5. Give a 10 minutes presentation using Powerpoint.
In Excel, the same presentation results can be achieved through various means (Tables, Chart, and Dashboard). Use your own ingenuity to go beyond the previous sessions and develop the best ways to present the most important information to the CEO and achieve the best visualization effect possible. If you are stuck, press F1 function key on your keyboard to get Excel help or google your query to get even more fantastic ideas.

Assessment 3: HR Policy Recommendation Project

The HR Policy Recommendation Project is an extension of Assignment 2, and will be undertaken individually. Extending the data analysis and presentation in Assignment 2, the Project needs to propose possible casual relationships between the chosen metrics, test these relationships using predictive analytics techniques, and provide recommendations on how the organization should improve staffing practices to enhance profitability. You may adjust (add or remove) the metrics that your team used in Assignment 2 if it deems reasonable and necessary. In writing up the Project, you are advised to refer to what are discussed in the seminar on "Predictive Analytics in Action" and Chapter 6 of the textbook, and apply predictive analytics methods to justify your policy recommendations.

The Project should be 2,000 words in length (plus or minus 10%), excluding cover page, reference list and appendix (if any). If you need to use Charts/Tables/Dashboard already presented in Assignment 2, please put them in the appendix. You need to submit the Project via LMS on Thursday, Week 13 at 5pm.

The Project should include the following:
a. Introduction
b. Analyse relationship between key HR metrics using predictive analytics methods
c. Provide recommendations on staffing policy to enhance organizational performance
d. Conclusion

*Assessment 4: Participation

In-class participation (internal students). During each seminar, the instructor may organize various activities including video, and group discussion, and exercises.
Students are required to actively participate in these in-class learning activities. You will be assessed on
1) Active participation in all class activities, and make contribution to class discussion and exercises;
2) Relevance of comments to what are discussed in the seminars, and awareness of readings and videos as required for the seminars;
3) Quality of oral communication.

Learning journal (External students). For external students, you are required to produce a written learning journal to reflect and highlight your key takes from the Unit. You will be assessed on
1) Relevance to what are discussed in the seminars, and awareness of readings and videos as required in the seminars;
2) Ability to select theoretical constructs learnt from self-directed readings and seminars, and innovatively apply them to address the issues under discussion;
3) Quality of written communication.

Note: Do Assessment 4: Participation

Attachment:- Reporting and Analytics.rar