CompTIA Data+ (DA0-002)VisualizationMedium

A data analyst is designing a dashboard for a call center to monitor agent performance. The dashboard needs to display key metrics such as average call handling time, first call resolution rate, and customer satisfaction scores. To draw immediate attention to agents whose performance falls below predefined thresholds (e.g., call handling time > 5 minutes), which design element is MOST effective?

  1. AIncluding detailed data tables for each metric
  2. BConditional formatting with color-coding
  3. CUsing a minimalist design approach
  4. DConsistent chart types across all metrics
Show answer & explanation

Correct answer: B. Conditional formatting with color-coding

Conditional formatting uses color or other visual cues to highlight data points that meet specific conditions or fall outside acceptable ranges. This allows users to quickly identify performance issues without manually scanning all data.

Why the other options are wrong

  • A. Detailed data tables provide information but require manual scanning to identify issues, which is less efficient than visual cues.
  • C. Minimalist design reduces clutter but doesn't inherently draw attention to underperforming agents.
  • D. Consistent chart types improve readability but don't highlight specific performance issues.

Conditional Formatting

A visual design technique that applies specific formatting (e.g., color, icons, font styles) to data points in a visualization when certain conditions or rules are met.

  • Draws immediate attention to critical data points or outliers.
  • Helps users quickly identify trends, patterns, or anomalies.
  • Commonly used to highlight values above/below thresholds, or within specific ranges.

Memory trick: Conditions trigger formatting, like traffic lights changing color.

More Visualization questions