For the mock tests A and B, you will require the following data:

• Sample Superstore dataset: http://www.tableau.com/sites/default/files/training/global_Superstore.zip
• FIFA match results: https://public.tableau.com/s/sites/default/files/media/world_cup_results.xlsx
• 2018 FIFA rosters: https://public.tableau.com/s/sites/default/files/media/world_cup_2018_squads.xlsx
• Titanic passenger list: https://public.tableau.com/s/sites/default/files/media/titanic%20passenger%20list.csv
• Star Wars character details: https://public.tableau.com/s/sites/default/files/media/starwarscharacterdata.json
• Apples data: https://www.ers.usda.gov/webdocs/DataFiles/51035/apples.xlsx?v=0
• NFL stats: https://public.tableau.com/s/sites/default/files/media/Resources/NFL%20Offensive%20Player%20stats%2C%201999-2013.xlsx
• Brewing production size: https://docs.google.com/spreadsheets/d/1fjA0jSVPecI7rCeSx5MUzIw3Z0pOJeYbT1q80bW1SsM/edit?usp=sharing
• Tableau job market dashboard: https://public.tableau.com/workbooks/Practiceworkbook-TableauJobMarket.twb

The exam comprises the following sections:

Calculations 1-7

Test A

Question 1: Answer the following question using the Superstore dataset. What was the percentage change in the profitability between 2013 and 2014 for segments other than the consumer segment?

1. 23.89%
2. 40.17%
3. 24.17%
4. 32.74%

Question 2:  Answer the following question using the Star Wars dataset. What is the most common first letter for male characters with orange eyes? 

1. S
2. A
3. T
4. C

Question 3: Answer the following question using the Superstore dataset. What is the total sales value for all products in 2014 by customers who also ordered in 2012?

1. 2,677,439
2. 4,139,150
3. 587,457
4. 4,299,866

Question 4: Answer the following question using the Titanic passenger list data. How many people with the last name Davies were on the passenger list?

1. 1
2. 7
3. 18
4. 2

Question 5: The COUNTD function returns the number of distinct items in the group. Is it true or false that null items are counted as a separate item? 

1. True
2. False

Question 6: Answer the following question using the FIFA 2018 rosters. What is the percentage of players born before 1990 that scored more than 10 goals. 

1. 19.29%
2. 80.71%
3. 11.96%
4. 88.04%

Question 7: For any aggregate calculation, is it true or false that you cannot combine an aggregated value and a disaggregated value?

1. True
2. False

Question 8: Using the Superstore dataset, answer the following question: What was the total sales value for Southeast Asia in 2014 for items that were never returned? 

1. 23,161
2. 212,726
3. 306,769
4. 323,068

Question 9: Using the Apples dataset, answer the following question: What is the average price for fresh and frozen apples? 

1. 2.126
2. 0.51
3. 1.616
4. 1.063

Question 10: Answer the following question using the FIFA match results and 2018 FIFA rosters data. How many players who were born before 1990 played on the team in 2018 that ranked number 1 winner by the number of times they won in all previous years?

1. 12
2. 4
3. 0
4. 23

Question 11: Answer the following question using the brewing production size dataset. What is the difference in percentage of exported products between 2017 and 2018 for breweries that have a production size of less than one barrel?

1. -45.51%
2. -16.35%
3. 45.5%
4. 7.24%

Question 12: Answer the following question using the Superstore dataset. What was the name of the manager that gave the fewest discounts in the consumer segment?

1. Anna Andreadi
2. Alejandro Ballentine
3. Shirley Daniels
4. Nicole Hansen

Question 13: When would be the best time to use data blending rather than join?

1. When you are unable to combine data sources through JOIN
2. When data blending is the only option available
3. When JOIN doesn't give the flexibility required
4. When you need to avoid data duplication without losing unrelated data

Question 14: Answer the following question using the FIFA match results dataset. Create a bar graph for the year and goals scored. Add a distribution band for 65 to 80 percent. What is the value of the 65% average?

1. 77.3175
2. 65
3. 95.16
4. 73.65

Question 15: Answer the following question using the NFL stats dataset. Create a scatter plot using College Wins and Age detailed by Player. What is the standard error for the linear trend line?

1. <0.001
2. 0.800443
3. 86.3054
4. 148.27

Question 16: Answer the following question using the NFL stats dataset. Using a box plot, find out what is the value for the lower quartile for players' height?

