1.
Answer the questions using the Hollywood data
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%
image
把 [Lead Studio]拖入Filter, 并反选“Disney”
image
双击 [Year] 和 [Profitability]并选择 Bar Chart 生成柱状图
image
点击 SUM(Profitability) 的下拉箭头，选择 Quick Table Calculation --Percent Difference
image
在2011的Bar上找到Percentage Difference的答案
Answer: B. 7.2%
2.
Answer the questions using the TopBaby data
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
image
添加Filters: Gender: M, Year: 2000-2012; 添加Calculation Field, 计算Top Name的First Letter
image
将 State, Occurences 和计算域 First_Letter_of_Top_Name 拖入sheet形成 text table. 排序Grand Total后，找到最多出现的首字母是 J.
Answer: C. J
3.
Answer this using theSuperStore data
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()的情况。
image
添加Calculation Field如上
image
将新添加的计算域拖到Dimension中，再拖到sheet中，再拖入Sales到sheet. 汇总到‘1’的结果即为答案
Answer: A. 3,864,069
4.
Answer this question with theLittle League data
How many players have the first name “Anna”
A. 1
B. 2
C. 3
D. 4
image
Split [Name], 并重命名分裂成的两列分别为 First_Name和Last_Name
image
添加计算域，用于判断First_Name是否为Anna, 是的话返回1
image
添加计算域，用于计算不重复的player数量
image
将新添加的 “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 Little League data
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%
image
添加计算域，判断是否满足题目条件。如是，返回1.
image
将计算域“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 Congress data
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以及必要的计算域。
image
判断是否是2013年
image
计算Bills的数量。注意这里用了COUNT而非COUNTD，因为不同votes可能共用bill number.
image
添加如图所示Filters, 并拖入新增的计算域 “#ofBills”, 即得结果36.
Answer: B. 36
9.
Answer this question with this Corp data
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
image
在Dimension [F1]中找到New England的6个国家，右键组成Group, 在生成的group上右键选择“Keep Only”.
image
将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
Little League
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
image
将Data Source中将Games和Team 2014联接(Inner Join)在一起，联接方式如图。
image
增加两个 Calculation Fields 分别计算2015年获胜数量，以及2014至2015年每个队胜率增加百分比。
image
以text table方式分别显示每个队2014年获胜次数，2015年获胜次数以及增加比例。最大为Ninjas.
Answer: D. Ninjas
11.
Answer this question with the Teams 2013 and Teams 2014 worksheets on the Little League
Which team had the biggest decrease in games won from 2013 to 2014?
A. Lions
B. Bears
C. Tigers
D. Lightning
image
增加计算域，计算2013至2014的decrease百分比
image
将Team和计算域“% decrease”拖到sheet中，得了decrease最多的队为Lions.
Answer: A. Lions
12.
Using the Best Buy data
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.
image
添加计算域，通过Lookup()找到去年同一月
image
添加计算域，计算本月比上年同一月增加的绝对值
image
将Date和两个新增计算域拖入sheet中，sort后找到增量最为在2015 Mar.
方法2：熟练运用不同行和列的组合，可以更快达到效果。
image
将Date分别放入Columns和Rows中，显示Year和Month.
image
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
Little League
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
image
按Month为X轴画line chart
image
左上角Analytics tab中选择 Trend Line, 可以获得R-Squared
Answer: B. .6846
16.
Answer this question with the Players worksheet from the
Little League
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
image
Analytics - Distribution Band 设置Computation为Standard Deviation
image
在生成的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
19.
Positive skewness means the extreme values are to the right, while negative skewness means the extreme values are to the left.
A. True
B. False
Answer: A
20.
Answer this question with the Players worksheet on the
Little League
Create a hierarchy Baseball Team – Position. For the Ninjas, how many runs were scored by the position with the lowest average batting average?
A. 150
B. 70
C. 54
D. 24
image
添加Filter选择Baseball Team为Ninjas, 将题目要求的Hierarchy拖入sheet中，再拖入Runs和Batting Average, 并对Batting Average排序，可以得到对应的runs为54.
Answer: C. 54
21.
Answer this question with the Players worksheet on the data
Little League
Create a set for the top three teams with the highest average batting average. What percent of the total runs were scored by these three teams?
A. 7.73%
B. 8.97%
C. 34.55%
D. 92.27%
注意题目里是用Average batting average最高的三队组成set, 不要搞错了。Set create好以后，再拖入Runs, 修改为百分比显示。
image
image
按要求组成set的三个队如图，满足条件的 percent of total runs为34.55%
Answer: C. 34.55%
22.
When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted field.
A. True
B. False
Answer: B
23.
Context Filters are executed after data source filters.
A. True
B. False
Answer: A
参见
Tableau's Order of Operations
image
24.Answer this using the data of
SuperStore
What is the maximum number of months between the ship date and the order date? How many orders took this many months to ship?
A. 5 months, 1 order
B. 5 months, 2 order
C. 3 months, 2 order
E. 3 months, 1 order
F. None of the above
此题难点在于有的order id 会ship不止一次，有多于一条Order date和Ship date. 增加计算域，在同一order id下面分别计算。
image
计算同一order下面从发货到送达最大的月份数
image
把Order ID和新增的计算域分别拖入sheet中。最大的月份数为3个月，一共有2条order记录有3个月的送货周期
Answer: C. 3 months, 2 order
25.
Answer this question with the Games worksheet on the data of
Little League
Find the moving average for the total number of runs in three months prior to May 2015.
A. 749.3
B. 753.8
C. 796.0
D. 763.8
此题要了解如何计算Moving average.
image
添加计算域，计算Total Runs为 [Runs for Away Team]+[Runs for Home Team]。将此计算域拖到sheet中，修改default SUM为Moving Average.
image
在May-2015之前，为796.0
Answer: C. 796.0
26.
Tableau displays an axis when you drop this onto the Rows or Column shelf.
A. Continuous field
B. Discrete field
C. Measure names
D. Measure values
Answers: A, D
27.
Answer this question with the Players worksheet on the
Little League
Create a histogram showing batting averages using a bin size of .05. Find the average number of runs scored for players with a batting average between .55 and .6.
A. 13.53
B. 15.64
C. 18.92
D. 13.38
解题思路为先按Batting Average设置bin, 再把Avg(Runs)和Batting Average(bin)分别拖到Rows和Columns里。
image
画出Histogram后，把Size fo bins修改为0.05.
image
拖入[Runs]到Rows里，注意修改为AVG(default为SUM)，找到题目要求的0.55的bin对应的Avg. Runs为13.53
Answer: A. 13.53
28.
Gantt charts are useful for:
A. Showing changes to a continue variable over time
B. Displaying duration of events or activities over time
C. Showing how a measure varies with respect to one or more dimensions
D. Display the distribution of a continuous variable
Answer: B
29.
Bins acts as containers that summarize data for a specific range of values. Without using a calculated field, Tableau's bin feature allows you to create variable sized bins.
A. True
B. False
Answer: B
创建Variable sized bin，需要使用计算域。
30.
Answer this question using the
Tableau Jobs dashboard
What percent of job postings for Developers mention Python skills?
A. 13%
B. 15%
C. 17%
D. 19%
此题提供了一个已经做好的workbook, 但在做题时要注意已有Filters的值是否满足题目条件。此题中需要修改已有的两个Filters, 其中Job Type需要修改为 Developer, Position Level可改可不改，不影响最终结果。
image
修改Job Type的Filter
image
在Python所对应bar的找到百分比为15%
Answer: B. 15%
31.
Answer this question using the
Tableau Jobs dashboard
For the Business Intelligence position, what is the Title with the most job postings?
A. BI Developer
B. Business Intelligence Analyst
C. Data Analyst
D. Business Analyst
image
在“Position Titles”的Sheet里，在Rows里点击Position前面的加号，展开为Position和Titles. 可以增加Filter, 选择Position为Business Intelligence. 可以找到Job Posting num最多的为BI Developer
Answer: A. BI Developer
32.
If a dashboard is difficult to view on a smartphone, you can use the _____ designer to create a phone-specific view of your dashboard:
A. Device Designer
B. Custom layout
C. Floating layout
D. Narrower width
Answer: A
33.
A ___ action allows Tableau to open a page on an external website.
A. URL
B. Filter
C. Highlight
D. Web
Answer: A
34.
You can combine multiple worksheets in a single dashboard.
A. True
B. Fase
Answer: A
35.
Answer this question using the
Tableau Jobs dashboard
Create a map view and zoom in to southern California. How many jobs are either in Costa Mesa or within 4 miles of Costa Mesa.
A. 2
B. 5
C. 8
D. 10
E. None of the above
image
在Jobs by City的worksheet中操作。找到城市，并选择右三角中圆形虚线。
image
以城市为中心画圆，在4 miles之内找到SUM of Jobs.
注意：如果计量单位不是mile，可以在Map -> Map Options中修改。
Answer: C. 8
36.
Answer this question using the
Tableau Jobs dashboard
Using the Tableau Job Market dashboard, determine which group of three states have the most job posts.
A. Minnesota, Wisconsin, and Michigan
B. Texas, New Mexico, Oklahoma
C. Florida, Georgia, Alabama
D. Arizona, Utah, Colorado
此题最快的做法为在地图在搜索每个选项的第一个State, 每个选项3个state是邻接在一起的，所以快速找到一个，看下大概三个State的颜色和Sum of job posts.
Answer: C. Florida, Georgia, Alabama
网友评论