What chart should the analyst use to show the values across each stage of the pipeline?

A call center has requested to review their sales conversion data for the month. The analyst working on this request is trying to identify the chart that will effectively present the data, which includes: the number of leads, the number of calls made, the number of calls completed, the number of customers interested and the number of sales.

What chart should the analyst use to show the values across each stage of the pipeline?
A . Pie chart
B . Funnel chart
C . Bar chart
D . Bullet chart

View Answer

Answer: B

Explanation:

A funnel chart is a type of chart that shows the values of different stages of a process, such as a sales pipeline, where each stage represents a subset of the previous one. A funnel chart is useful for showing the conversion rate, the drop-off rate, and the potential revenue or profit at each stage12. A funnel chart would be an effective way to present the data requested by the call center, as it would show the number of leads, calls, customers, and sales, as well as the percentage of change between each stage.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 662: Data Visualization: A Practical Introduction, Kieran Healy, 2018, p. 233.