Tableau DS Certification
To create Bullet Charts?
0 or more Dims. , 2 Mea.
To create a Gantt chart?
1 date, 1 or more Dims. , 0-2 Mea.
If you are working with a huge dataset, which of the following are strong reasons to use a context filter?
1) Improve performance - If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance. 2) Create a dependent numerical or top N filter - You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.
Which of the following are valid ways to trigger actions for a Dashboard?
1) Select 2) Hover 3) Menu
Creating a scatter plot requires a minimum of how many measures?
2
Tableau Map Source (.tms)
A Tableau Map Source file contains information about maps and its elements for use in Tableau. The extension of such files is .tms. As per the default settings, Tableau will fetch map details like background and other layers from a certain map server or provider. In Tableau, you have the option to add map details from a WMS server of your choice or a custom map from Mapbox. Once you create a map file (.tms) of your preference, Tableau will fetch map details from that file instead of the default one and load map images and information accordingly. You can also share these .tms users in your group for others to use. To create a Tableau Map Source (.tms) file, click on Map from the toolbar. Then go to Background Maps and select WMS Server from Map Services> Add. After adding the map server of your choice, you can export it to your local desktop by selecting an Export option from the WMS Server connections window. To use this map in future, add the .tms file into the Tableau Repository in the Map sources directory.
Tableau Packaged Data Source (.tdsx)
A Tableau Packaged Data Source file is a file that contains information of a data source connection along with the data extracted from that source. The extracted data is saved as a .tde file and the information on data source as .tds file (like we saw above). The extracted data can be from any local file such as a text file, extract files (.hyper or .tde), Excel files, Access files, etc. However, the extension of a Tableau Packaged Data Source file has the extension as .tdsx. The Tableau Packaged Data Source files are used when we want to share data and other relevant information about a data source with a user who does not have access to the data source and its data. To create a .tdsx file, go to the Data tab on the toolbar. Then choose a data source that you wish to connect to and select Add To Saved Data Source option. After this, save that file as Tableau Packaged Data Source file.
Tableau Preference (.tps)
A Tableau Preference file contains all the information related to a customized color palette. You can create a custom color palette or a theme and save it as a .tps file so that you can use it all over the workbook uniformly at once. The Tableau Preference files have the extension as .tps and exist in XML format. These Tableau Preference files are present in My Tableau Repository. Next in DataFlair's Tableau file types article, we will see how to change the location of your Tableau repository.
Suppose you have a bar chart. When we group by labels in a view, which of the following happens?
A new mark (bar) is created, which consolidates all members of the group.
What main panels are on the start page?
Connect, Open, and Discover
How do you set a default aggregation
Adjust the aggregation in the measures column in the data pane on the left
When is an axis created for the visualisation in Tableau?
An Individual Axis in Tableau is obtained by adding a continuous into Rows or Columns Shelf.
Which of the following are valid ways to show Mark Labels in the visualisation?
Analysis bar -> Show marks, Drag measure to text label on marks card, click show mark labels on toolbar
Which of the following are valid Dashboard size options?
Automatic, Range, Fixed Size
Extract Benefits and Cons
Belongs to a particular time, Save and Refresh Snapshot, Better Performance and Portability, Use when numbers are not so important
Give an example of a use case scenario for a Discrete Measure
Bucket Fields with classifications (ex: Good, Bad)
For creating variable sized bins we use __________________
Calculated Fields
Which of the following are valid options to define the scope of a reference line? Choose 3.
Cell, Pane, Table
Which of the following are valid way(s) to make either of Rows or Columns Bold without affecting the other?
Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option Right click on Rows or Columns, and choose format. In the Font option click on Bold.
Which of the following are valid ways to export a dashboard with multiple visualisations as an image?
Click on Dashboard in menu bar and then Copy Image
Which role can Strings and Booleans not take on?
Continuous
How can you create a bucket field from a measure
Create a calculated field with an IF/ELSE condition
You may create a context filter to:
Create a dependent numerical or TOP N filter, to improve performance
You may create a context filter to:
Create a dependent numerical or top N filter, Improve Performance
When is blending useful?
Cross-DB join not available, Tables at different LOD (Ex: Table 1 order/week level, Table 2 daily level), Joins create duplicate data or data cleaning required, huge amount of data (joins take a lot of time
Which field brings a color palette if you add it to color mark ?
Discrete
Which of the following are valid ways to show Mark Labels in the visualisation?
Drag the measure to the text label in Marks, Click the show mark labels icon in the toolbar, Click on Analysis in menu and choose show mark labels
True or False: Sets can be created on Measures
False
Three types of Connections
File, Server, and Saved Data Source
Tableau Bookmark (.tbm)
Files with the extension .tbm are Tableau Bookmark files. These Tableau file types are most commonly used to save worksheets and share them with others so that they can use it in their workbooks without having to create a new worksheet from scratch. To create a .tbm file, go to the Windows option present on the toolbar. From there, select Bookmark and then click on Create Bookmark. This will create a .tbm file of the active worksheet. However, with the newer version of Tableau that was released, the use of Bookmark files has gone down. In Tableau versions 8.1. and later, we can directly copy and paste worksheets from one workbook to the other without having to create a .tbm file for it.
What are all the Action filter types?
Filter, Highlight, Go to URL, Go to Sheet, Change Parameter, Change Set Values
Discrete (Map)
Form: Individually Separate, Color: Blue, Filtered: Individually, Nature: Countable, Generally Adds Header to view, Brings: Level of Detail
Continuous
Form: Unbroken Whole, Color: Green, Filtered: In a range, Nature: Measurable, Generally adds axes to a view, Brings: Aggregated Number
Which of the following are valid ways to italicize Tooltip content in Tableau?
Format in Menu Bar then choose font, Click tooltips in marks card, Click on Worksheets in menu bar then select tooltip
How do you disable aggregation of measures
Go into the Analytics tab and uncheck Aggregate measures
How to save a .tds file?
Go to Tableau Repository and click save as .tds file
Which of the following URL prefixes are permitted when creating a URL Action in Tableau?
HTTP, HTTPS, FTP
Which of the following are FALSE about Joins?
Joins can be defined at the time of query dynamically, Joined tables are never merged into a single table, they are a more dynamic way than relationships to combine data
What is Data interpreter
It is used to structure your tables
What is Granularity
It is when you break your information into small pieces
What does the Left Panel do
It shows the details of your data source. You can add data sources (may use data interpreter). Contains database/schema name, lists the table names
Which of the following lets you group related dashboard items together so you can quickly position them?
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
4 main areas of the data source page
Left Panel, Canvas, data grate, metadata grate
Which of the following are the options to export the data used to build the view / visualisations?
MS Access Database, CSV file
Which of the following are valid options to define the scope of a reference line?
Pane, Cell, Table
To customize links based on the data in your dashboard, you can automatically enter field values as _______________ in URLs.
Parameters
Which of the following are valid ways to Bold the Tooltip content in Tableau?
Right click in viz and select format, Click tooltips in marks card, Click on Worksheets in menu bar then select tooltip
How to create a Hierarchy?
Right click on a field and select create hierarchy in the drop down
What are the types of aggregations that can be done on Measures
SUM, AVG, MEDIAN, COUNT(D), MIN, MAX, STD. DEV, VARIANCE
Given a map, which of the following fields can be placed on Size,Shape,Detail,Color
Sales, State, Country, Profit 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!
Which of the following are True for Measure Names?
The Measure Names field contains the names of all measures in your data, collected into a single field with discrete values. When added to view, the measure names appear as row or column headers in the view When working with a text table showing profit for each category, when you add sales to the table, the measures name field is automatically dragged to the row and filter shelves
Tableau Data Extract (.tde)
The Tableau Data Extract files have the extension .tde. These Tableau file types only contain a local copy of the entire or a subset of data from its source. It is important to note here that the .tde files do not contain a file path or information about the data source, workbooks, dashboards, etc. Tableau Data Extract files are important and useful as they are highly compressed and optimized to improve Tableau's performance (especially when you are using a slow data connection). You can use .tde files for offline work as well. One noted drawback of such Tableau file types is that the data in it cannot be refreshed automatically as and when it refreshes at the source. However, Tableau has a few step process to refresh the data present as an extract in your .tde files. To create a Tableau Data Extract (.tde) file, go to the Data tab present on the top left of the Tableau toolbar. Select a data source and click on the Extract Data option. After this, you can either select fields from the data source that you wish to extract or just click on Extract to create a data extract file (.tde) of the entire data set present at the data source.
Tableau Data Source (.tds)
The Tableau Data Source files are files that contain all the necessary information regarding a data connection made in Tableau. When we set up a fresh connection to a data source we make a lot of modifications in it as per our requirements such as setting data types, aggregations, custom fields, etc. The Tableau Data Source files contain all the required information on setting up a data connection along with the metadata of other specific modifications made by the users. The .tds file helps in saving information on data connections with custom fields and table joins. However, this Tableau file type only saves the information needed to establish a connection with a data source but not the actual data. Thus, such files can be used to share information between users having access to the same data source. To create a .tds file, go to the Data tab on the toolbar. Then choose a data source that you wish to connect to and select Add To Saved Data Source option. After this, save that file as Tableau Data Source file.
Tableau Packaged Workbook (.twbx)
The Tableau Packaged Workbook file type has both information about the constituents of a workbook and the data extracted from the data source. The data extract taken from the source is present in the form of a .tde file. Tableau Packaged Workbook files have an extension .twbx. You can use a .twbx file type in place of a .twb (Tableau Workbook) file when you wish to share a workbook with a user who does not have access to the live data connection. Thus, in this case, you need to have a file which contains data extracted from the source along with the other information about the workbook. The Tableau Packaged Workbook files can also contain information about attached images or customized geocoding. To create a .twbx file, go to File then select Save As and then select the .twbx option from the drop-down list given there.
Tableau Workbook (.twb)
The Tableau Workbook file type is the one that you will use the most when working in Tableau. This file type has the extension .twb and is set as default for the users. As we know, a workbook in Tableau is a file that contains sheets, dashboards, etc. So, this particular Tableau file type contains information about worksheets and dashboards present within a workbook. All the information regarding the fields, aggregation types, styles, formatting, filters, etc is present in these files. One important thing to note about this Tableau file type is that we can only create them if we are using live data connections and share them only with the users having access to the same live data connection. The .twb files also contain metadata related to the existing data connection. However, a .twb file does not contain actual data concerning the workbook. To create .twb file, go to the data source control panel of the active data connection and then go to File option (present on the toolbar) and select Save As. Then, you can select the file type as Tableau Workbook from the Save As Type drop-down list.
What does the box in a box plot represent?
The interquartile range 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.
Which of the following points are True about Viz Animations?
They can be turned on for certain worksheets only, It is possible to turn them on for the entire workbook, Sequential animations may take more time but make complex changes clearer by presenting them step by step
Which of the following are valid ways to Bold the Tooltip content in Tableau?
Through Worksheet, the marks card, right click and format
Which of the following is a benefit of using a Tableau Data Source (.tds)?
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.
For which of the following charts, does the Size option on the Marks card not work?
Tree Map
How can you create charts in Tableau?
Use the show me feature to see which types of fields are required
Canvas Area?
Used to define table relationships or joins
When is an axis created for the visualisation in Tableau?
When a continuous field is dragged to row or columns
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?
Yes, it can be done with the help of a web page object
How can you make your visualizations more granular
You can add dimensions to the Shapes or Colors card
Which of the following describes the best way to change the formatting at a workbook level?
choose format from the top menu, then specify the formatting in the new Format workbook pane
Measure
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).
Dimension
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.
What is the default Aggregation for Measures
depends on the context of the view
Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?
fast to create, improves performance, allows further functionality such as COUNTD
While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items
padding
Live Connection Benefits and Cons
real time data, slow perform. huge data, Server Availability problems, Use when numbers must be correct
Green Fields
represents continuous fields. Continuous fields form an unbroken whole (infinite range). Generally, these fields add axes to the view
Blue Fields
represents individually separate and distinct fields. They are treated as finite and generally add headers to the view
Which of the following are true about dimensions?
they affect the LOD, they contain qualitative values, Dates are mostly placed in dimensions by default
