The project itself is not very hard for someone who is proficient with Excel and formulas. So, please let me know if you could handle it. The attached Powerpoint (as stated in the instructions) slides will help you to find the correct formulas.
The whole project must be done only in an Excel file, no written paper needed for this type of assignment.
Category: Excel
Please submit your project in a single EXCEL file.
Use Slides for chapters 6 and 7 to assist your work The project itself is not very hard for someone who is proficient with Excel and formulas. (as stated in the instructions) slides which will help to find the correct formulas. The whole project must be done only in an Excel file, no written paper needed for this type of assignment.
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.
Please provide all answers inside an Excel file (no separate Word files), show the formulas (provide your calculations inside the Excel cells,don’t just plug in the final number) In addition, please make sure that the spreadsheets are easily understandable for a timeconstrained reader. SCORE IS BASED ON BOTH CONTENT AND APPEARANCE.