1. 66
2. 71
3. 73
4. 76

Question 17: When can the linear trend lines be considered significant? 

1. When t-value >= 0.5
2. When the standard error <= 5.0
3. When R-squared >= 0.05
4. When p-value <= 0.05

Question 18: What are the two methods Tableau uses to determine seasonality in forecasting?

1. Temporal and non-temporal
2. Granular and non-granular
3. Linear and non-linear
4. Seasonal and non-seasonal

Question 19: Which Tableau option would you use to distinguish marks (single data point) and call out their position on the X/Y axis in the view?

1. Tool tip
2. Axis Lines
3. Drop Lines
4. Reference Lines

Question 20: Answer the following question using the 2018 FIFA roster dataset. Create a hierarchy Group - Position. How many goals were scored by Position whose players appeared the most on the National Team (Cap count) in Group B?

1. 268
2. 340
3. 414
4. 0

Question 21: Answer the following question using the 2018 FIFA roster dataset. Looking at the FW position, what percentage of goals were scored by the top three players?

1. 88.86%
2. 6.03%
3. 48.14%
4. 11.14%

Question 22: Is it true or false that you can manually sort data using a legend?

1. True
2. False

Question 23: Is it true or false that fixed Level Of Detail (LOD) filters are executed before context filters?

1. True
2. False

Question 24: Answer the following question using the NFL stats dataset. What is the moving average of the age of the players by draft year in the five years prior to 2013?

1. 24.50
2. 23.89
3. 24.15
4. 24.32

Question 25: Answer the following question using the NFL Stats dataset. Using a histogram, create a visualization for the players' weight using a bin size of 10. What is an average broad jump for players that weigh 230-240 lb?

1. 88.27
2. 91.94

3. 73.89
4. 109.46

Question 26: Knowledge Based. Is it true or false that, in Tableau, bins can be used for continuous measure?

1. True
2. False

Question 27: Answer the following question using the Tableau Job Market workbook. What title holds the largest average salary for Architect position?

1. Business intelligence architect
2. Data warehouse architect
3. Tableau server administrator
4. Security administrator

Question 28: Knowledge Based. Is it true or false that, while building dashboards, strings and dates slow the performance down more than numbers and Booleans?

1. True
2. False

Question 29: Answer the following question using the sample Superstore dataset. What is the sum of profits of the cities that fall within a 30 km range of Seattle?

1. 29,156
2. 27,391
3. 56,024
4. 31,887

Question 30: Answer the following question using the sample Superstore dataset. Using Maps answer the following: which groups of states raised the most profit? 

1. Idaho, Montana, North Dakota
2. Wyoming, South Dakota, Nebraska
3. Minnesota, Wisconsin, Iowa
4. Utah, Colorado, New Mexico

Answer Key Test A

Answer 1: 3. 24,17%

Add both Order Date and Profit to the view:

Create a Quick Table Calculation to see the percentage difference:

Create a filter to exclude Consumer:

Select text tables to view the data:

Your answer should look similar to this. The correct answer is 4.01%:

Answer 2: 1. S

First create a calculated field:

Then, create the following calculation:

Add it to the view:

Create filters for the gender:

Create filters for the eye color:

Now double-click on the Number of Records:

Your answer should look like this. There are two records for R and S. S is the only option available for the correct answer:

Answer 3: 2. 4,139,150

First create the LOD calculated field on [customer name]:

Then, add the year, category, and sales to the view:

Create a filter with the Customers from 2012 calculated field we created, and filter out the results that match the criteria. Note that the filter had no effect on the column for 2012, but did adjust the rest to match the customers that also ordered in 2012:

Your answer should look like this:

Answer 4: 2. 7

While adding the data source, split the name field in order to divide the column:

Rename the split 1 column to Last name:

Add Last name and number of records to the view:

Scroll down to the last name Davies. The correct answer is 7:

Answer 5: 2. False

NULL values are not counted:

Answer 6: 1. 19.29%

Add the data source, making sure all the fields, especially DOB, are identified as such:

Create the calculated field in order to separate players into two groups: more than 10 and less than 10:

Create a filter for players who were born before 1990:

Now, add the Goals Scored and Number of records fields to the view:

Now, create a quick table calculation to find out the percentage of the total for the number of records:

Your answer should look like this, with the answer showing the percentage of players scoring more than 10 goals being 19.29%: 

Answer 7: 1. True

For any aggregate calculation, you cannot combine an aggregated value and a disaggregated value. For example, SUM(Price)*[Items] is not a valid expression because SUM(Price) is aggregated and Items is not. However, SUM(Price*Items) and SUM(Price)*SUM(Items) are both valid. For further information, refer to https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_aggregate_create.htm.

Answer 8: 3. 306,769

First we need to join the Orders and Returns tables using Left JOIN on Order ID:

Then, add Order Date, Region, and Sale to the view:

Exclude Returned Items via a filter:

Your answer should look like this:

Answer 9: 4. 1.063

First use the data interpreter while adding the data source to clean the data:

As a result, you should see the following columns: 

Filter out the form of apple we are looking for:

Add the average retail price measure to the view:

Note that measures are added as a SUM by default. We need an average, so switch it to AVG:

Your answer should look like this:

Answer 10: 1. 12

For this question we would have to use data blending. This will allow us to use two data sources without JOIN, thus eliminating any possibility of extra rows added to the dataset. 

First add the relationship between the data sources:

Select the WorldCups in the list

Next, using the WC squads data, filter players by their DOB:

In the WorldCups datasource, create a calculation field that ranks the winners by the number of wins they have:

Add the Rank Winners and Winners  fields to the view:

Keep only Brazil:

Add the Name field to the view:

Look at the bottom left of the screen. You have 12 rows of data. This is the answer:

Answer 11: 1. -45.51%

First, we need to UNION all three tables:

Next, use Data Interpreter to clean up the table:

Rename the table column to Year and change the data format to date:

Bring Year, Barrels, and Total Shipped into the view:

Keep only the breweries with production under 1 Barrel:

Using Quick Table Calculation, calculate the percentage difference between the years:

Your answer should look like this:

Answer 12: 4. Nicole Hansen

First LEFT JOIN two tables, People and Orders using Region as key:

Then bring the Segment, People, and Discount fields into the view:

Keep only Consumer:

Sort the data in descending order:

Your answer should look like this:

Answer 13: 4. When you need to avoid data duplication.

In some instances, changing JOIN conditions is not enough to avoid data duplication, as well as certain unlinked data may not be included in the JOIN. Data blending would then be the best option, creating the combined data source with combined data from all sources, without duplication. 

Answer 14: 1. 77.3175

First add Year and Goals Scored to the view:

Change Year from Continuous to Discrete:

Add Table Distribution Band using the Analytics tab on the left. Change the lower percent brakes in the distribution to reflect the range 65 to 80 percent:

Hover over 65% of Average . Your answer should look like this:

Answer 15: 4. 148.27

Add College Wins and Age to the view:

Drop Player on detail in Marks:

Add Linear Trend Line:

Right click on the trend line and select Describe Trend Model:

Your answer should look like this:

Answer 16: 2. 71

First let's add Height and Player to the view. You will right away see that for some players such as Alex Smith the height is 1,300 inches. Clearly, we have some data duplication. So let's create a simple LOD calculation that would give us only one value per player. Create a calculated field with the following formula: 

Add this new measure along with Player into the view:

Select Whisker Plot in in Show Me:

Hover over the visualization. The lower quartile is another name for Lower Hinge. Your answer should look like this:

Answer 17: 4. When p-value <= 0.05

https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm.

Answer 18: 1. Temporal and non-temporal

https://help.tableau.com/current/pro/desktop/en-us/forecast_how_it_works.htm.

Answer 19: 3. Drop Lines

https://help.tableau.com/current/pro/desktop/en-us/inspectdata_droplines.htm.

Answer 20: 1. 268

First make the hierarchy, dragging dimension Position onto dimension Group:

Then, add the newly created position to the view, as well as Caps and Goals by double-clicking them:

Expand the hierarchy, and sort the data in the descending order:

Your answer should look like this:

Answer 21: 4. 11.14%

First let's create a set for the top three players:

You want to create a set using the Goals field:

Next add the new set along with Position and Goals to the view:

Now we need to create a table calculation using Percent of Total calculated through Table down:

Your answer should look like this:

Answer 22: 1. True

https://help.tableau.com/current/reader/desktop/en-us/reader_sort.htm.

Answer 23: 2. False

https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm.

Answer 24: 3. 24.15 Years

Fist change the data type for Draft Year to Date:

