Category Archives: Excel

buisness analytics

Assignment instructions
For this assignment, you are required to complete two tasks.

Assignment instructions
For this assignment, you are required to complete two tasks.

Task 1: Create a dashboard in Excel that showcases key aspects of the data set provided (20 marks).

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 dashboards visual nature simplifies complex data and provides an at-a-glance view of status or performance in real time. For Task 1 you need to analyse the data provided to you (Assignment 2 Excel Data Set), and from the data you will choose several different variables to include in your charts to highlight key findings.

Present a screenshot of the actual Excel dashboard on One A4 page
Ensure key elements of the data are provided.
Ensure charts and graphs are appropriate for the type of data you are highlighting in the dashboard.
Present your visuals professionally.

Task 2: Provide a brief synopsis of the data highlighted in the dashboard and a list of business recommendations based on the findings (15 marks).

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.

Present your synopsis and recommendations on ONE A4 page.
Write an appropriate heading.
Include suggestions for external data to supplement the internal data presented in the dashboard.
List your recommendations according to priority: the most important first.
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.