Exactprep Desktop-Specialist Questions

Date values in Tableau represent specific points in time and are typically formatted in a standard date format.

• Option A, "2020-05-01", is a standard date format representing the 1st of May, 2020.
• Option D, "January 1, 1995", is another example of a date value, representing the 1st of January, 1995. Options B ("December") and C ("Wednesday") represent a month and a day of the week, respectively, but do not specify a particular date.

Explanation

Follow along to reach the correct answer:

1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:

Click on Date in the Column shelf and convert it to continuous month :

2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:

3) Finally, click on the Show mark Labels icon:

4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:

Explanation

If you chose 2, then you were very close but probably didn't plot the actual Percent Difference on your view. ( One of the marks is just over the line).

• Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both Year and Quarter as mentioned in the question.
• 2) Next, Drop assortment to filters shelf so that we can focus on Electronics!

3) This should be your view now. Click on the Show Mark Labels icon as shown:

The final view is as follows, with 3 points below 0 ( i.e negative )

Explanation

Here's how to add image files to your repository:

1) Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags.

2) Download the image to your computer.

3) Drag images into your My Documents -> My Tableau repository -> Shapes folder.

4) Open Tableau and your new shapes will automatically be included in your "edit shapes" menu.