Convert it to Discrete:

Add Draft Year and Age to the view:

Change Age SUM to AVG:

Add the Moving Average table calculation:

Edit Table Calculation. Select the average for five last data points, and deselect the current value, as we don't want data for 2013 to be included in the calculation:

Your answer should look like this:

Answer 25: 1. 88.27

Add Weight to the view:

Select Histogram from Show Me:

You will notice that Weight (bin) appeared in Dimensions. Click Edit and select bin size 10:

Drag Broad Jump to the Tooltip card in Marks, and switch from SUM to AVG:

Hover over the bin "230-240". Your answer should look like this:

Answer 26: 1. True.

https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm.

Answer 27: 1. Business intelligence architect

First expand the Position hierarchy:

Now sort the Average Estimated Salary in the descending order:

Your answer should look like this:

Answer 28: 1. True

https://help.tableau.com/current/pro/desktop/en-us/performance_tips.htm.

Answer 29: 4. 31,887

First, add City and Profit to the view:

Select the map symbol from the Show Me menu.

Find Seattle:

Go to the map, then Map Options, and select units to be Metric:

Use the Radial Selection tool to measure the distance:

Stretch the measuring tool to reflect 30 km:

Look at the bottom left. Your answer should look like this:

Answer 30: 1. Idaho, Montana, North Dakota

Add State and Profit to the view:

Select the map symbol from the Show Me menu:

Group the states together:

Collapse the state pill to only show the country:

Mouse over the states to see which one is the most profitable. Your answer should look like this:

Test B

Question 1: Answer the following question using the Superstore dataset. What was the percentage change in the sales between 2012 and 2013 for all segments?

1. 23.48%
2. 32.37%
3. 25.16%
4. 23.92%

Question 2: Answer the following question using the Star Wars dataset. What is the most common first letter for female characters with blue eyes? 

1. A
2. J
3. B
4. N

Question 3: Answer the following question using the Superstore dataset. What is the total sales value for all segments in 2014 by customers who ordered items from the consumer segment?

1. 1,194,052
2. 1,503,262
3. 1,463,760
4. 1,766,155

Question 4: Answer the following question using the Titanic passenger list data. What was the most common last name on the passenger list? 

1. Sage
2. Johnston
3. West
4. Smith

Question 5: Is it true or false that the median function returns a value in an ordered set of values, below and above which there is an equal number of values?

1. True
2. False

Question 6: Answer the following question using FIFA 2018 Rosters. What is the percentage of players that were born after January 01, 1992 who scored more than 15 goals?

1. 97.29%
2. 17.24%
3. 9.92%
4. 2.03%

Question 7: Is it true or false that, if you don't have all the data values you need on the visualization, it is a perfect time to use quick table calculation?

1. True
2. False

Question 8: Using the Superstore dataset answer the following question: What was the total sales value for Central Asia in 2013 for items that were returned? 

1. 14,094
2. 44,658
3. 4,833
4. 1,453

Question 9: Using the Apples dataset, answer the following question: What is the average price per cup equivalent for fresh and ready to drink apples? 

1. 0.4353
2. 0.3754
3. 0.3156
4. 0.2973

Question 10: Answer the following question using the FIFA Match results and 2018 FIFA rosters data. How many players who were born before 1988 play on the teams in 2018 that ranked number 4  by the number of times they won in all previous years?

1. 3
2. 5
3. 7
4. 18

Question 11: Answer the following question using the brewing production size dataset. Which production size (by barrel) saw the biggest increase in the number of breweries in 2018? 

1. Under 1 barrel
2. 1 to 1k barrels
3. 1k to 7,5k barrels
4. 7,5k to 15k barrels

Question 12: Answer the following question using the Superstore dataset. What was the name of the manager who is in charge of the least profitable region in the corporate segment?

1. Anthony Jacobs
2. Shirley Daniels
3. Kelly Williams 
4. Alejandro Ballentine Corporate

Question 13: Is it true or false that, if your file type is not listed under Connect, the only option is to cover the file to supported format?

1. True
2. False

Question 14: Answer the following question using the FIFA match results dataset. Create a bar graph using year and matches played. Add the distribution band for the standard deviation -0.5,0.5. What is the value of the standard deviation above the mean?

1. 50.409
2. 33.190
3. 47.753
4. 12.874

