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
Task 1: Create a dashboard in Excel that showcases the key aspects of a data set
Dashboards track KPls, 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 wok, 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?
Task 2: 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 repot 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 priaity: the most important first.
- Use formal business English that is dear 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.
Attachment:- Data Assignment.rar