SDI Data Analysis & Reporting 2 — Questions and Answers
Question 1: A service desk manager notices that first-contact resolution (FCR) rates vary significantly between agents. Which analytical approach best identifies the root cause?
- Calculate the mean FCR across all agents and report it
- Segment FCR data by agent, ticket category, and shift to find patterns (Correct answer)
- Remove low-performing agents from the dataset to normalize results
- Report only the top-quartile FCR to stakeholders
Correct answer: Segment FCR data by agent, ticket category, and shift to find patterns
Segmenting FCR by agent, ticket category, and shift isolates variables to pinpoint whether the variance is skill-, process-, or workload-driven.
Question 2: Which metric best measures the efficiency of a service desk's workload distribution?
- Total ticket volume per month
- Agent utilization rate as a percentage of available work time (Correct answer)
- Number of escalations per week
- Customer satisfaction score (CSAT)
Correct answer: Agent utilization rate as a percentage of available work time
Agent utilization rate directly reflects how effectively available capacity is being used relative to actual work time.
Question 3: When building a service desk dashboard, which principle ensures KPIs remain actionable rather than decorative?
- Include as many metrics as possible to show completeness
- Link each metric to a specific business outcome or decision (Correct answer)
- Use bright colors to make the dashboard visually engaging
- Update the dashboard only when requested by senior management
Correct answer: Link each metric to a specific business outcome or decision
Tying each KPI to a business outcome ensures the data drives decisions rather than serving as a vanity display.
Question 4: A service desk wants to predict ticket volume spikes. Which data analysis technique is most appropriate?
- Pareto analysis of past incident categories
- Time-series forecasting using historical ticket volume data (Correct answer)
- Root cause analysis of the top five recurring incidents
- Benchmarking against industry average ticket volumes
Correct answer: Time-series forecasting using historical ticket volume data
Time-series forecasting models historical patterns and trends to predict future volume spikes.
Question 5: In SDI reporting, what does an 'abandoned call rate' exceeding the target threshold most directly indicate?
- Agents are resolving tickets too slowly
- Customers are hanging up before being answered, pointing to understaffing or long wait times (Correct answer)
- The CSAT survey response rate is too low
- Ticket backlog is growing due to poor categorization
Correct answer: Customers are hanging up before being answered, pointing to understaffing or long wait times
A high abandoned call rate means callers disconnected before reaching an agent, which typically signals insufficient staffing or excessive queue times.
Question 6: Which chart type is most effective for displaying the distribution of incident resolution times across a large dataset?
- Pie chart
- Histogram (Correct answer)
- Stacked bar chart
- Line chart
Correct answer: Histogram
A histogram groups continuous data like resolution times into frequency bins, clearly showing the distribution shape and outliers.
Question 7: A service desk analyst is comparing SLA compliance rates across three months. Which statistical measure best summarizes the central tendency while minimizing the effect of outlier months?
- Mode
- Range
- Median (Correct answer)
- Standard deviation
Correct answer: Median
The median is resistant to outliers, making it the best central-tendency measure when extreme values could distort the picture.
A service desk manager notices that first-contact resolution (FCR) rates vary significantly between agents.
Which analytical approach best identifies the root cause?