Tableau Desktop Certified Associate Exam Practice Test

Page: 1 / 14
Total 108 questions
Question 1

Connect to the "Global Superstore" data source and find out which region was having the highest percentage of returned orders in 2013?



Answer : B

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:


Question 2

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 3

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 4

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 5

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 6

What are the types of annotations available in Tableau?



Answer : A, B, D


Question 7

Connect to the "Kiva Loans - India" data source, which sector's funded amount is closest to the median of all the sectors?



Answer : B

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:

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


Page:    1 / 14   
Total 108 questions