Question 1

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

Question 2

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 3

A business analyst is creating a data model from several Excel files that contain several hundred thousand rows of data. The requirements include: • Users need to drill down to various details within the available data set.

• Several final measures will be repeatedly used. These final measures require combining several fields in a

single table.

• User experience and load time is a high priority.

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

Options :

A : Aggregate the data to the source period

B : Develop a master item using the required source fields

C : Combine the various source fields in a calculated item in the Data manager

D : Combine the source fields and create additional fields in Excel

Answer: B

Question 4

The sales manager is investigating the relationship between Sales and Margin to determine if this relationshipis 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 salesprocess.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

Question 5

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

Free QSBA2024 Mock Exam – Practice Online Confidently

Buying Options: