Question $1$:

Use the data provided in the Excel workbook entitled $$Ongoing project $($part $6)$ to create a business dashboard using Microsoft Excel. The first worksheet in the workbook, called $$Question $1-$ Data$,$ contains Sonic Selections order information. Create informative graphs and charts using Excel$$s graphing functions, and consolidate all the information onto one worksheet to create a business dashboard. Your workbook may contain a number of worksheets that you use to organise the data and create tables and charts, but you will only be marked on the business dashboard you put together. The dashboard should appear in the worksheet called $$Answer $1-$ Business dashboard$.$

Create a business dashboard for an audience of your choice, using whatever aspects of the data you find most important. You will be marked on the following aspects of your business dashboard:

$$ Dashboard layout and organisation: Be sure to plan your dashboard and components before you start to build it to ensure that you make the most of your dashboard screen.

$$ Appropriateness of dashboard in context: Be sure to consider your intended audience and select the type of information they will be interested in$.$

$$ Formatting and style: Use the best$-$practice guidelines to choose the most appropriate font, colours, and language, and ensure that the style will speak to the intended audience.

$$ Data quality and analysis: Prepare and clean your data before building the required dashboard components, and ensure that it is appropriately organised to create meaningful charts and graphs.

$$ Charts and graphs: Ensure that all the graphs and charts included in the dashboard meet the best$-$practice standards, and that the most appropriate type of graph is selected for the type of data.