Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?
You have the following visualization.
You need to show how Internet Usage values change from year-to-year as a percentage. Which quick table calculation should you apply to the Internet Usage field?
You have a workbook that contains one data source and you need to combine data from another database. What should you do first?
Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?
What are two use cases for creating hierarchies from the Data pane? Choose two.
True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
If you are working with a huge dataset, which of the following are strong reasons to use a context filter?
Which of the following are valid Layout Container types when using Dashboards in Tableau?
Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.
Given a map, which of the following fields can be placed on Size,Shape,Detail,Color
DOWNLOAD THE DATASET FROM: https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven't already)
Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?
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?
Which of the following would you use to connect to multiple tables in a single data source at once?
For which of the following charts, does the Size option on the Marks card not work?
Which of the following describes the best way to change the formatting at a workbook level?
Tableau will automatically create a hierarchy for which two kinds of data? Choose two.
You need to access options to change a dimension's color palette.
In addition to the Marks card, what else can you use?
________________ 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.
You are creating a combined axis chart.
Where should you drag the second measure after dragging the first measure to the Rows shelf?
You view the relationship canvas shown in the following exhibit.
What does Migrated Data indicate?
In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.
What statement correctly describes a requirement to create a reference line in Tableau?
You have a visualization that uses multiple types of sorting.
How can you clear all sorting of the visualization?
Which of the following are the options to export the data used to build the view / visualisations?
You create a visualization by first adding a measure to rows. Next, you add a dimension wilh 11 members to columns.
Assuming that all the dimensions have a non-zero value, how many marks are in the view before and after the dimension is added?
You have the following visualization.
Where should you place a field named Region to show multiple distinct lines on the same axis?
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
Which statement accurately describes creating a group by selecting headers in a view?
What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?
If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view.
We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.
You have the following legend.
What occurs when you click the icon to the right of Air Ticketing Cabin Type Name?
Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?
__________ is a technique in Tableau which will identify marks with similar characteristics
When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.
Relationships are represented by __________________ and operate at the ____________________.
True or False: When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, then relating these tables is not possible.
You create the following visualization.
What is the first step to create the visual grouping of the 10 marks shown in blue?
You can create _______________ for members in a dimension so that their labels appear differently in the view.
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?
In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.
Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________.
Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?
Which two options can you use to change the device layout of a dashboard? Choose two.
If you have a dashboard and are displaying its filter, how can you rearrange it?
Which of the following is true about 'Incremental refresh' when creating Extracts in Tableau?
In which of the following scenarios would having a live connection be more beneficial than using an extract?
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)
Which two actions can you perform when you join tables from multiple connections? Choose two.
True or False: The Highlighting action can be disabled for the entire workbook.
When viewing quick table calculations, such as Percent Difference From, that use a value in the previous column, what will be the first data value in the visualization?
True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________
_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.