Desktop Specialist Exam Questions PDF download

QUESTION: 56

Which Sub-Category had the least Profit in the Office Supplies category?

Fasteners
Labels
Envelopes
Binders

Answer(s): A

Explanation:

To reach the correct answer, follow the steps below:

1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf

2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:
Click the 'Show mark labels icon'

As we can see, Fasteners has the least Profit in the Office Supplies Category, and hence is our correct answer!

Reveal Solution Next Question

QUESTION: 57

Create a Set containing Customer Names whose Sales are GREATER than 30,000.
Which customer had the LEAST sales in this set?

Tom Ashbrook
Sanjit Engle
Penelope Sewall
Tamara Chand

Answer(s): C

Explanation:

As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000
1) Right click on customer name --> Create --> Set

2) Let's Name the Set - Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:

3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK

4) You should now have a new Set in the Data Pane as follows:

5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.

6) Click on the Show Mark Labels, and Sort ascending icons as shown:

7) Voila! We have our answer:

c

Reveal Solution Next Question

QUESTION: 58

Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view.
What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?

5,129 and 88,872
52,678 and 311,404
1,807 and 34,571
4,888 and 17,817

Answer(s): D

Explanation:

To reach the correct answer, follow these steps:

1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:

2) Drag Profit to Text in the Marks Shelf as shown:

3) Click on Analysis as shown -> Totals -> SELECT ROW GRAND TOTALS The following will be the final view:

You could also Filter by Region to only Focus on Canada, but that's your choice:

THEREFORE,

2012 = 4,888
2011 -> 2014 = 17,817

Reveal Solution Next Question

QUESTION: 59

Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan.
What was the average Quantity in the State of Tokyo?

3.000
3.840
3.704
3.500

Answer(s): C

Explanation:

Since we need to focus on 1 country -> Japan, let's filter on it first as follows:

1) Drag Country to the filter shelf, and choose only Japan. Click OK.

2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:
Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.
Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.

The following is our visualisation:

Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME. Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)

Reveal Solution Next Question

QUESTION: 60

Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM.
Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

Brazil
Peru
Argentina
Mexico

Answer(s): D

Explanation:

VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION

1) To find the number of days between order date and shipping date, we will make use of a calculated field:

In the data pane, click on the dropdown arrow, and choose create calculated field.

Let's name this calculated field "ShippingDelay" (you can name it anything you want :) )

2) Use the DATEDIFF() function, and pass it the arguments as follows:

'day' depicts that we want to calculate the number of DAYS between the two dates. The first argument is 'start_date' which is the ORDER_DATE (day the order was placed), the second argument is 'end_date', which is the SHIP_DATE (date the order was shipped). So by subtracting as follows:
SHIP_DATE - ORDER_DATE, we can find the delay in shipping.

Click OK.

3) You should now have a new measure as follows:

4) Phew! The hard part is done! Now let's filter by Market to include only LATAM:

5) Drag Country to the view, and the new calculated field 'ShippingDelay' to SIZE on the Marks Shelf as follows:
*You can also click on Show Text Labels to be sure that you're choosing the Largest value*

Clearly, Mexico has the highest Shipping Delay!