Reference: https://help.tableau.com/current/pro/desktop/en-us/save_export_data.htm

When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month.

Reference: https://help.tableau.com/current/pro/desktop/en-us/dates.htm

Reference: https://help.tableau.com/current/pro/desktop/en-us/data_interpreter.htm

Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_workspace_analytics_pane.htm

2) Or, you can simply go to Data Source -> Country Tab -> Describe

As you can see, 147 members exist in this Country column!

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!

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:

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

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 🙂

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!