An analyst is designing a dashboard that will provide a story of the sales and sales customer ratio. The following data is available: Which of the following charts should the analyst consider…

Question

Exhibit

Options

• AA column chart with site and sales
• BA line chart with site and sales
• CA pie chart with site and sales
• DA scatter chart with site and sales

• A
  77% (24)
• B
  6% (2)
• C
  13% (4)
• D
  3% (1)

Explanation

For a dashboard that aims to tell a story about sales and the sales customer ratio, a column chart is an effective choice. Column charts are particularly useful for showing data changes over a period of time or for illustrating comparisons among items. In this case, a column chart can clearly display the sales figures for each site, allowing for easy comparison across different sites. Additionally, it can be used to represent the sales customer ratio by showing the proportion of sales per customer, which can provide insights into customer behavior and sales effectiveness. Line charts are best suited for displaying data trends over time, rather than for comparing individual categories. Pie charts could show the proportion of sales for each site, but they are not as effective as column charts for comparing multiple categories. Scatter charts are used to show the relationship between two variables, which is not the focus in

No community discussion yet for this question.