QUESTION: 37 Exam Topic: 2, Exam Pool B

Connect to the "Global Superstore" data source and use the Orders table. Find out the average quantity ordered by customers whose first name starts with an 'S' alphabet?

3.43
3.56
4.02
3.39

Answer(s): B

Explanation:

Create a Calculation to get the first alphabet of the customer name.

Now drop the First Alphabet field to Rows and Quantity field to the Text on the Marks card. Change the aggregation from SUM to AVG. Your view will look like this:

Reveal Solution Next Question

QUESTION: 38 Exam Topic: 2, Exam Pool B

View Related Case Study

Connect to the "Global Superstore" data source and use the Orders table. Predict the profit of January 2016 using the profit data through December 2015.
What is the profit value of January 2016?

$35,152
$33,759
$46,917
$39,921

Answer(s): A

Explanation:

Drop the Orders Date to the Columns shelf and change it to the Month Date Value and drop the profit to the rows shelf. Your view will look like this:

Go to the Analytics tab and drop the Forecast to your view. Right-Click on the view, Select Forecast -> Forecast Options. Change the Ignore last to 0 months,

$35,152 is the correct answer.

Reveal Solution Next Question

QUESTION: 39 Exam Topic: 2, Exam Pool B

View Related Case Study

Why we convert a numeric measure to a dimension?

To aggregate the field
To show the labels in your view
To use this field in LOD
To disaggregate the field

Answer(s): D

Explanation:

Measures are by default aggregated. We can change measures to dimensions if we want disaggregate that field.

Reveal Solution Next Question

QUESTION: 40 Exam Topic: 2, Exam Pool B

View Related Case Study

Connect to the "Significant Volcano Eruption" data source. In 1899, the Dona Juana volcano erupted in Colombi

Find out which volcano in the Popayán city is the closest to Dona Juana and how many death Dona Juana volcano caused?
Purace, 55
Galeras, 55
Purace, 0
Galeras, 0

Answer(s): A

Explanation:

Drop the Latitude and Longitude fields to Rows and Columns shelf respectively. Or double click on these fields.

Drop the Location field to Filter shelf, select the Location as Colombia.
Drop the Name field to the Label.
To show the cities go to the Map -> Map layer and Check the Cities.

Drop the Deaths and Year fields to the Tooltip. Now your view looks like this:

Zoom-in the map, you will find Purace is the nearest one in the Popayán city and Dona Juana was having 55 deaths.