Theory Practice
Creating a scatter plot requires a minimum of how many measures? 3 2 4 1
2 We can use scatter plots to visualize relationships between numerical variables! In Tableau, you create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf (Total 2 minimum).
Suppose you have a bar chart. When we group by labels in a view, which of the following happens? Nothing changes in the view, but a group is created in the Dimensions shelf. The colours of the members selected are now the same, and different for the rest of the members. A new mark (bar) is created, which consolidates all members of the group. Trick question! It is not possible to group by labels. *Very important question*
A new mark (bar) is created, which consolidates all members of the group.
When field names in the Union do not match, then: Only one field name is present in the Union with null values Both field names are present in the Union, but contain several null values Only one field name is present in the Union with correct values since Tableau automatically corrects field name mismatch An error is raised and both fields are dropped from the resulting Union
Both field names are present in the Union, but contain several null values
If you have a dashboard and are displaying its filter, how can you rearrange it? By clicking on the filter title and dragging it. By clicking anywhere inside the filter and dragging it. By clicking on the 2 lines on top and dragging the filter. By clicking on the dropdown and dragging the filter
By clicking on the 2 lines on top and dragging the filter.
*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? By dragging another dimension to Color on the Marks card By dragging another measure to Color on the Marks card By dragging another measure to the Columns shelf By dragging another dimension to the Rows shelf
By dragging another dimension to Color on the Marks card
How can you format an axis as Bold in Tableau? By clicking on Format on the main menu bar, choosing field labels, and setting it to bold. By right clicking on the axis, choosing Edit Axis, and then setting its font to bold. By right clicking on the axis, choosing format, and then setting its font to bold. By choosing the axis and selecting Command/Control + B on your keyboard
By right clicking on the axis, choosing format, and then setting its font to bold.
***Which of the following are valid ways to Bold the Tooltip content in Tableau? Click on Tooltip in the Marks card, and select bold. Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold. Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option Click on Analysis, Tooltip options, and select bold.
Click on Tooltip in the Marks card, and select bold. Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold. Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option
Which of the following are benefits of combining sheets using dashboards? Easier to compare visualisations side by side Provides the ability to use one sheet as a filter for other Helps in faster analysis It is mandatory to combine sheets when using Tableau
Easier to compare visualisations side by side Provides the ability to use one sheet as a filter for another Helps in faster analysis
How can you add color to marks in the view in Tableau? In the column/row shelf, right click the field and click on edit in shelf to select the color. Click on Data in the main menu above, and click on choose color. From the Data pane, drag a field to Color on the Marks card. From the Analytics pane, drag a model to Color on the Marks card.
From the Data pane, drag a field to Color on the Marks card.
**Which of the following are valid ways to make the font more readable in Tableau? Make the Font color sharper / darker than the background Increase the font size Don't use backgrounds Decrease the font size Use a clear and readable font
Make the Font color sharper / darker than the background Increase the font size Use a clear and readable font
Which one of the following is a dimension? Measure Names Number of records Longitude Latitude
Measure Names Measure Names is a dimension. Latitude, Longitude, and Number of records are all measures.
Are animations enabled by default in Tableau? Yes No
No, by default, animations are not enabled in Tableau.
If you are working with a huge dataset, which of the following are strong reasons to use a context filter? To include only the data of interest Improve query performance To help clean the data To make the context filter a dependent filter
To include only the data of interest/include a numerical dependent or Top N filter Improve query performance
For which of the following charts, does the Size option on the Marks card not work? Gantt Chart Pie Chart Bar Chart Tree Map
Tree Map 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.
Which of the following are true about Dashboards in Tableau? A bar chart can be used a floating item Floating items can be layered over other objects None of these Tiled items don't overlap
A bar chart can be used a floating item Floating items can be layered over other objects Tiled items don't overlap
Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format. .tdex .tds .twbx .hyper
.hyper Beginning in version 10.5, when you create a new extract, it uses the .hyper format instead of the .tde format. Extracts in the .hyper format take advantage of the improved data engine, which supports the same fast analytical and query performance as the data engine before it, but for even larger extracts. Although there are many benefits of using .hyper extracts, the primary benefits include the following: 1) Create larger extracts: You can create extracts with billions of rows of data. Because .hyper extracts can support more data, you can consolidate .tde extracts that you previously had to create separately into a single .hyper extract. 2) Create and refresh extracts faster: While Tableau has always optimized performance for creating and refreshing extracts, version 2020.3 supports faster extract creation and refreshes for even larger data sets. 3) Experience better performance when interacting with views that use extract data sources: Although smaller extracts continue to perform efficiently, larger extracts perform more efficiently.
What is a story point in Tableau? A single worksheet or dashboard A collection of worksheets A collection of both worksheets and dashboards A collection of dashboards
A single worksheet or dashboard 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. A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories (for more details, see Workbooks and Sheets). At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point. When you share a story —for example, by publishing a workbook to Tableau Public, Tableau Server, or Tableau Online—users can interact with the story to reveal new findings or ask new questions of the data.
Which of the following can you add a reference line to? Calculated Fields Groups Measures Dimensions
Calculated Fields Measures 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.
A Tableau Data Source File (.tds) contains which of the following? Copy of any local file-based data Calculated Fields Default Field Properties Data Source Type
Calculated Fields Default Field Properties Data Source Type All are correct, except - Copy of any local file-based data. This is contained in a .tdsx file (Tableau Packaged Data Source)!
Which of the following are valid ways to italicize Tooltip content in Tableau? Click on Format in the Menu bar, choose Font, and then edit the Tooltip options to italicize the font Click on Tooltip in the Marks card, select the text, and then use the Italics option Click on Worksheet in the Menu bar, select Tooltip, and then use the italics option Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option
Click on Format in the Menu bar, choose Font, and then edit the Tooltip options to italicize the font Click on Tooltip in the Marks card, select the text, and then use the Italics option Click on Worksheet in the Menu bar, select Tooltip, and then use the italics option
Which of the following sets would you use to compare the members? Dynamic Sets Combined Sets None of these Static Sets
Combined Sets You can combine two sets to compare the members. When you combine sets you create a new set containing either the combination of all members, just the members that exist in both, or members that exist in one set but not the other. Combining sets allows you to answer complex questions and compare cohorts of your data. For example, to determine the percentage of customers who purchased both last year and this year, you can combine two sets containing the customers from each year and return only the customers that exist in both sets. To combine two sets, they must be based on the same dimensions. That is, you can combine a set containing the top customers with another set containing the customers that purchased last year. However, you cannot combine the top customers set with a top products set.
By default, what does Tableau do when you connect to a data source? Loads your actual file into Tableau Creates an extract of the data Sorts the data in descending order Creates a live connection to the data
Creates 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.
Which of the following are true about dimensions? Dates are mostly placed in dimensions by default for relational data sources They contain contain numeric, quantitative values They contain qualitative values (such as names, dates, or geographical data) They affect the level of detail in the view
Dates are mostly placed in dimensions by default for relational data sources They contain qualitative values (such as names, dates, or geographical data) They affect the level of detail in the view
What do the colours Blue and Green represent in Tableau? Measures and Dimensions Continuous and Discrete Discrete and Continuous Dimensions and Measures
Discrete and Continuous
A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau. Go to Sheet Go to URL Go to Web page Go to Hyperlink
Go to URL 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.
Which of the following are valid Layout Container types when using Dashboards in Tableau? Diagonal Container Horizontal Container Vertical Container Split Container
Horizontal Container (resizes the width of the views and objects it contains) Vertical Container (adjusts height)
Which of the following is a compelling reason to export a sheet in Tableau to a PDF? If we want to dynamically enter parameters to the visualisation. If we want a static view of the visualisation. If we want to use filters in the visualisation. If we want to interact with the visualisation. Explanation
If we want a static view of the visualisation. It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualisation exported PDF. In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer. When you print an individual sheet to PDF, filters in the view are not included. To show filters, create a dashboard containing the sheet and export the dashboard to PDF. (IMPORTANT)
You may create a context filter to: To create a dependent filter Improve performance Create a dependent numerical or top N filter To replace a data source filter
Improve performance Create a dependent numerical or top N filter Explanation Important question! You cannot use a context filter to replace a data source filter since each filter type has its own use case. Also, a content filter is an Independent filter and all other filters are called dependent since they only process the data that passes through a context filter.
Which of the following are valid Dashboard size options? Range Scaled Automatic Fixed Size
Range Automatic Fixed Size
Which of these is NOT a type of Quick Filter available in Tableau? Single Value (slider) Multiple Values (dropdown) Regex Match Wildcard Match
Regex Match
Which of the following are valid way(s) to make either of Rows or Columns Bold without affecting the other? Choose Format then Font from the Menu bar, and select Bold under the Header option Right click on Rows or Columns, and choose format. In the Font option click on Bold. Select Text Label on the Marks Card, choose Rows or Columns, and then select Bold. 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. Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option
Which of the following options best describe measures? They are numerical, quantitative They are categorical, quantitative They are categorical, qualitative They are numerical, qualitative
They are numerical, quantitative 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).
Which of the following is a benefit of using a Tableau Data Source (.tds)? 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. 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 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. To hold one or more worksheets, plus zero or more dashboards and stories. Explanation
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 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) - 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 - To hold one or more worksheets, plus zero or more dashboards and stories.
Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections? To support additional functionality such as count distinct Fast to create To have access to the freshest possible data at all times Help improve performance
To support additional functionality such as count distinct Fast to create Help improve performance Also: supports large data sets provides offline access From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde!
Which of the following are valid ways to add Totals to a view? Using the Marks shelf Using the Analytics Pane From the Analysis Tab in the Menu bar on top Using the Data Pane
Using the Analytics Pane From the Analysis Tab in the Menu bar on top
How does Tableau know at which level to aggregate values? Values are always aggregated at the level of granularity of the worksheet. Aggregation is always done by using Tableau special formulas Values are always aggregated at the level of the Date Part Tableau doesn't aggregate values, we do!
Values are always aggregated at the level of granularity of the worksheet.
Which of the following calculations DO NOT need a quick table calculation? Rank Moving Average Variance Standard Deviation
Variance Standard Deviation For Standard Deviation and Variance, we don't need to use quick table calculations, since they are available by default.
When is an axis created for the visualisation in Tableau? When we drag a measure to the row/column shelf When we drag a discrete field to the row/column shelf When we drag a continuous field to the row/column shelf When we drag a dimension to the row/column shelf
When we drag a continuous field to the row/column shelf
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. Pattern Search Wildcard Search Regex Search Union Search
Wildcard Search 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.
Is it possible to make a Measure discrete?
Yes Right click on any measure, and choose Discrete as shown:
When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette. stepped diverging converging reversed
diverging
If you see a Blue field, generally it will add _____________ to the view axis headers both none
headers Green measures (ex SUM(Profit)) and dimensions (ex YEAR(order Date)) are continuous. Continuous field values are treated as an infinite range. Generally, continuous fields add axes to the view. Blue measures (ex Sum(Profit)) and dimensions (ex Product Name)) are discrete. Discrete values are treated as finite. Generally, discrete fields add headers to the view.
A union of two tables usually results in an _____________________ increase in the number of rows decrease in the number of rows increase in the number of columns decrease in the number of columns
increase in the number of rows
_______________ 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. .twb .tde .tbm .tds
.tds 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.
