Tableau Specialist – Exam 1 – Free

Solution

Labels in the view can be grouped. By grouping labels, a new mark (bar) is created, which consolidates all members of the group. Later you can rename the newly created group as stationary.

Hold Ctrl key and Click on the categories to select both Pencil and Papers as shown below

Just mouse hover on the selected area and select the Group Icon

This will create a new bar that you can rename later.

Solution

This screen comes for the filter when you are dealing with dates that are continuous so from the choices given in the question the most appropriate answer is Date Values.

Date values behave like a continuous measure.

Reference Link

https://www.thedataschool.co.uk/harry-cooney/tableau-dateparts-vs-datevalues/#:~:text=Dates%20in%20Tableau%20will%20behave,as%20line%20charts%20will%20display.

Solution

All file types are correct except database files and data warehousing files.

This question is very important as in the exam there could be different variations of this content.

They may ask the similar question in a different way.

We suggest you to have very good understanding for the file types in the Tableau especially the obsolete type .tde

For Example, some other variations of the same content could be like this

_____________ contains the visualizations, info needed to build the visualizations, and a copy of the data source

_________________ are 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.

Answers to above questions are Tableau Packaged Workbook (.twbx) and .tde / .Hyper files respectively

Better to have walk through of the article mentioned below

https://help.tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm#create-a-twbx-with-filebased-data-sources

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

Solution

This was a tricky questions checking your conceptual understanding for handling the database tables.

Join is the right answer for this question, there were two main key points to identify the correct answer. First one was that all tables are in the same database and second was to connect at once.

Based on these two factors, we can quickly identify that Join is the best option for this.

Cross database joins works well when you are dealing with two different data bases or data sources and you want to join them

Blending work when you are dealing with different data sources and you want to join but the difference is that it gives the aggregated results

For more information, refer the following link

https://help.tableau.com/current/pro/desktop/en-us/joins_xbd_perf.htm#:~:text=Select%20the%20file%20or%20database,database%20join%20option%20is%20displayed.

https://help.tableau.com/current/pro/desktop/en-us/multiple_connections.htm#:~:text=Data%20blending%20is%20performed%20on,becomes%20the%20primary%20data%20source.

Solution

Correct answer to this questions is Data Granularity

For more details on the topic, refer the link below

https://medium.com/@narula.rashmi888/granularity-nested-lod-expressions-3-d02140c28189#:~:text=In%20Tableau%2C%20granularity%20refers%20to,the%20Rows%20or%20Columns%20shelf.

Solution

This is your original data

When you apply a quick table calculation for percentage difference as shown below

The screen shows the percentage difference among the quarters as shown in the figure below.

It is clearly visible that for Year 2023, it is showing the % Difference values for 3 quarters for 2023

whereas

For year 2024, we can see the % Difference for all the Quarters.

Solution

To union your data in Tableau data source, the tables must come from the same connection.

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

Solution

The correct answer is

As per John, you can rearrange the filters on the dashboard, by clicking on the 2 lines on top of the filter and dragging the filter.

Further Explanation

Once you click on the filter, it shows you double bar at the top of the filter as shown below

User take the mouse to double bar and can drag the filter on the needed place.

Solution

Clustering is a technique in Tableau which will identify marks with similar characteristics

Clustering techniques consider data tuples as objects. They partition the objects into groups, or clusters, so that objects within a cluster are “similar” to one another and “dissimilar” to objects in other clusters.

https://www.sciencedirect.com/topics/computer-science/clustering-technique

Solution

The correct option for this is

Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

For reference, see the links below

https://help.tableau.com/current/pro/desktop/en-us/formatting_specific_numbers.htm#:~:text=Right%2Dclick%20the%20Profit%20axis,decimal%20places%20to%20the%20figures.

Solution

In the question, they have asked to calculate the Profit Ration which suggests we need to divide Profit by Sales.

Since the default aggregation of Tableau is Sum, so we need to sum the measures individually and then use in the calculated field to find their respective ratio.

