Tableau證書考試官方模擬考題+解題過程(一)

blank

Tableau證書考試官方模擬考題+解題過程(一)

前言:試題是在Learning Tableau 上花$購得,解題的過程是對優秀軟體的充分體驗,對數據的處理有翻手為雲,覆手為雨的淋漓快感。 免費分享給同筆主一樣熱愛一切美好事物的有志青年。

Tableau在最新的數據可視化魔力象限里當仁不讓的領頭羊,也有最大的客戶群。 在北美準備Tableau的Desktop Qualified Associate證書,不是easy的過程。 通往數據分析師的道路上,總有雞湯無數,也許是每種技能的get, 都是無數腦細胞的training和fit。 It's not easy, but have fun.

原創,為官方【試卷一】的前一半題目+解題過程+官方標準答案,轉載請註明出處。


Tableau Desktop Qualified Associate (DQA) 考試2小時36道題,包含knowledge和hands-on兩類題型。 Hands-on類型會提供dataset下載。

Protected: Tableau 10 Practice Exam

  1. Answer the questions using the

For films where Disney was not the lead studio, what was the % decrease in profitability from 2010 to 2011?

A. 55.3%

B. 7.2%

C. 11.59%

D. 86.28%

blank
把 [Lead Studio]拖入Filter, 並反選"Disney"

blank
按兩下 [Year] 和 [Profitability]並選擇 Bar Chart 生成柱狀圖

blank
點擊 SUM(Profitability) 的下拉箭頭,選擇 Quick Table Calculation --& amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; gt; Percent Difference

blank
在2011的Bar上找到Percentage Difference的答案

Answer: B. 7.2%

2. Answer the questions using the

For boys born between 2000 and 2012, the most common first letter for the top name by state was:

A. W

B.M

C. J

D. D

blank
添加Filters: Gender: M, Year: 2000-2012; 添加Calculation Field, 計算Top Name的First Letter

blank
將 State, Occurences 和計算域 First_Letter_of_Top_Name 拖入sheet形成 text table. 排序Grand Total后,找到最多出現的首字母是 J.

Answer: C. J

3. Answer this using the

Find the total sales value for all product subcategories for customers who ordered office furnishings.

A. 3,864,069

B. 8,119,645

C. 2,258,326

D. 2,786,637

Tips: 這道題並非單純求subcategory的sales, 而是求買了office furnishings的customers在所有subcategories的total sales.

這個計算域是生成一個flag, 標識customer是否買了office furnishings。 對於同一customer, 可能會有多個order, 一旦某個order中包含office furnishings,IF選項會滿足並返回1,用了MAX() 表示只要有返回1的 (無論有幾個1),則最終結果為1。 用Min不可以。 這個邏輯想清楚,你就明白為何用Max了。 後面有不少場景也用Max()的情況。

blank
添加Calculation Field如上
blank
將新添加的計算域拖到Dimension中,再拖到sheet中,再拖入Sales到sheet. 匯總到『1』的結果即為答案

Answer: A. 3,864,069

4.Answer this question with the

How many players have the first name “Anna”

A. 1

B. 2

C. 3

D. 4

blank
Split [Name], 並重命名分裂成的兩列分別為 First_Name和Last_Name
blank
添加計算域,用於判斷First_Name是否為Anna, 是的話返回1
blank
添加計算域,用於計算不重複的player數量
blank
將新添加的 "Firstname_Anna?" 的計算域拖到Dimension里。 如圖,匯總到1的即為答案

Answer: B. 2

5. The AVG function does not treat null values as zeros. Rather, the AVG function ignores null values.

A. True

B. False

Answer: A. True

6. Answer this question with the

Using the Players sheet, what percent of pitchers and catchers had a batting average above 0.300 and had fewer than 10 runs?

A. 36.54%

B. 63.46%

C. 19.23%

D. 80.77%

E. 80.23%

blank
添加計算域,判斷是否滿足題目條件。 如是,返回1.
blank
將計算域"Satisfied?" 拖到Dimension里,再拖入sheet中,再將上題中添加的"#Players"拖入sheet中。 添加Position的Filters, 選擇pitchers and catchers。 再修改為Percentage

Answer: C. 19.23%

7. An aggregated calculation can be multiplied by a non-aggregated constant.

A. True

B. False

Answer: A

8. Answer this question with this

How many failed votes were there for bills where the Sponsor Party was Republicans (coded as R) from Colorado (coded as CO) in 2013?

A. 3

B. 36

C. 78

D. 66

E. 1,188

解題第一步,將Data Source裡Bills和Sunlight Info兩個Sheets以LEFT JOIN的方式聯結在一起。 然後再添加Filters以及必要的計算域。

