For Bullet Graphs we need at least ____________ measures
- A . 3
- B . 1
- C . 2
- D . 4
C
Explanation:
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Therefore, we need at least 2 measures for creating bullet graphs.
Reference: https://help.tableau.com/current/pro/desktop/en-us/qs_bullet_graphs.htm
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
- A . True
- B . False
A
Explanation:
Explanation This is true, indeed! The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.
Reference: https://www.w3schools.com/sql/sql_join_left.asp
Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK).
For the University of Manchester, what percent of the total publications were contributed in 2014?
- A . 28.415%
- B . 23.497%
- C . 25.683%
- D . 22.404%
D
Explanation:
Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We’ll be using filters, as well as quick table calculations (percent of total) for this one.
1) Firstly, let’s drag Country and Institution to the Rows shelf, and year (discrete) to the Columns shelf. Then, drag Publications to the Text Icon in the Marks Shelf.
The following is our view:
Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system’s web browser?
- A . YES, we can do this with the help of a plugin
- B . NO, this is not currently possible in Tableau
- C . YES, we can do this with the help of a Web-Page object
- D . YES, we can do this with the help of Tableau Public
C
Explanation:
Explanation To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.
For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.
Reference: https://help.tableau.com/current/pro/desktop/en-us/actions_dashboards.htm
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/engb/actions_highlight.htm
True or False: Tableau can create worksheet-specific filters
- A . True
- B . False
A
Explanation:
Explanation Yes, it is possible to create worksheet-specific filters in Tableau. When you add a filter to a worksheet, by default it applies to the current worksheet.
Sometimes, however, you might want to apply the filter to other worksheets in the workbook. Then, you can select specific worksheets to apply the filter to or apply it globally to all worksheets that use the same data source or related data sources.
Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering_global.htm
Which of the following chart type makes use of ‘binned’ data?
- A . Gantt Chart
- B . Bullet chart
- C . Histogram
- D . Treemaps
C
Explanation:
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.
Reference: https://help.tableau.com/current/pro/desktop/enus/buildexamples_histogram.htm
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 data type in Tableau does this icon represent?
Larger image
- A . String
- B . True or False
- C . Boolean
- D . Geographic
D
Explanation:
Explanation The following is the table for the data types in Tableau along with their icons:
Reference: https://help.tableau.com/current/pro/desktop/enus/datafields_typesandroles_datatypes.htm
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
Larger image
What is this entire view referred to as in Tableau?
- A . Data pane
- B . Analytics Pane
- C . Summary Pane
- D . Distribution Pane
B
Explanation:
Distribution Pane
This is the Analytics pane! Read more from the official documentation below:
Reference: https://help.tableau.com/current/pro/desktop/enus/environ_workspace_analytics_pane.htm
True or False: Bins can be created on dimensions
- A . False
- B . rue
B
Explanation:
Explanation Bin are a user-defined grouping of numerical data in the data source.
According to the official Tableau documentation: It’s sometimes useful to convert a continuous measure (or a numeric dimension) into bins. Have a look at the following image. When we right click a measure, we get the following options:
However, for a dimension (this is because the DATA TYPE of this dimension is a string:
But what if we have a dimension of type NUMBER (NUMERIC DIMENSION)? See below:
We can clearly create bins from dimensions too – they just have to be numeric 🙂
For more information, please refer to: https://help.tableau.com/current/pro/desktop/enus/calculations_bins.htm
________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you’ve made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.
- A . .tbm
- B . .tds
- C . .tde
- D . .twb
B
Explanation:
According to the official Tableau documentation:
Tableau data source files have the .tds file extension. Data source files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you’ve made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on. For more information, see Save Data Sources.
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm
When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.
- A . Discrete
- B . Fading
- C . Continuous
- D . Mixed
C
Explanation:
When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field. When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.
Web version:
Desktop Version: For more information about color palettes, see Color Palettes and Effects.
How do you identify a continuous field in Tableau?
- A . It is identified by a blue pill in the visualization
- B . It is identified by a green pill in a visualization
- C . It is preceded by a ‘=#’ symbol in the data window
- D . It is preceded by a ‘Abc’ symbol in the data window
B
Explanation:
Explanation When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.
Reference: https://help.tableau.com/current/pro/desktop/enus/datafields_typesandroles.htm
The View Data window displays as much of the data as possible by default, up to _______________ rows.
- A . 20,000
- B . 5,000
- C . 10,000
- D . 15,000
C
Explanation:
The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.
Read more: https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm
________________ 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:
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 using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A . Red, Blue
- B . Orange, Blue
- C . Blue, Red
- D . Blue, Orange
D
Explanation:
When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark.
See below:
Reference: https://www.tutorialspoint.com/tableau/tableau_data_blending.htm
What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?
- A . No difference, calculated fields cannot be created in Blends
- B . Fields used in Blends must first be aggregated
- C . The calculated fields created in Blends cannot be edited once created
- D . The calculated fields created in Blends cannot use more than 2 fields
B
Explanation:
Yes, due to the nature of blends, there are some conditions as follows from the official documentation that must be kept in mind while working with blends:
In addition to handling calculations slightly differently, there are some limitations on secondary data sources. You may not be able to sort by a field from a secondary data source, and action filters may not work as expected with blended data. For more information, see Other data blending issues.
Reference: https://help.tableau.com/current/pro/desktop/en-us/multiple_connections.htm
When using Animations in a Tableau, which of the following is the default duration for animations?
- A . 0.4s
- B . 0.3s
- C . 0.5s
- D . 0.2s
B
Explanation:
The LATEST Tableau Desktop Sepcialist exam blueprint now requires you to know some basics about animations as well!
NOTE: Animations are DISABLED by default and must be manually enabled.
You can also reset all settings to default by clickin on ‘Reset All’ Reference: https://help.tableau.com/current/pro/desktop/en-us/formatting_animations.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
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
In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.
- A . top left bottom left
- B . top right, bottom right
- C . top left, bottom right
- D . top right, bottom left
C
Explanation:
Tree maps size begins from maximum in top left to smallest in bottom right.
See below to learn how to create a TreeMap and add colours to it:
Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_treemap.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
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.
Reference: https://help.tableau.com/current/pro/desktop/en-us/save_export_data.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:
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".
You can use the __________________ in Tableau to clean / organise your data.
- A . Data cleaner
- B . Data manager
- C . Data interpreter
- D . Data organiser
C
Explanation:
When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add white space, and you probably have multiple tabs of data too. When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That’s where Data Interpreter can help.
Reference: https://help.tableau.com/current/pro/desktop/en-us/data_interpreter.htm
Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view.
Which Item Number ID made the maximum sales across all assortments?
- A . 584
- B . 901
- C . Correct)
- D . 205
- E . 660
B
Explanation:
Follow along the steps below:
✑ Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab as below:
Which of the following can you add a reference line to?
- A . Groups
- B . Calculated Fields
- C . Measures
- D . Dimensions
B,C
Explanation:
You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view.
Reference Lines – You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.
Reference: https://help.tableau.com/current/pro/desktop/en-us/reference_lines.htm
Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan.
What was the average Quantity in the State of Tokyo?
- A . 3.000
- B . 3.840
- C . 3.704
- D . 3.500
C
Explanation:
Explanation Since we need to focus on 1 country -> Japan, let’s filter on it first as follows:
1) Drag Country to the filter shelf, and choose only Japan. Click OK.
2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let’s do that: Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well. Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.
The following is our visualisation:
Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME. Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward 🙂
How would you calculate GDP per capita in Tableau?
- A . SUM([GDP]/[POPULATION])
- B . SUM([Population]/[GDP]])
- C . SUM([GDP]*[POPULATION])
- D . SUM([GDP]) / SUM([Population])
D
Explanation:
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
How can you format numbers in Tableau as currency?
- A . Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- B . Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- C . Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
- D . Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.
A
Explanation:
According to the official Tableau documentation: Reference: https://help.tableau.com/current/pro/desktop/enus/formatting_specific_numbers.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
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/enus/sortgroup_groups_creating.htm
True or False: It is possible to change the Geographic Role of a dimension
- A . True
- B . False
A
Explanation:
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
Create a Set containing Customer Names whose Sales are GREATER than 30,000.
Which customer had the LEAST sales in this set?
- A . Tom Ashbrook
- B . Sanjit Engle
- C . Penelope Sewall
- D . Tamara Chand
C
Explanation:
Explanation As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000
1) Right click on customer name –> Create –> Set
2) Let’s Name the Set – Customer>30k ( you can name it anything you want 🙂 ) Select USE ALL, and then move to the CONDITION TAB:
3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000, and click OK
4) You should now have a new Set in the Data Pane as follows:
5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.
6) Click on the Show Mark Labels, and Sort ascending icons as shown:
7) Voila! We have our answer:
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.
- A . Tableau Packaged Workbook (.twbx)
- B . Tableau Workbook (.twb)
- C . Tableau Data Extract (.tde)
- D . Tableau Data Source (.tds)
C
Explanation:
Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data source. When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.
Extracts are advantageous for several reasons:
1) Supports large data sets: You can create extracts that contain billions of rows of data.
2) Fast to create: If you’re working with large data sets, creating and working with extracts can be faster than working with the original data.
3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.
4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that’s not available or supported by the original data, such as the ability to compute Count Distinct.
5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.
Are animations enabled by default in Tableau?
- A . No
- B . Yes
A
Explanation:
No, by default, animations are not enabled in Tableau. We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate. Animations visually transition between filter, sort, and zoom settings, different pages, and
changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.
When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.
2) Sequential animations Sequential animations take more time but make complex changes clearer by presenting them step-by-step.
To Animate visualizations in a workbook:
1) Choose Format > Animations.
2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:
For Duration, choose a preset, or specify a custom duration of up to 10 seconds. For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.
3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.
Reference: https://help.tableau.com/current/pro/desktop/en-us/formatting_animations.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:
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-filtersyour-dashboard-50200
According to Tableau’s ‘Order of Operations’, which of the following filters is applied FIRST?
- A . Dimension Filter
- B . Measure Filter
- C . Context Filter
- D . Extract Filter
D
Explanation:
According to Tableau’s order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below:
Reference: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm
True or False: A reference line cannot be added from the Analytics Pane
- A . True
- B . False
B
Explanation:
You can add a reference line to any continuous axis in the view. To add a reference line: Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view. In a simple case, the drop target area offers three options:
Reference: https://help.tableau.com/current/pro/desktop/en-us/reference_lines.htm
What does the box in a box plot represent?
- A . Maximum value of the data
- B . Minimum value of the data
- C . The interquartile range
- D . The median of the middle half of the data points
C
Explanation:
Explanation In a box and whisker plot:
1) The ends of the box are the upper and lower quartiles, so the box spans the interquartile range
2) The median is marked by a vertical line inside the box
3) The whiskers are the two lines outside the box that extend to the highest and lowest observations.
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
D
Explanation:
According to the official Tableau documentation:
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm
Which of the following are benefits of using Data Extracts in Tableau?
- A . Improved Performance
- B . Ability to use the data offline
- C . Working with freshest data at all times
- D . Faster to work with
A,B,D
Explanation:
Explanation Extracts are advantageous for several reasons:
1) Supports large data sets: You can create extracts that contain billions of rows of data.
2) Fast to create: If you’re working with large data sets, creating and working with extracts can be faster than working with the original data.
3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.
4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that’s not available or supported by the original data, such as the ability to compute Count Distinct.
5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.
To work with the MOST up-do-date data, use a live connection instead!
Reference: https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm
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
To use a quick table calculation, which of the following programming languages do you need to know?
- A . ython
- B . Java
- C . Javascript
- D . None of these
D
Explanation:
You don’t need to know ANY programming language to use quick table calculations!
Follow along with the steps below to learn how to apply a quick table calculation to a visualization:
1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.
2) Navigate to a new worksheet.
3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf.
4) From the Data pane, under Dimensions, drag State to the Rows shelf.
5) From the Data pane, under Measures, drag Sales to Text on the Marks Card.
6) From the Data pane, under Measures, drag Profit to Color on the Marks Card.
7) On the Marks card, click the Mark Type drop-down and select Square.
The visualization updates to look like this:
Apply the quick table calculation
1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.
Note: You can only perform quick table calculations on measures in the view. A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.
Reference: https://help.tableau.com/current/pro/desktop/enus/calculations_tablecalculations_quick.htm
Which of the following is a benefit of using a Tableau Data Source (.tds)?
- A . To hold one or more worksheets, plus zero or more dashboards and stories.
- B . To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you’ve made on top of the actual data such as changing default properties, creating calculated fields etc
- C . To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don’t have access to the original data.
- D . To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
B
Explanation:
The following are the official definitions from the Tableau documentation for the various file types:
1). tds (Tableau Data Source) – To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you’ve made on top of the actual data such as changing default properties, creating calculated fields etc. (CORRECT ANSWER)
2). twbx (Tableau packaged workbook) – To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don’t have access to the original data.
3) Extract (. hyper or .tde) C To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.
3) (.twb) Workbooks C To hold one or more worksheets, plus zero or more dashboards and stories.
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm
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
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:
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:
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/enus/trendlines_add.htm
The default path for all supporting files, data sources, icons, logs etc is in
- A . Documents -> Tableau Files
- B . Documents -> Tableau
- C . Documents -> My Tableau Repository
- D . Downloads -> Tableau Support Files
C
Explanation:
By default, all of the above mentioned are stored in Documents -> My Tableau Repository
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm