ASSIGNMENT 3: Presenting & Reporting data
|Written task:||Dashboard, synopsis of the data and recommendations|
Unit learning outcomes
Create a dashboard in Excel that showcases the
key aspects of a data set
Dashboards track KPIs, metrics, and other data points in one visual, central place. They are made up of tables, charts, gauges, and numbers and give you a high-level view of work, helping you make quick decisions and keeping everyone up to date. A dashboard’s visual nature simplifies complex data and provides an at-a-glance view of status or performance in real time.
Before you start building your dashboard, consider the following:
Provide a brief synopsis of the data highlighted in the dashboard and a list of business recommendations based on the findings.
To make effective decisions organisations need accurate, timely, objective and concise information. Often this information is delivered in a business report written in response to a business issue or problem. The recommendations section of a report suggests actions that can be taken to address the issue based on findings. Recommendations could be for change, improvement or new ideas to improve such areas as service, productivity or performance.
You are required to:
Your written work should include:
The final submission should include:
The dashboard is named ‘HR Management Dashboard’ as it includes information that is useful for the HR team of a company.
The dashboard starts by explaining structure with respect to various departments such as, male female ratio in the company, marital status of employees as well as educational qualifications of employees. These factors help HR team to take various decisions related to employees.
Further, the dashboard explains for how long different employees have been working in the organization. This is provided for various departments and at various levels. This helps the HR team to take decisions regarding promotion, attrition etc.
The next chart explains average monthly income of various departments and levels. The pie chart has been used to indicate share in total average monthly expense.
The following chart presents performance rating vis-a-vis job satisfaction levels, followed by job involvement level of employees. The remaining graphs indicate various satisfaction levels, such as job satisfaction, work environment satisfaction, work life balance and relationship satisfaction.
The company can hire external help to analyse various factors that need further analysis. For example, the help can be hired to check if there is any major disparity in salary and whether it is having impact on satisfaction levels of employees. Mostly, the work life balance is good in the company but some employees report a bad balance. This can be analysed to understand the logic and reasoning.
|Objective from Strategy||Action||By Whom||Monitored by|
|Review salary structures of different employees and adjust those lying outside the average, either very low or very high||HR team||Recruitment committee|
|Understand and rectify reason behind bad work-life balance for some employees||HR team||Recruitment committee|
|Compare salary in competitors company and overall industry averages and keep salaries in-line with the same. The objective should be to ensure high motivation level and high retention level||Recruitment team/HR team||Recruitment committee/Board|