Question 15: Answer the following question using the NFL Stats dataset. Create a scatter plot using College Wins and College Losses detailed by Player. May a linear trend line for this data be considered significant?

1. Yes
2. No

Question 16: Answer the following question using the NFL Stats dataset. Using a box plot, find out what is the value for upper whisker for players wins?

1. 546
2. 349
3. 721
4. 1168

Question 17: Is it true or false that, with Tableau, you can create forecasts and that all you need is a dimension and a measure?

1. True
2. False

Question 18:  What is the number of parameters needed to completely specify the model called?

1. Model observations
2. Model data point
3. Model degrees of freedom
4. Model Parameters

Question 19: Is it true or false that you can use clustering for any dimension in the view?

1. True
2. False

Question 20: Answer the following question using the 2018 FIFA Roster dataset. Create a hierarchy Group - Position. Which group had the most goals scored by the FW position?

1. F
2. H
3. A
4. D

Question 21: Answer the following question using the 2018 FIFA Roster dataset. Looking at the FW position, out of all the players what, percentage of appearances on national teams (Caps) were done by top ten players based on their goals?

1. 7.86%
2. 6.03%
3. 20%
4. 12.59%

Question 22: Is it true or false that you cannot manually sort data in the view within a hierarchy?

1. True
2. False

Question 23:  Is it true or false that measure filters are always executed before dimension filters?

1. True
2. False

Question 24: Answer the following question using the NFL Stats dataset. What is the moving average of the wins of the youngest players (last three years) based on their date of birth? 

1. 50,998
2. 28,476
3. 72,427
4. 63,596

Question 25: Answer the following question using the NFL Stats dataset. Using a histogram, create a visualization for a broad jump by the players using the bin size of two inches. What is an average height of the players that conducted the longest jumps?

1. 73.21
2. 71.45
3. 73.89
4. 72.57

Question 26: Knowledge Based. What are custom fields that define a subset of data based on some conditions called?

1. Groups
2. Parameters
3. Sets
4. Fields

Question 27: Answer the following question using the Tableau Job Market workbook. How many job postings are there for a Tableau developer?

1. 52
2. 109
3. 33
4. 2

Question 28: Knowledge Based. Can web pages be included in the Tableau dashboard? 

1. True
2. False

Question 29: Answer the following question using the sample Superstore dataset. What is the sum of the sales of the cities that fall within 10 mile range of Lehi?

1. 1,517
2. 4,511
3. 17,366
4. 9,821

Question 30: Answer the following question using the sample Superstore dataset. Using Maps answer the following: which state around Indiana sold the largest quantity of items?

1. Illinois
2. Michigan
3. Kentucky
4. Ohio

Answer Key Test B

For the procedures on how to answer each question, refer to Answer Key for Test A, as they follow the same structure. 

Answer  1: 2. 32.37%

Answer 2: 3. B

Answer 3: 2. 1,503,262  

The formula for the LOD calculation you are looking for is: { FIXED [Order ID]: MIN(IF [Segment] = "Consumer" then "in" else "out" END)}

Answer 4: 1. Sage

Answer 5: 1. True

Question 6: 4. 2.03%

Answer 7: 2. False ( https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_understand.htm)

Answer 8: 4. 1,453

Answer 9: 2. 0.3754

Answer 10: 4. 18

Answer 11: 1. Under 1 barrel

Answer 12: 4. Alejandro Ballentine Corporate

Answer 13: 2. False (https://help.tableau.com/current/pro/desktop/en-us/basicconnectoverview.htm)

Answer 14: 1. 50.409

Answer 15: 1. Yes, based on the p-value <= 0.05

Answer 16: 4. 1168

Answer 17: 2. False (https://help.tableau.com/current/pro/desktop/en-us/forecasting.htm)

Answer 18: 3. Model degrees of freedom

Answer 19: 2. False (https://help.tableau.com/current/pro/desktop/en-us/clustering.htm)

Answer 20: 1. F

Answer 21: 3. 20

Answer 22: False

Answer 23: False (https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm)

Answer 24: 2. 28,476

Answer 25: 1. 73.21

Answer 26: 3. Sets (https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sets_create.htm)

Answer 27: 3. 33

Answer 28: 1. True (https://help.tableau.com/current/pro/desktop/en-us/dashboards_best_practices.htm)

Answer 29: 2. 4511

Answer 30: 1. Illinois

This is it. Well done!