Tableau Certification

When using Animations in a Tableau, which of the following is the default duration for animations?

.3s you can choose a duration of up to 10 seconds you can animate every sheet by going to wb default and turning it on format -> animations to use animations

Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us

1 dimension (measure names) 4 measures (latitude, longitude, number of records, measure values)

Which of the following can you use to create a Histogram?

1 measure A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.

The View Data window displays as much of the data as possible by default, up to _______________ rows.

10,000 The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.

For Bullet Graphs we need at least ____________ measures

2 and zero or more dimensions A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Therefore, we need at least 2 measures for creating bullet graphs.

as best practice, how many categories can a pie chart display effectively

2-5. anything more is not easy for your eyes to distinguish

which of the following is NOT a new feature introduced in tableau 10

3 dimensional dashboards

We can join a maximum of ______ tables in Tableau

32

approximately what percent of work of a data scientist is data preparation

70%

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?

Context Filter. By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter. You may create a context filter to: 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.

Our use case states that we need to create a set showing the Bottom 10 products by Profit in each Region. Which of the following filter types should you apply on Region?

Context Filter. Context filters are executed before sets. This means that based on what Region's you've selected - Tableau will first only preserve the rows for those Regions. THEN, after this it will compute the Set , i.e , Bottom 10 products in each Region.

If you see the following Filter, then you're working with _______________________

Date Values Explanation Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display. The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric value Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter. Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.

when you change the value of a parameter on one page of the storyline, it also changes on all other pages of the storyline

FALSE

True or False: All rows from both tables are returned in an INNER JOIN

FALSE The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. Consider 2 tables "Orders" and "Customers". If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!

True or False: It is not possible to blend axes for multiple measures into a single axis

FALSE. We can very much blend multiple measures into a single axis. Such charts are called Combined-Axis / Blended-Axis charts Measures can share a single axis so that all the marks are shown in a single pane. To blend multiple measures, drag one measure or axis and drop it onto an existing axis. Instead of adding rows and columns to the view, when you blend measures there is a single row or column and all of the values for each measure is shown along one continuous axis. For example, the view below shows quarterly sales and profit on a shared axis. Note: If you drag a measure on to the canvas and only see a single ruler indicator instead of the double ruler indicator shown below, Tableau creates dual axes instead of a blended axis

Which of the following would you use to connect to multiple tables in a single data source at once?

Join The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data.

Data blending simulates a traditional _________________ Join

LEFT Data blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data.

Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

NO

is SUM a table calculation

NO!! SUM is an aggregate function, not a table calculation! A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization. Common table calculations: Running Total Percent Difference Difference Percent of Total Rank Percentile

How would you calculate GDP per capita in Tableau?

SUM([GDP])/SUM([POPULATION])

True or False: Trend lines can only be used with numeric or date fields

TRUE Explanation You can show trend lines in a visualization to highlight trends in your data. To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf. However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.

True or False: The Highlighting action can be disabled for the entire workbook.

TRUE.

we get a different color palette if we drop a discrete field on color in the marks card as opposed to dropping a continuous field

TRUE. Discrete: categorical palette. different color for each category. have no inherent order bc they are just categories. To change the color for a value 1) Click on an item on the left, under Select Data Item. 2) Click a new color in the palette on the right. In Tableau Desktop you can hover over a swatch to identify the color. 3) Repeat for as many values that you want to change. 4) In Tableau Desktop, click OK to exit the Edit Colors dialog box. In Tableau Server or Tableau Online, simply close the dialog box. FOR CONTINUOUS: you get a continuous range of colors, like the fade thin. you can set the number of steps and the colors for the highest and lowest and middle

it is possible to add a field to more than one hierarchy

TRUE. right click and choose duplicate field and then you can add it to more than one

True or False : Bins can be created on dimensions

True. Dimensions cannot be a string though-- have to be the numeric type Bin are a user-defined grouping of numerical data in the data source. According to the official Tableau documentation: It's sometimes useful to convert a continuous measure (or a numeric dimension) into bins.

Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

Yes.

you just added sum(profit) to the columns shelf

a horizontal axis. This question can be confusing for many students, so in such cases it's always best to practically try the question out in Tableau. We know that continuous fields will always create an axis, so options stating 'header' are automatically eliminated. For our question, see below:

which of the following are different ways you can select the worksheets to which you want to apply a filter

all using this data source, selected worksheets, only this worksheet

which of these are types of allowable values for any parameter

all. list. range.

which of these explains the conceptual difference between a line chart and an area chart

an area chart stacks up values of different categories on top of each other. a line chart visualizes them separately

what is the difference between the blue month() and the green month()

blue is a dimension and green is a measure. blue ignores higher periods such as year and treats month as a category. Green creates a proper TIMELINE

Dimensions containing ____________ and ____________ values cannot be continuous.

boolean and string dates can be discrete or continuous

which of the following statements about what can be used as pages in a storyline is TRUE

both worksheets and dashboards can be used as pages in a storyline. they cannot be combined on one page.

what is the main visual element of a treemap called

box

How can you change the default Tableau repository location?

by clicking on file -> repository location and then choosing a new location

Which of the following are valid ways to copy a worksheet visualisation as an image?

by clicking worksheet in the tableau main menu above and choosing copy-> image by right clicking on the worksheet visualization and choosing copy-> image

Which of the following fields would be best used as Dimensions?

categories Names and Categories would be mostly used as dimensions (categorical data). Profit and measures contain quantitative data and would be more suitable for Measures!

When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.

continuous. Explanation When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field. When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.

you may create a context filter to

create a dependent numerical or top n filter. improve performance in the filter pane, right click on it and then click 'add to context' the filter will then turn gray 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.

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?

create visualizations to analyze your data

By default, what does Tableau do when you connect to a data source?

creates a live connection to the data Before you can build a view and analyze your data, you must first connect Tableau to your data. Tableau supports connecting to a wide variety of data, stored in a variety of places. By default, when you connect a data source to Tableau, Tableau will create 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 stored in a .tds file? Choose 3.

data connection information. metadata edits. calculated fields. visualizations and data extracts are NOT saved in the .tds file

______________ refers to the level of detail for a piece of data, wherever you are looking.

data granularity Data is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data. For example, when looking at graduation data, granularity would describe whether a row in the data set represents a single person or the graduating class of a university.

what are the two main groups that all fields are broken up into in Tableau

dimension and measures

are clusters a dimension or a measure

dimension- because they represent a categorical split of your data

Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________

dimensions and measures When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.

________________ can only create header. _______________ will create header and axis both.

dimensions, measures This is because only continous values form the AXIS.

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.

disaggregate the measures The different aggregations available for a measure determine how the individual values are collected: they can be added (SUM), averaged (AVG), or set to the maximum (MAX) or minimum (MIN) value from the individual row values. Disaggregating your data can be useful for analyzing measures that you may want to use both independently and dependently in the view. For example, you may be analyzing the results from a product satisfaction survey with the Age of participants along one axis. You can aggregate the Age field to determine the average age of participants or disaggregate the data to determine at what age participants were most satisfied with the product. Disaggregating data can be useful when you are viewing data as a scatter plot.

Dragging a ______________ to colour creates distinct colours for each item whereas dragging a ______________ to colour creates a gradient

discrete value, continuous value Explanation Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map )

The default path for all supporting files, data sources, icons, logs etc is in ______________________

documents --> my tableau repository By default, all of the above mentioned are stored in Documents -> My Tableau Repository

According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?

extract filter the order for filters is: extract filter data source filter context filter dimension filter measure filter table calc filters

data blending in tableau happens after aggregation is performed on the separate datasets

false

Which of the following are benefits of using Data Extracts in Tableau?

faster to work with. ability to use data offline. improved performance. Explanation Extracts are advantageous for several reasons: 1) Supports large data sets: You can create extracts that contain billions of rows of data. 2) 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. 3) 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. 4) 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. 5) 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!

What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

fields used in blends must first be aggregated

Which of the following chart type makes use of 'binned' data?

histogram. A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.

Which of the following are valid objects when creating a dashboard in Tableau? Choose 4.

image, text, webpage, extension. NOT VIDEO.

Which of the following is true about 'Incremental refresh' when creating Extracts in Tableau?

it only adds rows that are new since the previous refresh Extracts are saved subsets of data that you can use to improve performance or to take advantage of Tableau functionality not available or supported in your original data. When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.

which of these is NOT a type of quick filter available in tableau

json lookup category

by definition, tableau displays measures over time as a

line. line charts connect individual data points in a view.

how many fields can you add to be shown in the label

no limit

does the introduction of cross database joins render blends completely useless

no. blends are a LEFT join that happens AFTER the data has been aggregated to the appropriate level.

Relationships are represented by __________________ and operate at the ____________________.

noodles, logical layer The default view that you first see in the Data Source page canvas is the logical layer of the data source. You combine data in the logical layer using relationships (or noodles).

Which of the following is an example of a Date Part?

november. if it has a year, quarter, date etc then these are data VALUES

If you use a percent difference Quick Table Calculation, what value will be the first data value?

null. When using a Percent difference, Tableau calculates what the percent change has occured as compared to the last data value. BUT, for the first data value, there is no previous value to compare it to. Hence, it appears as NULL.

You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?

parameters A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line. For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. You can replace the constant value of "500000" in the formula with a parameter. Then, using the parameter control, you can dynamically change the threshold in your calculation.

which of these tableau 9 features allows you to change the format of the data from where the years are in columns to when the years have their own columns

pivot

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.

remote field name, field name

how do you set geographic roles