Correct formula will be sum (Profit) divided by Sum(Sales)

Solution

This is a very common requirement and can be handled by Manual Sort.

You can expect many variation of such questions in the exam, we suggest you to go through the link given below and cover all aspects related to different sort and how they work

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

Solution

First Option

Second Option

Solution

https://help.tableau.com/current/pro/desktop/en-us/calculations_aggregation.htm#:~:text=Disaggregating%20your%20data%20means%20that,one%20time%20to%20deselect%20it.

Solution

• Image A represents a Data pane
• Image B represents Analytics Pane

Following links further elaborate the answers

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

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

Solution

• Go to Sheet, URL Actions, Filter Actions, and Highlight Actions are correct statements and they bring interactivity.
• Change Parameters is also an option to bring interactivity in the dashboard, in the question it is mentioned that it does not bring interactivity so it is wrong option
• Edit Tooltip Actions does not exist in tableau, so it is also wrong

For reference see the below links

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

Solution

The issue is related to the Country data field because it is missing the geographic role.

When you will assign the geographic role to the country field, it will start plotting the map properly

To enhance the grip on the subject, refer the URL below

https://help.tableau.com/current/pro/desktop/en-us/maps_geographicroles.htm#:~:text=Assigning%20a%20geographic%20role%20based,a%20list%20of%20city%20names.

Solution

It is located in my documents folder as shown in the above screenshot. For more details see the following link for reference

See the URL for further details

https://www.tableau.com/blog/how-use-custom-shapes-filters-your-dashboard-50200

Solution

It is fairly possible, you can set the animation speed of a particular sheet in the workbook. Tableau provides an override animation speed option.

Tableau provides such option to override.

Note:

In the specialist exam, Tableau expects that you should have a basic understanding of these concepts and therefore we strongly recommend you to have a detailed walkthrough of the article link given below. Default timing of animation, difference in animation and their usages are important to understand.

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

Solution

The correct answer is that it will give us 1 day less than the exact no of days an employee has worked.

For example

Employee Hire Date: Sep 18

Employee Last Working Date: Sep 20

As per formula it will return the following results

[Last Working Date] - [Hire Date]

20 – 18

2

This calculation has given us an answer of 2 let us calculate it manually

He has actually worked on dates 18, 19 and 20. Which makes a total of 3 days.

It means that the calculation given in the question will give 1 day less than the actual days an employee has worked.

Solution

Yes, we can use the same measure multiple times in the same view. The view treats the second measure as a separate chart in the same view

Solution

For your reference see the link below

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

Solution

These are the properties of the Pareto chart

For further reference, see the following link

https://asq.org/quality-resources/pareto

Expected Answer:

Refresh your view

Answer Explanation:

When connecting to some databases, you can specify an initial SQL command that will run when a connection is made to the database, for example, when you open the workbook, refresh an extract, sign in to Tableau Server, or publish to Tableau Server. Initial SQL is not run when

your refresh your view. Note that this initial SQL is different than a custom SQL connection. A custom SQL connection defines a relation (or table) to issue queries against.

Solution

Manual Sort is the correct answer

For a manual sort, no matter how the data changes, the values will always stay in the sort order you have created.

Solution

Correct statements are following

Wildcard Match is type of a Quick Filter in the Tableau
Multiple Values Dropdown is type of a Quick Filter in the Tableau

Further Explanation

Upon clicking on a filter, we see the following options:

Solution

Only correct statement here is

We can convert a Dimensions to continuous field provided that the data of the dimension is not of Boolean type or String type.

Solution

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

Solution

It is an option to view Data as a spreadsheet

https://help.tableau.com/current/pro/desktop/en-us/inspectdata_viewdata.htm#:~:text=Worksheet%3A%20Data%20pane&text=In%20a%20worksheet%2C%20selecting%20View,next%20to%20the%20Search%20field.

Solution

It is a discrete field and can be used as dimension

