Question 1

A business analyst designs a visualization to analyze a count of products by fixed price ranges. The customernow wants the price ranges to be dynamically modified so they are configurable by the application users. Thebusiness analyst modified the dimension axis on the visualization.Which step should the business analyst complete next?

Options :

A : Define a variable and use it in a variable input object on the sheet

B : Create a calculated field in Data manager, using the Class() function

C : Load an independent source file to contain the user-defined boundary values

D : Create the price range dimension using the Buckets feature in Data manager

Answer: A

Question 2

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

following:

• Ability to look for outliers on sales volume and margin %

• Ability to understand the clustering of products visually

• Ability to see products that are above the median sales volume

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

Options :

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

Answer: D

Question 3

A business analyst designs a visualization to analyze a count of products by fixed price ranges. The customer

now wants the price ranges to be dynamically modified so they are configurable by the application users. The

business analyst modified the dimension axis on the visualization.

Which step should the business analyst complete next?

Options :

A : Define a variable and use it in a variable input object on the sheet

B : Create a calculated field in Data manager, using the Class() function

C : Load an independent source file to contain the user-defined boundary values

D : Create the price range dimension using the Buckets feature in Data manager

Answer: A

Question 4

A business analyst is working with retail data for consumer products. The customer is interested in thefollowing:• Ability to look for outliers on sales volume and margin %• Ability to understand the clustering of products visually• Ability to see products that are above the median sales volumeWhich action should the business analyst take to implement these requirements?

Options :

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

Answer: D

Question 5

The sales manager is investigating the relationship between Sales and Margin to determine if this relationship

is linear when choosing the dimension Customer or Product Category.

The sales manager wants to have the potential percentage Sales for each Stage (Initial to Won) of the sales

process.

Which visualizations will meet these requirements?

Options :

A :

Scatter plot: Measures X-axis Sales and Y-axis Margin, Dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales

B :

Scatter plot: Measures X-axis Sales and Y-axis Margin, Alternative dimensions Customer or Product category Funnel chart: Segments Stage, Width Sales

C :

Combo chart: Measures Sales and Margin, Dimensions Customer or Product category Pie chart: Dimension Stage, Measure Sales

D :

Distribution plot: Alternative measures Sales and Margin, Alternatives dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales

Answer: B

Free QSBA2024 Mock Exam – Practice Online Confidently

Buying Options: