Thank you for choosing our mock test.

We used to take the Tableau Desktop Certified Associate exam ourselves.

Solve all the questions and feel more confident during the exam.

There are 36 questions ahead of you, prepared according to the patterns of questions appearing in Tableau certification exams. The questions will test your knowledge of Tableau software, each of them may have more than one correct answer.

All questions concern Superstore sample database data, available as open-source base data in Tableau. All questions refer to the Orders sheet, unless otherwise specified.

***

*Please be advised that Vizyble sp.z o.o. sp.k. in Katowice is the administrator of your personal data. The rules for the processing of personal data are regulated in the privacy policy.**You are subscribing to the newsletter, remember that you can unsubscribe at any time by e-mail: info@vizyble.com*

The times has eneded!

Tableau Mock-up Test

1 / 36

What is the percent of total Sales for the ‘Corporate’ Customer Segment in May of 2012 in US?

2 / 36

How many unique products (Product ID) took an average of 5 days to ship (time period from when the order was placed to when ii was shipped)?

3 / 36

Use Order Date to determine 6 months moving average of Sum of Profit for May 2012 (not including).

4 / 36

What is the name of product with the maximum Shipping Cost for APAC Market?

5 / 36

Use Returns Sheet and Orders Sheet to calculate percentage of orders (Order ID) which were returned.

6 / 36

What percent of total profits did the the top 5 countries from Africa by Sum of Sales represent?

7 / 36

Create a hierarchy containing Segment - Market - Sub-Category, and then create a vizualization showing Profit Ratio for this hierarchy. Which Segment - Market - Sub-Category row has the highest Profit Ratio?

8 / 36

Create a histogram showing the number of Sales using Sales Bins of $5 000. What is Sum of Quantity for bins 15K and 20K?

9 / 36

Build a scatter plot showing the Sum of Profit on the x-axis and Sum of Sales on the y-axis for all cities. What is R-Sqared value for Exponential Trend Line?

10 / 36

In which Market do all Categories fall above the overall average Sales? (select all that apply)

11 / 36

For the EU, which country has the biggest profit difference between the values of the largest and the smallest segment?

12 / 36

Which Ship Mode has a Shipping Cost to Sales ratio higher than average Discount? (select all that apply)

13 / 36

Create time serie using Quarters from Order Date and Sum of Sales. What is the Sales prediction for 2016 K1?

14 / 36

What is the distance between two postal codes locations with the biggest Sum of Sales in Los Angeles (US)?

15 / 36

What is the the second most purchased Product Name by customers for the first time?

16 / 36

Find the Market with the lowest overall profit. What is its profit ratio?

17 / 36

What is the Sum of Sales growth rate from 2013 to 2014 in UK, Germany and France combined?

18 / 36

Using Return sheet and Orders sheet identify the manager (Person) with the lowest overall year over year growth?

19 / 36

Is the overall average for Quantity in 2013 higher or lower than the average for only July, August and September (from 2013 year)?

20 / 36

Using People Sheet and Orders Sheet, which manager (Person) will have estimated value of Sum of Sales in 2015 above 500 000$? (select all that apply)

21 / 36

Create a histogram showing the number of Sales using Sales Bins of $1000. How many bins have Profit Ratio of less than 1%?

22 / 36

What is the profit ratio of the province in Nigeria which borders the country of Chad?

23 / 36

Which product has the highest Sum of Sales in more than one region? (select all that apply)

24 / 36

What percent of the total Sales do the top 5 customers by Profit represent?

25 / 36

Build a scatter plot showing the Sum of Sales on the x-axis and Sum of Profit on the y-axis for all products (Product ID). What is the equation for the linear regression for products in Furniture Category?

26 / 36

Which sentence is incorrect about density map?

27 / 36

A dimension:

28 / 36

Which of these values is not shown on the box-plot diagram?

29 / 36

A Reference Line can be controlled by a parameter.

30 / 36

Bullet graph is proper choice for:

31 / 36

Fields with name containing words like "ID" or "Key" would be categorize by Tableau as measures, if they have numeric values.

32 / 36

Which sentence is correct about data blending? (select all that apply)

33 / 36

Dimension Filters are executed before: (select all that apply)

34 / 36

If you use a full outer join to combine tables and a value from either table doesn't have a match with the other table, you will see a null value in the data grid.

35 / 36

Which sentences are correct about Data Extracts?

36 / 36

Which LOD expression compute a value without reference to the dimensions in the view.

Your score is