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
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:
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
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.
Dates in Tableau are typically treated as A . Dimensions
B . Measures
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.
True or False: It is possible to change the Geographic Role of a dimension A . True
B . False
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.
To use a quick table calculation, which of the following programming languages do you need to know? A . ython
B . Java
D . None of these
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:
Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.
Navigate to a new worksheet.
From the Data pane, under Dimensions, drag Order Date to the Columns shelf.
From the Data pane, under Dimensions, drag State to the Rows shelf.
From the Data pane, under Measures, drag Sales to Text on the Marks Card.
From the Data pane, under Measures, drag Profit to Color on the Marks Card.
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.
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])
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
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
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).
In Tableau Desktop, select Worksheet > Export > Data.
Select a location and type a name for your Access database or .csv file.
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.
True or False:
The Highlighting action can be disabled for the entire workbook. A . True
B . False
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
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%
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:
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
Explanation Extracts are advantageous for several reasons:
Supports large data sets: You can create extracts that contain billions of rows of data.
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.
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.
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.
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 Question: 73
True or False: A reference line cannot be added from the Analytics Pane A . True
B . False
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: