________________ is hosted by Tableau to share our visualisations publically with the world.
- A . Tableau Reader
- B . Tableau Desktop
- C . Tableau Server
- D . Tableau Public
D
Explanation:
Tableau Public is a free service that lets anyone publish interactive data visualizations to the web. Visualizations that have been published to Tableau Public (“vizzes”) can be embedded into web pages and blogs, they can be shared via social media or email, and they can be made available for download to other users. Check it out: https://public.tableau.com/en-us/s/
When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?
- A . Monitor, Default, Phone, Tablet
- B . Phone, Tablet, Laptop, Desktop
- C . Default, Phone, Tablet, Desktop
- D . Phone, Monitor, Laptop, Default
C
Explanation:
The following options are available in the Device preview section when creating a Dashboard:
Graphical user interface
Description automatically generated
Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_dsd_create.htm
Which of the following lets you group related dashboard items together so you can quickly position them?
- A . Layout Extensions
- B . Layout Blanks
- C . Layout Containers
- D . Layout positioners
C
Explanation:
Layout containers let you group related dashboard items together so you can quickly position them. As you change the size and placement of items inside a container, other container items automatically adjust
Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_organize_floatingandtiled.htm
True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.
- A . True
- B . False
A
Explanation:
Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.
Inner join
Left Join
Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.
Reference: https://help.tableau.com/current/pro/desktop/en-us/multiple_connections.htm
Is SUM a table calculation?
- A . Yes
- B . No
B
Explanation:
SUM is an aggregate function, not a table calculation!
A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.
The most common Table calculations are:
Running Total
Percent Difference
Difference
Percent of Total
Rank
Percentile
These can be calculated using: Table(across), Cell, or Specific dimensions!
Reference: https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_definebasic_runningtotal.htm
Which of the following URL prefixes are permitted when creating a URL Action in Tableau?
- A . SMTP
- B . FTP
- C . HTTPS
- D . HTTP
B,C,D
Explanation:
A URL action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau. You can use URL actions to create an email or link to additional information about your data. To customize links based on your data, you can automatically enter field values as parameters in URLs.
Graphical user interface, text, application
Description automatically generated
Graphical user interface, application, Word
Description automatically generated
Graphical user interface, text, application
Description automatically generated
Graphical user interface, text, application
Description automatically generated
Reference: https://help.tableau.com/current/pro/desktop/en-us/actions_url.htm
Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf.
Which of the following would create a stacked bar chart?
- A . By dragging another dimension to the Rows shelf
- B . By dragging another measure to Color on the Marks card
- C . By dragging another dimension to Color on the Marks card
- D . By dragging another measure to the Columns shelf
C
Explanation:
Very important question for the exam and appears quite a lot too.
The correct answer is – By dragging another dimension to Color on the Marks card.
Chart, bar chart
Description automatically generated
This is what the question says we have already created. Now to convert this into a Stacked bar chart, we will drop another dimension on Color in the Marks card.
Chart, bar chart
Description automatically generated
The rest won’t create stacked bar charts, and hence are incorrect choices. The best way to answer such questions on the real exam is to quickly do what the options say and see if they satisfy the requirements in the question.
Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.
How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?
- A . 1
- B . 2
- C . 3
- D . 4
C
Explanation:
If you chose 2, then you were very close but probably didn’t plot the actual Percent Difference on your view. (One of the marks is just over the line).
✑ Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both Year and Quarter as mentioned in the question.
✑ 2) Next, Drop assortment to filters shelf so that we can focus on Electronics!
3) This should be your view now. Click on the Show Mark Labels icon as shown: The final view is as follows, with 3 points below 0 (i.e negative)
Which of the following are interactive elements that can be added to a dashboard for users?
- A . URL Action
- B . Filter Action
- C . Highlight Action
- D . Edit Tooltip Action
A,B,C
Explanation:
We can perform filter, URL and highlight actions out of the above given choices on a dashboard.
Please refer to the image below:
Graphical user interface
Description automatically generated
Reference: https://help.tableau.com/current/pro/desktop/en-us/actions_dashboards.htm
Which of the following are the options to export the data used to build the view / visualisations?
- A . CSV file
- B . PDF File
- C . JSON format
- D . MS Access Database
A,D
Explanation:
You can export the data in a Tableau data source, including all or part of the records from your original data. Alternatively, you can export only the portion of data used to generate the view.
Since the question mentions the data used to build the view, we’ll focus on that:
*Export data in the view to Microsoft Access or .csv*
Export the data that is used to generate the view as an Access database (Windows only) or.csv file (Mac only).
1) In Tableau Desktop, select Worksheet > Export > Data.
2) Select a location and type a name for your Access database or .csv file.
3) Click Save.
4) If you’re on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.
Graphical user interface, text, application, email
Description automatically generated
Reference: https://help.tableau.com/current/pro/desktop/en-us/save_export_data.htm
Which of the following 2 fields CANNOT be deleted in Tableau?
- A . Number of Records
- B . Measure Names
- C . Measure Values
- D . Calculated Fields
B,C
Explanation:
Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated.
Calculated Fields, and Number of records can both be deleted.
For a relative date filter, the default anchor is _________________
- A . The current time
- B . Today’s date
- C . The target date
- D . The date we specify
B
Explanation:
Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.
Step 1: Drag a date field to the filter shelf
Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.
Step 2: Select a time unit
In the Filter dialog box, click Relative dates, and then select the unit of time for the filter.
For example, to show only the three most recent weeks, select Weeks.
Here, you can clearly see that the default date is TODAY
Reference: https://help.tableau.com/current/pro/desktop/en-us/qs_relative_dates.htm
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A . No
- B . Yes
B
Explanation:
Of course! As an example, see below:
1) Using the Sample Superstore data, let’s plot a bar chart showing the Sales for each Category:
Observe that we have 3 marks – Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark, and so on for all charts.
1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark – a single continous axis, but 3 different marks (Technology, Furniture and Office supplies) on the x-axis.
2) Now let’s add subcategory to the view as well (another dimension):
Observe that the number of marks has increased – i.e the number of Bars.
Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)
What is the following icon in the Data pane used to do?
Larger image
- A . View Data
- B . Clean Data
- C . Extract Data
- D . Sort Data
A
Explanation:
View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.
The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.
From the official website:
Reference: https://help.tableau.com/current/pro/desktop/en-us/inspectdata_viewdata.htm
By definition, Tableau displays measures over time as a ____________
- A . Packed Bubble
- B . Bar
- C . Stacked Bar
- D . Line
D
Explanation:
Line charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.
Please refer to the images below:
Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_line.htm
Which of the following returns the Absolute Value of a given number?
- A . ABS(Number)
- B . CEILING(Number)
- C . FLOOR(Number)
- D . ZN(Number)
A
Explanation:
From the official Tableau website:
Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_number.htm
True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.
- A . True
- B . False
B
Explanation:
In fact, the opposite of this is true.
Trick: Whenever you think of joins -> Think that after the join is created, we get 1 single flat combined (joined) table. This flat combined table is created prior to us creating our visualizations. This happens at the physical layer.
If you ever think about relationships, know that all tables will remain distinct and separate, and relationships sit at the logical layer. At run time, when you bring in the dimensions and measures to create your viz, Tableau very smartly creates the necessary joins, relates the tables and sends queries to these tables to get the resultant data back in the most meaningful way possible. This allows you to focus on using your data and revealing insights from it and focus less on the data preparation aspect!
Refer to logical layer vs physical layer from the official
documentation: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm
Which of the following is an example of a Date Part?
- A . Q4 2017
- B . March 2019
- C . September 2020
- D . November
D
Explanation:
All answers except November are examples of Date Values (continuous in nature).
See below:
You can see that the option in Green symbolizes our correct answer, i.e only a Month. In our case that month is November (the correct answer).
All other options are combinations of a year with one other value (like a month, quarter, or day). So this is how by looking at an option you can know if its a date part or date value!
Which of the following are required to create a trend line?
- A . 2 measures on opposing axes, or a date and a measure on opposing axes.
- B . 1 measure, or a date and a dimension on opposing axes.
- C . 1 measure only
- D . 2 dimensions, or a date and a dimension on opposing axes.
A
Explanation:
To create a trend line, we need:
Graphical user interface, application
Description automatically generated
Reference: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm
Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1)
ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark. (Sheet 2)
Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1.
What was the average weight for Badminton in Russia? (Ignore any nulls / unknowns)
- A . 76.25
- B . 65.67
- C . 68.77
- D . 4.87
A
Explanation:
Pretty common question on the Tableau Desktop Specialist exam.
1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:
2) Now, for sheet 2 – Drag nationality to the view, and gold to the size mark in the Marks shelf.
NOTE: Depending on your version of Tableau, you may need to assign a Geographical role to the nationality column first as follows:
3) Now, let’s create a dashboard, and use both these sheets in it:
4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:
Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:
Suppose you have a bar chart. When we group by labels in a view, which of the following happens?
- A . Nothing changes in the view, but a group is created in the Dimensions shelf.
- B . The colours of the members selected are now the same, and different for the rest of the members.
- C . Trick question! It is not possible to group by labels.
- D . A new mark (bar) is created, which consolidates all members of the group.
D
Explanation:
*Very important question*
If we select the labels in the view and then group, a new consolidated mark is created – in our case bar since we are talking about a bar chart in the question. See below:
Then on grouping, a new bar is created, and the colour of all bars remain the same.
Had we grouped by choosing the marks instead of the labels, the following would be the result:
Reference: https://help.tableau.com/current/pro/desktop/en-us/sortgroup_groups_creating.htm
Which of the following are true about dimensions?
- A . They contain contain numeric, quantitative values
- B . They contain qualitative values (such as names, dates, or geographical data)
- C . They affect the level of detail in the view
- D . Dates are mostly placed in dimensions by default for relational data sources
B,C,D
Explanation:
Measures contain numeric quantitative values hence that option is incorrect.
Reference 1: https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm
Reference 2: https://help.tableau.com/current/pro/desktop/en-us/dates.htm
__________ is a technique in Tableau which will identify marks with similar characteristics
- A . Clustering
- B . Grouping
- C . Sets
- D . Union
A
Explanation:
Cluster analysis partitions marks in the view into clusters, where the marks within each cluster are more similar to one another than they are to marks in other clusters.
Reference: https://help.tableau.com/current/pro/desktop/en-us/clustering.htm
Which of these is NOT a type of Quick Filter available in Tableau?
- A . Wildcard Match
- B . Multiple Values (dropdown)
- C . Regex Match
- D . Single Value (slider)
C
Explanation:
Upon clicking on a filter, we see the following options:
Clearly, Regex Match is not one of these options!
For which of the following charts, does the Size option on the Marks card not work?
- A . Gantt Chart
- B . Bar Chart
- C . Tree Map
- D . Pie Chart
C
Explanation:
You can adjust the size for all charts except the Tree Map. You use dimensions to define the structure of the treemap, and measures to define the size or color of the individual rectangles. Treemaps are a relatively simple data visualization that can provide insight in a visually attractive format.
In a Tree Map, the measure itself defines the size and colour! The greater the sum of Measure for each category, the darker and larger its box.
Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_treemap.htm
Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?
- A . To support additional functionality such as count distinct
- B . Fast to create
- C . Help improve performance
- D . To have access to the freshest possible data at all times
A,B,C
Explanation:
From the official documentation, the following are the major advantages of using Tableau Data Extracts:
From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde!
Reference: https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm
A ________________ is a single zip file that contains a workbook along with any
supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data.
- A . .twbx file
- B . .tbm file
- C . .twb file
- D . .tde file
A
Explanation:
According to the official Tableau documentation:
Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data. For more information, see Packaged Workbooks.
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm
What does the following icon do in Tableau?
Larger image
- A . Create a Story
- B . Create a Story and Dashboard both
- C . Create a Worksheet
- D . Create a Dashboard
D
Explanation:
The icon shown is used to add a new Dashboard! From the official documentation:
Reference: https://help.tableau.com/current/pro/desktop/en-us/inspectdata_viewdata.htm
_____________ contains the visualisations, info needed to build the visualisations, and a
copy of the data source.
- A . Tableau Data Extract (.tde)
- B . Tableau Packaged Workbook (.twbx)
- C . Tableau Bookmark (.tbm)
- D . Tableau Workbook (.twb)
B
Explanation:
TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn’t contain extracts of the data but can contain both live and data extracts.
Best if want to eliminate the barrier of data access.
Create a .twbx with file-based data sources
1) Select File > Save As.
2) Specify a file name for the packaged workbook in the Save As dialog box.
3)Select Tableau Packaged Workbooks on the Save as type drop-down list.
4) Click Save.
5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose.
The following files are included in packaged workbooks: –> Background images
–> Custom geocoding –> Custom shapes –> Local cube files
–> Microsoft Access files
–> Microsoft Excel files
–> Tableau extract files (.hyper or .tde)
–> Text files (.csv, .txt, etc.)
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm
Which of the following is NOT a valid official data source in Tableau Desktop?
- A . PostgreSQL
- B . SAP HANA
- C . Google Firebase
- D . Amazon Redshift
C
Explanation:
Presently, there is no official way to connect your data in Firebase directly with Tableau Desktop.
A workaround however can be to export your Firebase data into Google BigQuery, and then connect it to Tableau Desktop.
But then again, it is a workaround and not an official out-of-the-box solution.
The following are the available Data sources available as of now:
1) Server
2) File
Which of the following are FALSE about Joins?
- A . Joins can be defined at the time of query dynamically
- B . May drop unmatched measure values
- C . They are displayed with Venn diagram icons between physical tables
- D . Joined tables are never merged into a single table.
- E . They are a more dynamic way than relationships to combine data
A,D,E
Explanation:
According to the official documentation:
Joins are a more static way to combine data. Joins must be defined between physical tables up front, before analysis, and can’t be changed without impacting all sheets using that data source. Joined tables are always merged into a single table. As a result, sometimes joined data is missing unmatched values, or duplicates aggregated values.
Joins –
1) Are displayed with Venn diagram icons between physical tables
2) Require you to select join types and join clauses
3) Joined physical tables are merged into a single logical table with a fixed combination of data
4) May drop unmatched measure values
5) May duplicate aggregate values when fields are at different levels of detail
6) Support scenarios that require a single table of data, such as extract filters and
aggregation
Explanation:
Reference: https://help.tableau.com/current/online/en-us/datasource_relationships_learnmorepage.htm
Which of the following shapes does a Heat Map use by default?
- A . Square
- B . Line
- C . Text
- D . Circle
A
Explanation:
By default, the shape that a Heap map uses is a "Square". See below:
Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_highlight.htm
True or False: Trend lines can only be used with numeric or date fields
- A . True
- B . False
A
Explanation:
You can show trend lines in a visualization to highlight trends in your data.
To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf.
However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.
Reference: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm
Given a map, which of the following fields can be placed in Size,Shape,Detail,Color
- A . Profit, State, Number of Records, Sales
- B . Region, Country, Profit, State
- C . Longitude, Country, State, Sales
- D . Sales, State, Country, Profit
D
Explanation:
Since Sales is a measure, it can easily be depicted via size.
To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle, square etc.
Finally, the Profit can be depicted via a color! Eg – Red for poor and green for excellent profits!
Reference: https://www.tableau.com/learn/tutorials/on-demand/aggregation-granularity-and-ratio-calculations
Which of the following are True for Measure Names?
- A . It contains all the measures in your data, collected into a single field with continuous values.
- B . When you add it to a view, all of the measure names appear as row or column headers in the view.
- C . When working with a text table showing Profit for each Category,
when you add Sales to the text table (by dragging it and dropping it in the view), the measure names field is automatically dragged to the row and filter shelves. - D . It contains the names of all measures in your data, collected into a single field with discrete values.
B,C,D
Explanation:
It contains all the measures in your data, collected into a single field with continuous values – This is the definition for ‘Measure Values’.
All others are True w.r.t. Measure Names!
The Measure Names field contains the names of all measures in your data, collected into a single field with discrete values.
Graphical user interface, text, application, email
Description automatically generated
Documentation: https://help.tableau.com/current/pro/desktop/en-us/datafields_understanddatawindow_meavalues.htm
Which of the following are valid options to define the scope of a reference line? Choose 3.
- A . Pane
- B . Table
- C . Section
- D . Window
- E . cell
- F . Axis
A,B,E
Explanation:
When we create a reference line, we get the following 3 options for the scope:
Graphical user interface, chart
Description automatically generated
Reference: https://help.tableau.com/current/pro/desktop/en-us/reference_lines.htm
You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above.
What is the main thing that you do here?
- A . Clean the data
- B . Preview the data
- C . Create visualisations to analyze your data
- D . Rename the fields and change data types
C
Explanation:
The Tableau workspace consists of menus, a toolbar, the Data pane, cards and shelves, and one or more sheets. Sheets can be worksheets, dashboards, or stories. For details on dashboard or story workspaces, see Create a Dashboard or The Story Workspace.
Graphical user interface, application
Description automatically generated
The main thing you do in the workspace is to create visualisations to analyze your data.
Renaming data fields, cleaning the data, previewing the data can all be done in the Data source window.
Reference: https://help.tableau.com/current/pro/desktop/en-us/environment_workspace.htm
If you see a Blue field, generally it will add _____________ to the view
- A . axis
- B . both
- C . none
- D . headers
D
Explanation:
Important question!
Reference: https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm
If you use a percent difference Quick Table Calculation, what value will be the first data value?
- A . null
- B . -1
- C . 0000
- D . 0
A
Explanation:
When using a Percent difference, Tableau calculates what the percent change has occured as compared to the last data value. BUT, for the first data value, there is no previous value to compare it to. Hence, it appears as NULL.
Chart, line chart
Description automatically generated
True or False: The Highlighting action can be disabled for the entire workbook.
- A . True
- B . False
A
Explanation:
Yes, it is possible to disable highlighting for the entire workbook.
For more information: https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm
Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type.
What was the Profit for the Herbal Tea product type in 2013?
- A . 68,620
- B . 74,683
- C . 37,455
- D . 46,493
C
Explanation:
If you answered this question quickly and correctly, you’re well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back!
To create a dual axis chart for the problem mentioned:
1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:
2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:
3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:
4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.
Now the chart looks like this:
Now we change the Profit chart type to line:
5) Finally, we synchronise the axis as follows: Right click on the axis, and choose ‘Synchronise axis’
And, our final view and answer is:
Data blending simulates a traditional _________________ Join
- A . Inner
- B . Right
- C . Full Outer
- D . Left
D
Explanation:
Data blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data.
From the official website:
Reference: https://help.tableau.com/current/pro/desktop/en-us/multiple_connections.htm
Question 45: Skipped
You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?
- A . Sets
- B . Groups
- C . Calculation
- D . Parameters
D
Explanation:
A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.
For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. You can replace the constant value of “500000” in the formula with a parameter. Then, using the parameter control, you can dynamically change the threshold in your calculation.
For example –
Reference: https://help.tableau.com/current/pro/desktop/en-us/parameters_create.htm
True or False: It is possible to change the Geographic Role of a dimension
- A . True
- B . False
A
Explanation:
A geographic role associates each value in a field with a latitude and longitude value. Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names. To assign a geographic role to a field:
In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.
When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane: Latitude (generated) and Longitude (generated).
These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles. If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.
Reference: https://help.tableau.com/current/pro/desktop/en-us/maps_geographicroles.htm
A field that shows average home values for the United States in 2016 is most likely :
- A . A discrete date part dimension
- B . A continuous date value dimension
- C . A geographical dimension
- D . An aggregated measure
D
Explanation:
This question is directly from the Official Tableau Desktop Specialist exam guide.
Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we’re working with MEASURES.
Date part and Date values don’t really make much sense given the question, and neither does geography.
Therefore, the answer naturally is "An aggregated measure".
Dates in Tableau are typically treated as ______________
- A . Dimensions
- B . Measures
A
Explanation:
For relational data sources, dates and times are automatically placed in the Dimensions area of the Data pane and are identified by the date or date-time icon. For example, the Order Date and Ship Date dimensions from an Excel data source are shown below:
When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month.
Reference: https://help.tableau.com/current/pro/desktop/en-us/dates.htm
Which of the following options best describe measures?
- A . They are categorical, qualitative
- B . They are categorical, quantitative
- C . They are numerical, qualitative
- D . They are numerical, quantitative
D
Explanation:
Data fields are made from the columns in your data source. Each field is automatically assigned a data type (such as integer, string, date), and a role: Discrete Dimension or Continuous Measure (more common), or Continuous Dimension or Discrete Measure (less common).
Dimensions contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view.
Measures contain numeric, quantitative values that you can measure. Measures can be aggregated. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default).
Reference: https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm
________________ can only create header. _______________ will create header and axis both.
- A . Dimensions, Measures
- B . Measures, Dimensions
- C . Groups, Sets
- D . Dates, Strings
A
Explanation:
Using the Sample superstore as a reference:
1) Let’s plot a bar chart showing SUM(Quantity) for each Segment:
2) Right click on the x-axis (Segment):
Notice we don’t have an option to edit the axis, only header. This is because only continous values form the AXIS.
3) Similarly, right click on the y-axis (Quantity):
Now we have the option to edit BOTH the axis and the header.
Reference: https://help.tableau.com/current/pro/desktop/en-us/view_parts.htm
2) Right click on the x-axis (Segment):
Notice we don’t have an option to edit the axis, only header. This is because only continous values form the AXIS.
3) Similarly, right click on the y-axis (Quantity):
Now we have the option to edit BOTH the axis and the header.
Reference: https://help.tableau.com/current/pro/desktop/en-us/view_parts.htm
Which of the following are valid ways to show Mark Labels in the visualisation?
- A . Click on the Show mark labels icon in the Toolbar
- B . Drag the measure to the Text label in the Marks Card
- C . Click on Data in the Menu bar and Choose Show Mark Labels
- D . Click on Analysis in the Menu bar and choose Show Mark Labels
A,B,D
Explanation:
The following showcase how you can show mark labels. Using the Sample Superstore dataset:
1) Let’s create a Bar chart showing the sales for each sub-category:
2) Now you can show labels by:
Which of the following are valid ways to show Mark Labels in the visualisation?
- A . Click on the Show mark labels icon in the Toolbar
- B . Drag the measure to the Text label in the Marks Card
- C . Click on Data in the Menu bar and Choose Show Mark Labels
- D . Click on Analysis in the Menu bar and choose Show Mark Labels
A,B,D
Explanation:
The following showcase how you can show mark labels. Using the Sample Superstore dataset:
1) Let’s create a Bar chart showing the sales for each sub-category:
2) Now you can show labels by:
Which of the following are valid ways to show Mark Labels in the visualisation?
- A . Click on the Show mark labels icon in the Toolbar
- B . Drag the measure to the Text label in the Marks Card
- C . Click on Data in the Menu bar and Choose Show Mark Labels
- D . Click on Analysis in the Menu bar and choose Show Mark Labels
A,B,D
Explanation:
The following showcase how you can show mark labels. Using the Sample Superstore dataset:
1) Let’s create a Bar chart showing the sales for each sub-category:
2) Now you can show labels by:
Which of the following are valid ways to show Mark Labels in the visualisation?
- A . Click on the Show mark labels icon in the Toolbar
- B . Drag the measure to the Text label in the Marks Card
- C . Click on Data in the Menu bar and Choose Show Mark Labels
- D . Click on Analysis in the Menu bar and choose Show Mark Labels
A,B,D
Explanation:
The following showcase how you can show mark labels. Using the Sample Superstore dataset:
1) Let’s create a Bar chart showing the sales for each sub-category:
2) Now you can show labels by:
Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________.
- A . role, type
- B . Data type, Value
- C . type, role
- D . dimension, measure
A
Explanation:
When users connect to Tableau, the data fields in their data set are automatically assigned a role and a type.
Role can be of the following two types:
1) Dimension
2) Measure
Type can be of the following :
1) String
2) Number
3) Geographic
4) Boolean
5) Date
6) Date and Time
You can _______________ your data to combine two or more tables by appending values (rows) from one table to another
- A . join
- B . blend
- C . concatenate
- D . union
D
Explanation:
You can union your data to combine two or more tables by appending values (rows) from one table to another. To union your data in Tableau data source, the tables must come from the same connection.
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016," "June2016," and "July2016."
A union of these tables creates the following single table that contains all rows from all tables.
Reference: https://help.tableau.com/current/pro/desktop/en-us/union.htm
How can you MANUALLY assign geographic roles to a dimension from the data pane?
- A . Edit the config file in My Documents -> MyTableauRepository for a quick fix
- B . Right click it -> Geographic role -> and then assign the appropriate geographic role
- C . Edit the data source manually for a quick resolution
- D . Right click it -> Edit Default properties -> Assign geographic roles
B
Explanation:
From the data pane, simply right click on the dimension, choose geographic role, and then select the appropriate role as follows:
What is the one most important thing you should do after creating a Dual-axis chart?
- A . Synchronise the axis
- B . Change the colours
- C . Edit the labels
- D . Hide the axis
A
Explanation:
After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.
To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.
In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis. If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.
In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.
Reference: https://help.tableau.com/current/pro/desktop/en-us/multiple_measures.htm
A Tableau Support case can be opened in which of the following valid ways?
- A . Using the Developer Community Forum
- B . Contacting Salesforce using their website
- C . Using the support option on the Tableau website
- D . Using the Tableau learn website
C
Explanation:
It is possible to open a Tableau support case by visiting the following link :
https://www.tableau.com/support/case
When exporting a worksheet as an image in Tableau, which of the following file formats are available?
- A . Portable Network Graphic (.PNG)
- B . JPEG Image (.JPG, .JPEG)
- C . Tagged Image File Format (TIFF)
- D . Windows Bitmap (.BMP)
A,B,D
Explanation:
The following options are available when an image is Exported:
NOTE: When we Copy an image rather than exporting it, then the image is copied to the clipboard in the TIFF file format! However, it is not available when EXPORTING an image.
Reference: https://help.tableau.com/current/pro/desktop/en-us/save_export_image.htm
By default, what does Tableau do when you connect to a data source?
- A . Creates an extract of the data
- B . Creates a live connection to the data
- C . Loads your actual file into Tableau
- D . Sorts the data in descending order
B
Explanation:
Before you can build a view and analyze your data, you must first connect Tableau to your data. Tableau supports connecting to a wide variety of data, stored in a variety of places.
By default, when you connect a data source to Tableau, Tableau will create a live connection to the data.
Live connection refers to a data source that contains direct connection to underlying data, which provides real-time or near real-time data. With a live connection, Tableau makes queries directly against the database or other source, and returns the results of the query for use in a workbook. Users can create live connections and then share them on Tableau Server so that other Tableau users can use the same data using the same connection and filtering settings.
Reference: https://help.tableau.com/current/guides/everybody-install/en-us/everybody_admin_data.htm
A union of two tables usually results in an
- A . decrease in the number of rows
- B . increase in the number of rows
- C . decrease in the number of columns
- D . increase in the number of columns
B
Explanation:
From the official Tableau documentation:
You can union your data to combine two or more tables by appending values (ROWS) from one table to another. To union your data in Tableau data source, the tables must come from the same connection.
Graphical user interface, text
Description automatically generated
Reference: https://help.tableau.com/current/pro/desktop/en-us/union.htm
Which of the following are valid ways to copy a worksheet visualisation as an image?
- A . By simply clicking Control + V on the keyboard
- B . By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image
- C . Using the Marks shelf and choosing Copy->Image
- D . By right clicking on the worksheet visualisation and selecting Copy->Image
B,D
Explanation:
The following are 2 correct ways to copy the worksheet visualisation as an image:
AND
Reference: https://help.tableau.com/current/pro/desktop/en-us/save_export_image.htm
Which of the following are benefits of combining sheets using dashboards?
- A . Easier to compare visualisations side by side
- B . It is mandatory to combine sheets when using Tableau
- C . Helps in faster analysis
- D . Provides the ability to use one sheet as a filter for other
A,C,D
Explanation:
The only incorrect option is – It is mandatory to combine sheets when using Tableau.
All others are valid advantages that Dashboards provide when using Tableau!
True or False: It is not possible to blend axes for multiple measures into a single axis
- A . False
- B . True
A
Explanation:
We can very much blend multiple measures into a single axis. Such charts are called Combined-Axis / Blended-Axis charts.
Follow along:
Measures can share a single axis so that all the marks are shown in a single pane. To blend multiple measures, drag one measure or axis and drop it onto an existing axis.
Instead of adding rows and columns to the view, when you blend measures there is a single row or column and all of the values for each measure is shown along one continuous axis. For example, the view below shows quarterly sales and profit on a shared axis.
Note: If you drag a measure on to the canvas and only see a single ruler indicator instead of the double ruler indicator shown below, Tableau creates dual axes instead of a blended axis. For more information about how to create dual axes, see Compare two measures using dual axes.
Reference: https://help.tableau.com/current/pro/desktop/en-us/multiple_measures.htm
Which of the following can help us focus on specific data without removing data in the visualization?
- A . Highlighters
- B . Sets
- C . Clusters
- D . Filters
A
Explanation:
From the official documentation:
When you have a view with a large amount of data you might want to explore your data interactively and highlight a specific mark or group of marks while still maintaining the context of where those marks show in your view.
To do this you can turn on the Highlighter for one or more discrete fields that are included in your view and that affect the level of detail
Example – Here we just want to focus on Public Affairs college dimension, but don’t want to filter out or remove the rest of the data:
Chart, scatter chart
Description automatically generated
Note that filtering is not the correct option since that would REMOVE the data that doesn’t match the filtering criteria.
Reference: https://help.tableau.com/current/pro/desktop/en-us/actions_highlight_highlighter.htm
While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items.
- A . padding
- B . margining
- C . tiling
- D . spacing
A
Explanation:
Padding lets you precisely space items on dashboard, while borders and background colors let you visually highlight them. Inner padding sets the spacing between item contents and the perimeter of the border and background color; outer padding provides additional spacing beyond the border and background color.
Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_organize_floatingandtiled.htm
Which of the following is not a Trend Line Model?
- A . Linear Trend Line
- B . Exponential Trend Line
- C . binomial Trend Line
- D . Logarithmic Trend Line
C
Explanation:
According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau:
1) Linear Trend Line
2) Logarithmic Trend Line
3) Exponential Trend Line
4) Polynomial Trend Line
5) Power Model
Hence, the correct answer is BINOMIAL trend line which is not present in Tableau.
See the following image:
For more information, refer to: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm
Which one of the following is a dimension?
- A . Longitude
- B . Measure Names
- C . Number of records
- D . Latitude
B
Explanation:
Measure Names is a dimension. Latitude, Longitude, and Number of records are all measures.
Reference: https://help.tableau.com/current/pro/desktop/en-us/datafields_understanddatawindow.htm
You want to add Custom shapes to your visualisation. Where can you add these new shapes?
- A . In Downloads -> My Tableau Repository -> Shapes
- B . In My Computer -> C: -> Tableau -> Shapes
- C . In Program Files -> Tableau -> Shapes
- D . In My Documents -> My Tableau Repository -> Shapes
D
Explanation:
Here’s how to add image files to your repository:
1) Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags.
2) Download the image to your computer.
3) Drag images into your My Documents -> My Tableau repository -> Shapes folder.
4) Open Tableau and your new shapes will automatically be included in your "edit shapes" menu.
Reference: https://www.tableau.com/about/blog/2016/2/how-use-custom-shapes-filters-your-dashboard-50200
_____________ charts are typically used to represent accumulated totals over time and
are the conventional way to display stacked lines.
- A . Line
- B . Area
- C . Gantt
- D . Bullet
B
Explanation:
According to the official Tableau documentation:
An example of an area chart is shown below:
How can you change the default Tableau repository location?
- A . By clicking on Window -> Repository Location
- B . By clicking on Help -> Change Repository Location
- C . By clicking on File -> Repository Location and choosing a new location
- D . By Moving the repository location manually to wherever we want
C
Explanation:
According to the official Tableau documentation:
Graphical user interface, text, application
Description automatically generated
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm
What term is used to describe the following picture?
- A . Larger image
- B . Parameter
- C . Set
- D . Hierarchy
- E . Group
C
Explanation:
When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the viz. You can also create your own custom hierarchies. For example, if you have a set of fields named Region, State, and County, you can create a hierarchy from these fields so that you can quickly drill down between levels in the viz.
Reference: https://help.tableau.com/current/pro/desktop/en-us/qs_hierarchies.htm
Which of the following are valid ways to italicize Tooltip content in Tableau?
- A . Click on Format in the Menu bar, choose Font, and then edit the Tooltip options to italicize the font
- B . Click on Tooltip in the Marks card, select the text, and then use the Italics option
- C . Click on Worksheet in the Menu bar, select Tooltip, and then use the italics option
- D . Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option
A,B,C
Explanation:
The only incorrect option is – Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option.
This option doesn’t exist. See below:
The rest of the options do exist, and therefore are correct:
Graphical user interface, text, application
Description automatically generated
Larger image
What is this view referred to as in Tableau?
- A . Analytics Pane
- B . Window Pane
- C . Data Pane
- D . Dimensions & Measures
C
Explanation:
Tableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace.
The Data pane includes:
Dimension fields C Fields that contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view. Examples of dimensions include dates, customer names, and customer segments.
Measure fields C Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures: sales, profit, number of employees, temperature, frequency.
For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green.
Calculated fields C If your underlying data doesn’t include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called calculated fields.
For more information on calculated fields, see Create Custom Fields with Calculations. Sets C Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets.
Named sets from an MS Analysis Services server or from a Teradata OLAP connector also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau.
Parameters C Values that can be used as placeholders in formulas, or replace constant values in calculated fields and filters. For more information, see Create Parameters.
Reference: https://help.tableau.com/current/pro/desktop/en-us/datafields_understanddatawindow.htm
- A . Bullet
- B . Line
- C . Gantt
- D . Area
D
Explanation:
According to the official Tableau documentation:
An example of an area chart is shown below:
The calculation [Ship Date] – [Order Date] will return _______________
- A . Number of orders placed in that duration
- B . Number of days between these dates
- C . Number of unique orders placed between these dates
- D . Number of orders shipped between these dates
B
Explanation:
As the names suggest, if we subtract the order date from the shipping date, we simply get the number of days between these 2 dates.
We can these use this calculated field in our charts, and can use COUNT, SUM, AVG etc with them according to our need.
True or False: It is possible to add a field to more than one hierarchy
- A . True
- B . False
A
Explanation:
Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.
Reference: https://www.tableau.com/about/blog/2016/8/take-note-these-10-handy-tableau-shortcuts-57561
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment.
For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
- A . October
- B . September
- C . July
- D . June
A
Explanation:
Follow along:
1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.
For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.
The view should now look like:
It is clear that October with -55.3% had the lowest Year on Year growth.
When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks.
Search is scoped to the selected connection.
- A . Regex Search
- B . Union Search
- C . Pattern Search
- D . Wildcard Search
D
Explanation:
You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.
When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.
Reference: https://help.tableau.com/current/pro/desktop/en-us/union.htm
Suppose I have the following view.
What will be the total number of marks if I drag a new measure to the row shelf vs the column shelf?
- A . If dragged to row shelf: 14 marks; If dragged to column shelf: 7 marks
- B . If dragged to row shelf: 7 marks; If dragged to column shelf: 14 marks
- C . If dragged to row shelf: 14 marks; If dragged to column shelf: 14 marks
- D . If dragged to row shelf: 7 marks; If dragged to column shelf: 7 marks
A
Explanation:
This is a tricky question often asked in the exam.
If we drag a new measure to the row shelf, the following happens:
We now have 2 rows, and the same 7 columns for both these rows. Therefore, 2×7 = 14 marks!
Graphical user interface, chart, bar chart
Description automatically generated with medium confidence
But if we drag the same measure to the column shelf, we have just 1 row and a chart created for each of the columns. So (1×7) = 7 marks!
Graphical user interface, text, application
Description automatically generated
Reference and notes: https://medium.com/@justindixon91/tableau-specialist-exam-notes-part-4-understanding-tableau-concepts-f78de83fdd35
Which of the following are valid Dashboard size options?
- A . Range
- B . Fixed Size
- C . Automatic
- D . Scaled
A,B,C
Explanation:
Scaled is NOT a valid size options when creating Dashboards in Tableau!
After you create a dashboard, you might need to resize and reorganize it to work better for your users.
Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_organize_floatingandtiled.htm
To connect Tableau to a CSV data source what type of connection should you use?
- A . Spatial
- B . Excel
- C . Text
- D . JSON
C
Explanation:
Tableau recognises a CSV file as a TEXT file, and therefore it is the correct option.
The following are the steps to import a CSV file:
1) From the data connection screen, click on Text:
2) Choose the appropriate file, and click Open:
3) Finally, Tableau imports the data as shown below:
Reference: https://intellipaat.com/community/46338/how-to-import-csv-file-in-tableau
True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.
- A . rue
- B . False
B
Explanation:
It is possible in Tableau to use a sheet within a story directly.
Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.
At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.
Reference: https://help.tableau.com/current/pro/desktop/en-us/stories.htm
When you connect to a new data source, all worksheets that previously referred to the original data source now refer to the new data source. If the new data source does not have the same field names as the original workbook, the fields are marked with an exclamation point 
.
Which feature helps us fix this issue?
- A . Replace References
- B . Fix Metadata
- C . Renaming
- D . Aliases
A
Explanation:
Replace References:
When you successfully connect to a new data source, all worksheets in the workbook that previously referred to the original data source now refer to the new data source. If the new data source does not have the same field names as the original workbook, the fields become invalid and are marked with an exclamation point
. You can quickly resolve the problem by replacing the field’s references.
For example, say you have a workbook connected to a data source that contains a Customer Name field. Then you edit the data source to point to a new data source that has all the same data but instead of Customer Name, the field name has been changed to Name. The Customer Name field remains in the Data pane but is marked as invalid. To make the field valid, you can replace the references, which means you can map the invalid field to a valid field in the new data source (for example, Customer Name corresponds to Name).
Read more at: https://help.tableau.com/current/pro/desktop/en-us/howto_connect.htm