blank
判斷是否是2013年
blank
計算Bills的數量。 注意這裡用了COUNT而非COUNTD,因為不同votes可能共用bill number.
blank
添加如圖所示Filters, 並拖入新增的計算域 「#ofBills」 即得結果36.

Answer: B. 36

9. Answer this question with this

New England consists of the following states: Connecticut, Maine, Massachusetts, New Hampshire, Rhode Island, and Vermont. Which year saw the greatest increase in adults on probation?

A. 1998

B. 2002

C. 2009

D. 2011

blank
在Dimension [F1]中找到New England的6個國家,右鍵組成Group, 在生成的group上右鍵選擇"Keep Only".
blank
將Measures里的1997至2012年全選,並拖到Sheet中。 注意在右上角"Show Me"圖形選擇中選擇"side-by-side bars". 在生成的side-by-side bars中可以看出2002年有最大的增量。

Answer: B. 2002

10. Answer this question with the Teams 2014 and Games worksheets on the

The Games data includes information on games played in 2015, including showing the team that won each game. Which team had the biggest increase in winning games between 2014 and 2015?

A. Lightning

B. Knights

C. Bears

D. Ninjas

blank
將Data Source中將Games和Team 2014聯接(Inner Join)在一起,聯接方式如圖。
blank
增加兩個 Calculation Fields 分別計算2015年獲勝數量,以及2014至2015年每個隊勝率增加百分比。
blank
以text table方式分別顯示每個隊2014年獲勝次數,2015年獲勝次數以及增加比例。 最大為Ninjas.

Answer: D. Ninjas

11. Answer this question with the Teams 2013 and Teams 2014 worksheets on the

Which team had the biggest decrease in games won from 2013 to 2014?

A. Lions

B. Bears

C. Tigers

D. Lightning

blank
增加計算域,計算2013至2014的decrease百分比
blank
將Team和計算域"% decrease"拖到sheet中,得了decrease最多的隊為Lions.

Answer: A. Lions

12.Using the

What was the month and year with the largest absolute increase in average Open value from the same month in the prior year?

A. January 2015

B. January 2016

C. March 2016

D. March 2015

E. None of the above

方法1:很有意思一題。 在Data Source tab, 先把BBY2014, BBY2015 and BBY2016 union在一起,把"Date"域Merge在一起並修改回Date.

blank
添加計算域,通過Lookup()找到去年同一月
blank
添加計算域,計算本月比上年同一月增加的絕對值
blank
將Date和兩個新增計算域拖入sheet中,sort后找到增量最為在2015 Mar.

方法2:熟練運用不同行和列的組合,可以更快達到效果。

blank
將Date分別放入Columns和Rows中,顯示Year和Month.
blank

Answer: D. March 2015

13.When using a _____ join the result is a table that contains all values from the left table and corresponding matches from the right table.

A. INNER

B. BLEND

C. RIGHT

D. FULL OUTER

E. LEFT

Answer: E

14.If you see duplicate data after doing a join you may be able to eliminate the duplication by which of the following?

A. Combine the tables using a cross database join rather than a standard join

B. Add a duplicate filter to your data

C. Change the join condition

D. Change to a full outer join

Answer: C. Change the join condition

15.Answer this question with the Games worksheet from the

Create a line graph showing away team runs for the Lions by month. Add a linear trendline. What is the R-squared value?

A. -0.1346

B. . 6846

C. .7503

D. .0573

blank
按Month為X軸畫line chart
blank
左上角Analytics tab中選擇 Trend Line, 可以獲得R-Squared

Answer: B. . 6846

16.Answer this question with the Players worksheet from the

Create a bar chart showing runs by player name. Add a reference distribution showing sample standard deviations. What is one standard deviation below the mean?

A. 1.94

B. 27.07

C. 172.58

D. 8.70

blank
Analytics -& amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; gt; Distribution Band 設置Computation為Standard Deviation
blank
在生成的distribution band中找到below average的Standard Deviation, 為1.94

Answer: A

17._______ is a tendency to increase or decrease over time

A. Seasonality

B. Slope

C. Trend

D. Gradient

Answer: C

18.Which of the following graph types provide information on the distribution of a continuous measure?

A. Pie Chart

B. Heat Map

C. Box Plot

D. Packed Bubbles

Answer: C

篇幅關係,本貼記錄18道題,Tableau DQA考試為36題,剩餘一半會在下篇呈現。 如對你有幫助,歡迎點讚評論和轉發,以鼓勵筆者寫下去。 祝大家考試順利。

下篇:

What do you think?

Written by marketer

blank

Tableau! 為你轉身為你爆燈! 為你打call日夜不分!

blank

深度測評:BI分析工具FineBI vs Tableau