Tableau Desktop-Certified-Associate Tableau Desktop Certified Associate Exam Practice Test

Page: 1 / 14
Total 108 questions
Question 1

Connect to the "Global Superstore" data source and use the Orders table. Find out how many distinct customers have made 6 orders?



Answer : A

Find out the distinct orders for each customer

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:

29 distinct customers have made 6 orders.


Question 2

Connect to the "Kiva Loans - India" data source, create a chart using the continuous disbursed month (Disbursed Time field) and sum of the loan amount, exclude the null values. What is the skewness of this chart?



Answer : A

Enable the Summary Card from Show/Hide menu as shown:

Skewness is .42


Question 3

Connect to the "Kiva Loans - India" data source, find out which sector has the highest distribution of loan amount using interquartile ranges?



Answer : D

Create a box plot using Sector and Loan amount.

The IQR is maximum for the Wholesale sector.


Question 4

Connect to the "Kiva Loans - India" data source, find out the average number of days it took to disbursed the funded amount in catering activity, and what is the total funded amount?



Answer : A

Filter the Activity = Catering

Drop the activity to rows, and no of days to columns, change the aggregation to AVG.

Also, drop the Funded Amount to the Tooltip.


Question 5

What are the types of annotations available in Tableau?



Answer : A, B, D


Question 6

How to rename the Measure Names field in Tableau?



Answer : D

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


Question 7

Connect to the "Life Expectancy at birth" data source, combine sheets Data_20th century and Data_21st century. Find the moving average for the average life expectancy for 10 years before 2000 and 10 years after 2000 for New Zealand.



Answer : B

Connect to the 'Life Expectancy at birth' excel file, drag Data_20th Century sheet to the canvas. If you find data columns are not correct.

Use the data Interpreter, it will correct the data.

Select the column 1960 to 2000. And Click on the Pivot option

Rename the two new columns as 'Years' and 'Life Expectancy'

Create a Union by dragging the sheet Data_21st Century to Data_20th Century, once you see the orange block for union.

Now, select column 2001 to 2013 and Select Add data to Pivot.

Select Country and Country Name field, Merge these fields.

Rename the merged field as Country.

Let's create the view.

Drop the country to the Filters and Select New Zealand. Drop the years to the columns and 'Life Expectancy' to the Text marks card. Change the aggregation to Avg (it won't make a difference here).

Right-Click on Life Expectancy -> Quick Table Calc -> Moving Average

Again, right-click on it and edit the table calculation.

Update the values as:

Result is:


Page:    1 / 14   
Total 108 questions