How to clear Tableau Desktop Qualified Associate Exam (TDQA 10).

Preparation Time : Minimum 4 weeks for candidates with no prior Tableau experience.

Tableau DQA is a 2 hours exam which consists of 36 questions, both theoretical and practical. All questions must be answered to complete the test(there is no negative marks) and 75 % score is needed to pass the test. Questions are either multiple-choice, multiple-answer, or True /False.

TDQA10	.
Total Time	2 hrs.
Total Questions	36
Marks distribution	2,3&4
Total Points	100
Passing Points	75

Category	Points
Mod 1 - Data Connections	22
Mod 2 - Organizing and Simplifying Data	10
Mod 3 - Field and Chart Types	16
Mod 4 - Calculations	18
Mod 5 - Mapping	8
Mod 6 - Analytics	15
Mod 7 - Dashboards	11
Total	100

TDQA Preparation Materials

• Watch all the Tableau Desktop training videos https://www.tableau.com/learn/training
• Try to solve all the online quizzes https://learningtableau.com
• Few sample question patterns…

Dataset	Global Super store -Orders,Returns,Manager sheets; Population;Volcano;World Indicator...;
1	Find the Top 20 customers by sales and in that list find the bottom rank 5 based on the profit and find out the matching customer names from the given choice.
2	How much % of 2012 sales is contributed by the customers who joined(first order) in 2012 itself
3	Trend line: Profit and Sales in the axis and draw trend line for products and find the R2 value, profit equation?
4	Find Top 2 Regions with highest return % by sales
5	Countries with lowest profit ratio
6	Reference line can be controlled by parameter?
7	How to avoid duplicate rows while joining?
8	Countries with highest avg shipping time?
9	Data Connection: Three tables(Order,Returns,Manager) join based Q
10	Which are the following options that is available in preview pane and not in meta data pane?
11	Find the forecast sales value of 2018?
12	Find the product categories which lies above the mean and beyond the standard deviation of Sales and profit graph
13	How to create an average reference line?
14	Creating Territory in maps
15	Find out the list of possible actions
16	How to set the display size for different devices
17	List of available device types
18	How highlighter works
19	Country with highest child mortality rate?
20	Total population of certain region in a particular year
21	How to show streets and highways in tableau maps
22	Scatter plots are used to compare two_____________?
23	When territories are created then tableau will change the original geographic regions in the data pane?
24	Locate the APAC regions in the map and find the range of total number of active volcano regions .
25	Clicking on clear filter symbol will clear____________?
26	Create a sales bin of 1000 and find the bin with maximum customer(customer name) count
27	Create a hierarchy of Category-Segment-Region and find the region with negative profit
28	Find the number of countries with negative profit ratio
29	From the given tableau packaged work book filter the year by 2011 and find the product categories with -ve profit

Questions	Options that I remember
dashboard - what cannot be added	image	text	blank	ppt
what cannot be used as a data source	rss	relational database	cloud	flat file
order and returns - customer who has highest return%
orders and returns- with category which one has return % >8%
one standard deviation more than mean for both sum sales and profit
highest female life expectancy in asia
highest mobile data usage
highest number of miles - which country
which country in South America has 4 bordering countries that have no sales for Tables
map given - map profit, sales and city to color, size and detail
create a bar graph - avg gdp - display total gdp on the view	{avg(gdp)}	total(avg(gdp))	fixed	sum(avg(gdp))
bar chart - what is it called	histogram	column chart
in data blending, field used for blending should be used in the viz	TRUE	FALSE
top 20 customer in each region - find out which region has double the profit% than the remaining
how many customers/categories have -ve profit
top 20 customers set - which regions have sales% more than remaining
what can be done in metadata and not in data veiw	view remote field name without drop down
find the delivery time (orderdate-shipdate). Find the category with highest avg delivery time
Quarter blue pill	discrete dimension	discrete date part	continuous dimension	continuous datepart
how to combine dimension names and take it to another level	parameter	group	filter
create sales bin of 1000$. Which bin has highest profit
how do you add an average line	analysis menu	analytics pane	data pane	data menu
Tree map - left top box is the smallest one - when you have one measure and dimension in rows and columns	TRUE	FALSE
drag measure to row or column. What does it create	axis	label
adhoc calcuations - how do you save it	drag and drop in measures/dimensions
which type can help in data refresh	export to pdf	export to image	publish to tableau server

Tips

• Mostly all the dataset files will be present in some folder in desktop itself.
• More than one data set + packaged workbook will be present.
• Do not waste your time on single question, if it is taking more time then flag and skip the question. I said SKIP!!!

                      At the end you can come back and solve it.

• Check whether all the filters are applied properly because the questions will be sometimes confusing .

All the best for your exam !!!