Desktop-Certified-Associate Tableau Desktop Certified Associate Question and Answers

Select the measure “Death” and go to the Show Me and Click on Histogram

When we are binning the measure, it will create the dimension, so you get a new dimension as Death (bin). Right-click on this and click on Edit. Update the size of bins to 500.

Graphical user interface, application Description automatically generated

Drop the Country to the color, so our view will look like this:

Chart Description automatically generated

Now drop the Country to the filter and select 4 countries mentioned in our options.

Hover the bar, it shows the United States has reported 9 deaths.

Chart Description automatically generated

Explanation:

Using Analytics pane:

Graphical user interface, application Description automatically generated

Right Click on Axis and Add Reference Line:

Graphical user interface, application Description automatically generated

Explanation:

Graphical user interface, application Description automatically generated

Drop Region at the filter and Select Canada

Drop Profit to columns and Sub-Category to Rows

Then drop the target profit to profit axis, it will create the combined axis chart.

Chart, bar chart Description automatically generated with medium confidence

Now drop the Measure Names field from the Rows to the Color Marks Card.

Chart, bar chart Description automatically generated

Go to the Analysis menu -> Stack Marks -> Off (so that your both profit and target profit bars will start from 0)

Graphical user interface Description automatically generated with medium confidence

Tables, Labels and Copiers sub-categories has met or exceed the target profit.

Chart Description automatically generated

Explanation:

Go to the Dashboard menu -> Actions -> Add Action -> Filter

Configure the properties as:

Graphical user interface Description automatically generated

Ensure that West Region should be selected in the Region filter.

The final view should be:

Map Description automatically generated

profit increase by 0.133134 for each dollar of sales for the California state

Explanation:

Drop the State field to a view, you will get >1k unknown.

Drop the Country to the Filters Shelf and Select the United States, all unknowns should be gone.

Also, drop the Order Date to the Filters Shelf and choose Years as:

Graphical user interface, application Description automatically generated

Check for the Year 2013.

Drop the Sales field to the Label in the Marks card, your view should look like this:

Graphical user interface Description automatically generated with medium confidence

Now use the Lasso Selection tool from the Map tools:

Graphical user interface, diagram Description automatically generated

And create the group of states as per our answer options.

Example - for New York, Massachusetts, Rhode Island, Similarly, do for other 3 options as well.

Map Description automatically generated

Duplicate this worksheet and remove the Latitude and Longitude from the view and drop this new dimension of groups to the view. California, Idaho, Nevada is the right answer.

Graphical user interface, text, application Description automatically generated

Explanation:

While creating Bar in bar chart, we turn off the stacked marks so that both the bars will start from 0.

Explanation:

Find out the distinct orders for each customer

Graphical user interface, text, application Description automatically generated

Move this field from Measure to Dimension.

Drop this field to the Columns Shelf and drop customer ID to Rows, aggregate the Customer ID using CountD, and drop this field to Label as well. Your view will look like this:

Chart Description automatically generated

29 distinct customers have made 6 orders.

Explanation:

Create a box plot using Sector and Loan amount.

Chart, box and whisker chart Description automatically generated

The IQR is maximum for the Wholesale sector.

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

Bar-in-Bar Chart and bullet graphs both are used to compare the measures against goals.

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

Create a left outer join, so that we can calculate the percentage of the returned orders

Create a calculated field “% of returned orders”:

Drop the Order Date to the filters shelf and select the year 2013

Drop the Region to the rows and % of returned orders to the Text:

We can rename the field from the metadata grid, but not the remote fields.

Remote field cannot be renamed by any means from Tableau