Data visualisation tools and technologies

Assignment Help Other Subject

Reference no: EM133774075

Data, Metrics, Reporting and Analytics

Assessment - Data Analysis

Report and Presentation ASSESSMENT DESCRIPTION

The purpose of this assignment is for students to practice their descriptive analytic skills using data visualisation tools and technologies.

This assignment will be undertaken in a group of 4 - 5 students depending on the size of the class. In weeks 1 & 2, you will negotiate with other students to form a team. The team needs to select a Team Coordinator who will liaise with team members to organise team meetings and communicate with the tutor for any issues related to this Assignment. For external students, you can do the assignment individually or with other external students. It is the responsibility of the Team Coordinator to inform your class tutor of the names and student IDs of your team members no later than the end of Week 4.

You will be provided with a detailed Excel sheet with consolidated data of an organisation which has two business divisions in four locations. The CEO wants to enhance organisational performance in profitability, and believes that HRM is the key to achieve this goal. The CEO suspects that there are differences in HRM practices 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: basic staff characteristics (e.g., education & work experience);
efficiency measures (e.g., time to fill & salary);
effectiveness measures (e.g., performance at 90 day & speed to competency), and
business outcome measures (e.g., profitability, productivity, Bradford factor - profitability must be included), which you think are important to organisational performance in profitability.
So, choose 8-12 metrics in total.

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 an HR manager perspective.

4. Submit a Data Analysis Report package, including:

an executive summary of 500 words in Microsoft Word or PDF format to summarise the main findings;
an 8-12 pages PowerPoint presentation slides illustrating the main findings of your analysis, and
an Excel file with Dashboard showing the raw data and analytic process of the tables/charts presented in the PPT slides.

5. Give an 8 - 10 minutes presentation using PowerPoint (you can switch to the Excel file while presenting the Dashboard). All group members are expected to participate in the presentation. Students who are missing from the presentation will lose their marks for this part.

6. If it is impractical for all groups to present in class, especially in large classes with more than 50 students, your tutor may allow some groups to submit a video recording of their presentation. Please follow your tutor's instructions regarding the submission method.

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 visualisation effect possible. If you are stuck, press Fl function key on your keyboard to get Excel help or google your query to get even more fantastic ideas.

The presentation will be in the class in Week 8. Team Coordinator should submit the report package via LMS by 5pm, one day before the class in Week 8. An assignment cover sheet must be attached to the Executive Summary.

Reference no: EM133774075

Questions Cloud

Example of the multidimensional perspective in practice : Outline the major elements of taking a multidimensional approach to understanding human behavior and explain why the approach is beneficial.

Discuss a misconception of feminism : Briefly discuss a misconception of feminism that you have held or that you have encountered, either in interactions with others or in popular media.

Prepare invoices had been partially destroyed : Prepare invoices had been partially destroyed by spilt coffee, Johnny is extremely concerned that errors may have been made with invoicing clients

Discuss perception play in your interpersonal communication : What roles have the concepts of identity and perception played in the negative (or failed) interpersonal communication experiences in your past?

Data visualisation tools and technologies : The purpose of this assignment is for students to practice their descriptive analytic skills using data visualisation tools and technologies

What are ways society is disabling to the disabled : What are ways society is disabling to the disabled? What societal barriers exist that keep the disabled from engaging in life, in their community?

How would you define leadership : Leadership can have different meanings for different people. How would you define leadership?

How do their actions and policies impact species recovery : "What roles do different stakeholders play in the conservation of the American bison, and how do their actions and policies impact the species' recovery?"

What are the key research terms in grounded theory : What are the key research terms in grounded theory?

User Account

All Pages