Free QSBA2024 Web TestEngine Demo

Q6 Single choice

A business analyst is working with retail data for consumer products. The customer is interested in the following:

1. Ability to look for outliers on sales volume and margin %
2. Ability to understand the clustering of products visually
3. Ability to see products that are above the median sales volume

Which action should the business analyst take to implement these requirements?

A
Create a pivot table and color the sales volume cell using K-Means function and median sales volume as an additional column
B
Create a treemap visualization showing sales volume and margin% by product with the median sales volume in the title
C
Create a combo chart with K-Means colors for the bar and a line measure representing median sales volume
D
Create a scatter plot using K-Means to color the products and add a median sales volume reference line

QSBA2024 Web TestEngine demo