Desktop Certified Associate: Tableau Desktop Certified Associate
Tableau
Exam Number: Desktop Certified Associate
Exam Name: Tableau Desktop Certified Associate
Length of test: 120 mins
Exam Format: Multiple-choice questions.
Exam Language: English
Number of questions in the actual exam: 36 questions
Passing Score: 750 out of 1000
This study guide should help you understand what to expect on Desktop Certified Associate exam and includes a summary of the topics the exam might cover and links to additional resources. The information and materials in this document should help you focus your studies as you prepare for the exam.
Related questions
When we create a filter action in a dashboard, what all we must specify so that it will work?
Explanation:
Even if you don't select the target filters, your filter action will work. Rest all you need to provide so that it will work.
Use custom geocoding, when you need ___________ locations to map your data.
Explanation:
Custom geocoding means that you assign latitude and longitude coordinates to your locations so Tableau can plot them accurately.
Refer: https://help.tableau.com/current/pro/desktop/en-us/custom_geocoding.htm
Connect to the Olympic Athletes data source, which athlete won at least one gold in 2008 Olympics and then won at least 4 golds in 2012 Olympics.
Explanation:
Find out how many gold medals each athlete won in the 2008 Olympics
Drop Athlete to Rows and 2008 golds to the Text. Drop gold medals to the view. Your view will look like this:
Now we need work on 'won at least 4 golds in 2012 Olympics'
Drop years to filters and select 2012.
Drop Gold Medals to filter and mention 4 in range of values (as we need to find athletes who won at least 4 gold medals)
Final view:
I have a view that shows the top 5 countries as per the sales, I also have a region filter, but most of the region filter values we don't need. For example - We don't have any country which is part of the Eastern Europe region. So we want to hide all those regions which are not valid here. How to do it?
Larger image
You are unable to join two tables because tableau throws the type mismatch error. How you can solve it most likely?
Explanation:
Use join Calculations while joining two tables.
Connect to the 'Global Superstore' data source and use the Orders table. Predict the profit of January 2016 using the profit data through December 2015. What is the profit value of January 2016?
Explanation:
Drop the Orders Date to the Columns shelf and change it to the Month Date Value and drop the profit to the rows shelf. Your view will look like this:
Go to the Analytics tab and drop the Forecast to your view.
Right-Click on the view, Select Forecast -> Forecast Options. Change the Ignore last to 0 months,
$35,152 is the correct answer.
Which of the following are valid calculations?
Connect to the Olympic Athletes data source, find out how many countries participated in 5 different sports from 2000 to 2012?
Explanation:
First, find the distinct sports for each country:
It will be created as a Measure, move this to Dimension
Get the distinct countries:
drop these columns to the view, final view will look like this:
The X-axis represents a number of distinct sports. As the data set contains data from 2000 to 2012, so even if you don't include the filter, your answer would remain the same.
Which type of sort is applied in the Ship Mode field?
Larger image
Explanation:
Refer to Nested Sort section: https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sorting_computed_howto.htm
You need to create a filled map using the City field, you drop the City field to your view. And you get the location error 'Ambigious', what does it mean, and how you will fix this issue?
Larger image
Explanation:
Click on the State/Province list, and select the State. So Tableau will recognize the city as part of the states in the Country/Region United States.
Question