nerdexam
CompTIA

DA0-002 · Question #25

The sales department wants to include the composition of total sales amounts across all three sales channels in a report. Given the following sample sales table: Which of the following…

The correct answer is B. Pie chart. To visualize the composition of total sales amounts across three sales channels, a pie chart is the most appropriate visualization. A pie chart effectively shows the proportion of each category relative to the whole, making it ideal for displaying parts of a total.

Visualization and Reporting

Question

The sales department wants to include the composition of total sales amounts across all three sales channels in a report. Given the following sample sales table:

Which of the following visualizations is the most appropriate?

Options

  • APivot table
  • BPie chart
  • CKPI card
  • DBox plot

How the community answered

(23 responses)
  • B
    87% (20)
  • C
    9% (2)
  • D
    4% (1)

Why each option

To visualize the composition of total sales amounts across three sales channels, a pie chart is the most appropriate visualization. A pie chart effectively shows the proportion of each category relative to the whole, making it ideal for displaying parts of a total.

APivot table

A pivot table displays data in a tabular format, allowing for aggregation and summarization, but it doesn't offer a visual representation of proportions as effectively as a chart.

BPie chartCorrect

A pie chart is best suited for showing the proportion of different categories relative to a whole. When depicting the composition of total sales amounts across three sales channels, a pie chart clearly illustrates how much each channel contributes to the overall sales.

CKPI card

A KPI (Key Performance Indicator) card typically displays a single, important metric or value, often with an indicator of performance against a target, not a breakdown of composition.

DBox plot

A box plot (or box-and-whisker plot) is used to display the distribution of numerical data and identify outliers, which is not suitable for showing the composition of a total across categories.

Concept tested: Data visualization - pie chart

Source: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-visualization-pie-donut-charts

Topics

#Data visualization#Chart types#Pie chart#Reporting

Community Discussion

No community discussion yet for this question.

Full DA0-002 Practice