right click the appropriate field and select the appropriate geographic role

what can happen when you join on a single field when it is required to join on multiple fields

rows will be duplicated without an actual reason, hyper inflation of measures, incorrect insights and business decisions

You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?

save it as a .tds file. Explanation: After making changes to Data, we can save that new data source as a .tds file. To do so, go to data menu on top and then choose your current connected data source. Then next click on Add to Saved Data sources. This will save all calculated fields, changes to fields etc. It will be saved in My Tableau Repository -> Mydatasources. This will then also appear on Tableau Home Page under saved data sources like SampleSuperStore. Note: 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 and .twbx are not the BEST solutions since the questions nowhere mentions that we need to store our workbooks as well. .twm is a bookmark which contains a single worksheet and are an easy way to quickly share your work.

Which of the following shapes does a Heat Map use by default?

square

which of the following is NOT a quick table calculation in tableau

stochastic oscillation

what does a highlighter allow you to accomplish

subtly highlight different marks on your chart based on the categories of the selected field without interfering with the charts visual representation (marks shown, sizes, etc)

what is the first thing you need to do after creating a dual axis chart

synchronize the axis

In order to avoid any confusions, what should you do after creating a Dual-axis chart?

synchronize the axis. To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis. In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis. If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear. In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.

_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

tableau server Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server. Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.

To connect Tableau to a CSV data source what type of connection should you use?

text

To connect tableau to a CSV data source what type of connection should you use?

text file

how is creating calculated fields in a blend different to creating normal calculated fields

the data elements used have to be aggregated

How do you decide what colors to use

the main thing to take into account is the end user / viewer. colors should assist them in seeing the insights that your charts are portraying

what happens when one of the tables has duplicate values in the join clause

the matching row of the other table is replicated to accommodate the number of duplicates

which of these is a good rough description of what happens when two tables are joined

the rows of the second table are placed to the side of the rows of the first. the table is extended horizontally

what are calculated fields in tableau

these are custom variables that you create from fields provided in the data

By default, measures placed in a view are aggregated. The type of aggregation applied ______________

this depends on the context of the view By default, measures placed in a view are aggregated. Mostly you'll notice that the aggregation is SUM, but not ALWAYS. The type of aggregation applied varies depending on the context of the view.

Which of the following are compelling reasons to use a Stacked Bar Chart?

to visualize parts of a whole. to be able to visualize complex information with less bars/ marks Additionally: To easily visualize trends over time - This is the definition of a line chart. To visualize each discrete category using a separate bar - This can be accomplished using a simple bar char

Most viewers scan content starting at the _____________ of a page.

top left

In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.

top left, bottom right

to add worksheets to a dashboard you can simply drag them onto the dashboard

true

you can automatically generate action: filter through the dropdown of the selected worksheet in the dashboard

true

what are customer segmentation dashboards used for

understand how customers are segmented across different geographies. to make better business decisions. to deliver a better customer experience making it tailored and relevant.

Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?

using 2 measures A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales. We can create a Bullet graph with just 2 measures! This method requires the LEAST number of fields possible to create this type of chart. The best way to tackle such questions in the exam is to click the "SHOW ME" button on top right, and hover over the chart we want to create.

Which of the following are valid ways of Grouping Data?

using labels in the view. using marks in the view. from the dimension shelf 3 ways to group data - 1) Marks - when you do this, they remain separate bars but are just colored according to the group you created 2) Labels - when you do this, they become one bar on a chart and are labeled by all the things you grouped 3) Dimensions shelf. - this creates a new dimension in the shelf titled sub category (groups) If we Group the data by selecting the marks, then they remain separate marks in the view and then have the same colour. Also, a new group is created in the Dimensions shelf.

how does tableau know at which level to aggregate variables

values are always aggregated at the level of granularity of the worksheet

What is the following icon in the Data pane used to do? (looks like a bunch of little lines columns and rows)

view data View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view. The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.

when would you need to create hierarchies in tableau

when there are hierarchies present in the dimensions and tableau needs to know about them for you to build your visualization

what is the main conceptual difference between action: filter and action: highlight for a dashboard

when you use action: filter you are removing data from analysis before it is illustrated on the visualization. action: highlight all the data is visualized first and then the action is applied after. can lead to discrepancies in results.

when would you use data blending and not data joining

when your datasets have different levels of granularity. when your data comes from disparate data sources. when you simply cannot do a join for any other reason

what is the best format of data for machines in tableau

where each measure and dimension has its own column

is it possible to specify additional variables for clustering analysis (apart from the variables present in your chart)

yes, you can specify additional variables AND you can remove unwanted variables from the clustering analysis without removing them from the chart

which of these is a valid reason to use a data extract over a live connection to the dataset

your data is constantly being updated and you want to work with a static file when building your visual (you will later return to the live connection when the visual is ready)