Synopsis and Recommendations on HR Management Dashboard

ASSIGNMENT 3: Presenting & Reporting data 

Unit learning outcomes

• Outline the value and limitations of the analytical and financial approach to business decision making.
• Identify appropriate techniques to assist in solving business problems across different business disciplines.
• Perform basic analysis using Excel as a business decision-making tool.
• Identify and interpret problems using a systematic approach to business decision-making.

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:

• Why are you creating this dashboard? 
• What purpose it will serve?
• What capabilities do you need?
• Who needs to see the dashboard? 

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:

• Present your synopsis and recommendations on ONE A4 page. 
• Use formal business English that is clear and easy for the reader to follow.
• Use new vocabulary introduced in the unit.
• Check your work for expression, grammar, spelling, and punctuation before submitting.

Your written work should include:

• An appropriate heading.
• A brief explanation and interpretation of the information presented in the dashboard.  That is:
  • provide an overarching understanding of the data (in all, what does the information mean to the organisation)
  • explain the outcome/meaning of each table, chart, graph, text or image
  • provide an understanding of the interactive elements use in your dashboard to vary the view of your data (filters / slicers)
• Include suggestions for external data to supplement the internal data presented in the dashboard.
• List your recommendations according to priority, that is:
  • list the most important recommendation first
  • number each recommendation to show order of priority

FINAL SUBMISSION

The final submission should include:

1. An appropriate heading for the dashboard
2. A copy of the dashboard (this should fill one A4 page)
3. A brief synopsis of the data and suggestions on how to complement the data with external information.
4. A list of recommendations.