Discrete fields can be used as dimension irrespective of the fact that reflect numbers as their data

Solution

A new mark (bar) is created, which consolidates all members of the group.

Example shown below

Hold Ctrl key and Click on the categories to select both Pencil and Papers as shown below

Just mouse hover on the selected area and select the Group Icon

This will create a new bar that you can rename later.

Solution

Analytics Pane provides you option to drag total to the view

And select the needed option to enable the totals

After you select the option, it looks like this

Alternatively you can achieve the same result from the analysis menu

Solution

Yes, it is achievable by creating variable sized bins using calculated fields in the same histogram.

Following link shows the step by step solution to create it

https://www.rigordatasolutions.com/post/2018/08/11/tableau-charts-histogram-graph#:~:text=Histogram%20with%20varying%20bin%20size.,-We'll%20be&text=Right%20click%20anywhere%20on%20the,%3ECreate%3E%3ECalculated%20Field%E2%80%A6&text=Now%2C%20let's%20create%20our%20histogram,Records'%20to%20the%20rows%20shelf.

Solution

Measure names and Measure Values CANNOT be deleted in Tableau like other columns can. This is an auto-generated field.

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

Solution

https://help.tableau.com/current/pro/desktop/en-us/actions_running.htm#:~:text=Hover%20%2D%20Rest%20the%20pointer%20over,for%20all%20types%20of%20actions.

Solution

For the given scenario, since there is an urgency and you cannot wait, so for the given option,

opening the support ticket seems the best choice so you can have a chance to directly communicate with the technical team of the Tableau and get the solution.

Support Information Page

https://www.tableau.com/support/case

Customer Portal Login Page Link

https://identity.idp.tableau.com/login?

Note: Answer of this question is based on the rational that user thinks it is a product related issues and since he is in urgency to present to his client, so he can not take the chance to wait and should talk with the product specialist from the Product Owner

Solution

https://www.javatpoint.com/tableau-quick-filters

Solution

We can use Tableau Reader as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.

Tableau Reader is a free product that was created in the early days of Tableau to allow analysts and content creators to distribute content they built in Tableau Desktop. This was before Tableau Server was made available to organizations to govern the sharing and distribution of analytics content. At the time, Tableau Reader was the only option to share interactive content with other users in an organization without access to Tableau Desktop.

Solution

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

Solution

It is recommended to go through these links as some combinations of questions can be expected from this material

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

Solution

Dragging a Discrete value to color creates distinct colors for each item whereas dragging a Continuous Value to color creates a gradient

It is recommended to study this Tableau article in full as we have seen questions in the from this area

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

Solution

This is the sample of a tree map in Tableau

In Tree maps, the size begins with the largest rectangle on the top left and the smallest rectangle on the bottom right

https://www.tableau.com/data-insights/reference-library/visual-analytics/charts/treemaps#:~:text=The%20treemap%20functions%20as%20a,represent%20part%20to%20whole%20relationships.

Solution

The following are the correct statement

• The number of marks will increase when you increase the number of Dimensions in a view
• Increase the level of detail and control the number of marks in the view by including or excluding data.
• Tableau displays data using marks, where every mark corresponds to a row (or a group of rows) in your data source.

Following link contains more details on the Marks

https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm#:~:text=Tableau%20displays%20data%20using%20marks,mark%20type%20is%20a%20bar.

Expected Answer:

Options 1, 2 and 3 above

Answer Explanation:

Highlight actions allow you to call attention to marks of interest by coloring specific marks and dimming all others. You can highlight marks in the view using a variety of tools. For example, you can manually select the marks you want to highlight, use the legend to select related marks, use the highlighter to search for marks in context or create an advanced highlight action.

Expected Answer:

Extract Filters -> Data Source Filters -> Context Filters -> Measures Filters -> Table Calc Filters

Extract Filters -> Data Source Filters -> Context Filters -> set Filters -> Measures Filters -> Table Calc Filters

Answer Explanation:

Order of operation is explained in the following link

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