- (Topic 3)
In a dataset, a Data Analyst has a string field named Name that contains unnecessary semicolons.
Which function should the analyst use to remove the semicolons from the Name field?

Correct Answer:D

- (Topic 3)
A Data Analyst needs to calculate the percent of regional sales that each state contributes to. As a first step, the analyst needs to calculate total sales per region.
Which calculation should the analyst use to do this?

Correct Answer:A

- (Topic 3)
What should a Data Analyst use to visualize the distribution and variability of measure values along an axis?

Correct Answer:B

HOTSPOT - (Topic 3)
You have the following visualization.


Solution:


Does this meet the goal?

Correct Answer:A

- (Topic 3)
A Data Analyst has a data source that contains the following columns:

he analyst has the following FIXED Level of Detail (LOD) expression called Region Sales:
{ FIXED [Region] : SUM([Sales]) }
The analyst has a view that has a dimension filter on the State column to exclude five states.
What should the analyst do to ensure the five states are also excluded from the LOD expression?

Correct Answer:D

- (Topic 3)
You have the following chart that shows profits and discounts over time.

You need to combine the lines to appear as shown in the following chart.

What should you do?

Correct Answer:C