Desktop-Certified-Associate Exam Dumps - Tableau Desktop Certified Associate Exam

Explanation:

Refer to Nested Sort section: https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sorting_computed_howto.htm

Explanation:

Drop Sector to columns and Funded Amount to Rows.

From Analytics, drop the Median with Quartiles to your view or drop the reference line, select the Median.

Your view will look like this:

Chart, bar chart Description automatically generated

Here, the Clothing funded amount is exactly similar to the Median.

Explanation:

Tableau automatically associates discrete fields with categorical palettes

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

Explanation:

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.

Graphical user interface, application Description automatically generated

Drop the Total Death to Label.

Chart, histogram Description automatically generated

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.

Explanation:

Go to Filter card options, and Select Only Relevant values

Graphical user interface, text, application Description automatically generated

After following the steps mentioned in the question your view will look like this:

Here, 5 points are above the exponential trend line.

Drop the Country field to the view.

Drop the Region to the filters shelf and select Europe & Central Asia.

Drop the GDP per capita to the label and change the aggregation to Avg.

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.

Select the Extract connection and click on Edit as shown:

If you have single table on the canvas, then Multiple tables option remain disabled:

If you create a join, only then Multiple tables option will be enabled:

Explanation:

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

Explanation:

Create a calculated field as:

Graphical user interface, text, application Description automatically generated

Drop this field to Rows and Total Death to the Columns. And Select the Quick Table Calculation-> Percent of Total.

Graphical user interface, application Description automatically generated

Graphical user interface, application, table, Word Description automatically generated

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:

Drop the year to the Columns and change it Discrete. Drop the matches played to the Rows.

Go to the Analytics menu, drop the Distribution band to the view. Select scope as entire table.

Value Computation should be:

Your view will look like this: