Tableau Desktop Certified Associate Practice Test - Questions Answers, Page 5

{ Exclude [City] : SUM([Sales])} => using this calculation we can exclude the City dimension from all the dimensions present in the view. So here SUM(sales) would be the aggregation of sales in the state level only, even though city field is available in the view.

If customer first order is equal to the order date, then this is the new customer.

Create a calculated field to find the first order date:

Find If the order date is equal to the day of first purchase for that customer, flag that row as a

'New Customer'

Find the unique customers:

Drop the Order date to filter shelf and select the year 2014 to find out the new customer acquired in 2014.

Drop New Customer field to Rows and Unique customer field to Text marks card.

Custom geocoding means that you assign latitude and longitude coordinates to your locations so Tableau can plot them accurately.

Refer: https://help.tableau.com/current/pro/desktop/en-us/custom_geocoding.htm

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.

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

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 Popayn city and Dona Juana was having 55 deaths.

The first option is wrong here, you can turn on the highlighter only for the discrete fields in your view.

Refer: https://help.tableau.com/current/pro/desktop/en-us/actions_highlight_highlighter.htm

{ FIXED [Category] : SUM([Profit])} - It calculates the profit of each category. In our view, all the profits values are the same, so it is not the right answer.

{ FIXED [Region] : SUM([Profit])} - It calculates the profit of each region.

{SUM([Profit])} is equivalent to {FIXED : SUM([Profit])}. It is the table level scope, which means this is the profit of the entire dataset.

Select the 'Elevation' field from measures, and go to show me. Click on Histogram.

Right-Click on the 'Elevation (bin)' dimension and select Edit. Change the size of bins to 1000.

Drop the Total Death to Label.

The total number of deaths reported in the bin of 2000.

Note that the lower limit is inclusive. So 2000 bin means 2000 to 2999.