Desktop-Certified-Associate Exam Dumps - Tableau Desktop Certified Associate Questions and Answers

Explanation:

Drop Order Date to columns, Category to Rows, and Sales to Text.

Go to Analysis -> Totals -> Show Columns Grand Total

Graphical user interface, text, application Description automatically generated

Update Total All Using to Average:

Graphical user interface, text, application Description automatically generated

Table Description automatically generated

In the year 2012, the furniture sales were more than the average sales of that year.

Explanation:

Create a hierarchy of Segment, Category, Region and drop it into the rows.

Text Description automatically generated

Create profit ratio calculated field:

Graphical user interface, text Description automatically generated

Drop the profit and profit ratio fields to the view, your view will look like this:

Graphical user interface, text, application Description automatically generated

Now let's go through each answer option.

1) The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment - The profit ratio is -142.26% which is lowest overall so it is true.

2) The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765 - It is true, the profit ratio is 2.06%, which is third-lowest.

3) The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment - False, it is having a $2,245 profit.

4) The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment - False

Note: This is an easy question but time consuming, so attempt these types of questions in the end.

Explanation:

Go to the Map -> Map Layer

Cities Borders is not valid.

Graphical user interface, text, application, chat or text message Description automatically generated

Explanation:

Select New York State, you are getting only 3 products, and not 5.

Timeline Description automatically generated

You need to add State as a Context filter in the Top 5 profitable products View. For that, go to the Top 5 profitable products sheet. (click on small arrow)

Chart, bar chart Description automatically generated

Select Add to Context on the State filter

Graphical user interface, text, application, chat or text message Description automatically generated

A picture containing graphical user interface Description automatically generated

Custom geocoding means that you assign latitude and longitude coordinates toyour locations

so Tableau can plot them accurately.

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

Approach 1 – Using Groups

Drop the Customer ID to the Rows.

Add sub-category to the filter and select phone.

Add Order date to the filter and select the year 2014.

Select all the customers and click on paper clip icon to create the group.

So here we got all the customers who have purchased any product in the Phones subcategory

in 2014.

Edit the group and select Include other

Clear the filter shelf, and again add Order date to the filter and select 2015.

Drop Sales to the Text.

Add ‘Percent of Total’ Quick Table Calculation to the Sales field.

Your view will look like this:

Approach 2 – Using LOD

Create a LOD expressions as:

It will return 1 for the customers who have purchased any product in the Phones sub-category

in 2014. For others, it will return 0.

Drop this field to the Rows and add Order date to the filter and select the year 2015.

Explanation:

Add Product Name filter that contains the word Avery

Graphical user interface, text, application, email Description automatically generated

Drop the Customer ID to the rows, so these are all customers who have purchased the product contains the word Avery.

Select all these Customers and create a group.

Graphical user interface, text Description automatically generated

Now, right-click on the Customer ID (group) and click on Edit Group

Mark the Include 'Other' Checkbox.

Graphical user interface, text, application Description automatically generated

Now, you have two members in your group. First, one of those who purchased any product contains the word Avery, and the other ones are the rest of the customers.

Remove the Product Name from filters.

Drop the Sales to the Text, and right-click on Sales and Select Quick table calculations -> Percent of total.

Graphical user interface, text, application, chat or text message Description automatically generated

Explanation:

Measure Names is Tableau generated field, so you cannot rename it.

Explanation:

Cube data sources can only be used as the primary data source for blending data in Tableau.

All others are true.

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

Explanation:

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