General Practice Flashcards

You can utilize _________________ to union files across folders and worksheets across workbooks while working with Excel, text file data, JSON file data, or.pdf file data. The search is restricted to the connection that has been selected.

Answer: Wildcard Search

Wildcard Search (or Wildcard Union) is a powerful feature in Tableau that allows users to combine multiple files or worksheets that share a common naming pattern from a specified folder or workbook into a single logical table. This is particularly useful for data sources like Excel, text files, JSON, or PDF, enabling efficient unioning of data without manually adding each individual file or sheet. The search is indeed restricted to the currently selected connection.

In Tableau, what is a story point?

Answer: A single worksheet or dashboard

In Tableau, a story point is a single page within a 'story,' which is a feature designed to present data insights in a guided narrative format. Each story point can contain either a single worksheet or a single dashboard, along with text annotations to explain the insights being presented. It serves as a snapshot of a particular view or analysis.

Is it able to discretize a Measure?

Answer: B) Yes

Yes, it is possible to discretize a Measure in Tableau. While measures are typically continuous and represented by green pills, you can convert them to discrete fields. This can be done by changing the field's data type to discrete or by creating bins from a continuous measure, which effectively categorizes the continuous data into discrete ranges.

In Tableau, how do you make an axis bold?

Answer: By right clicking on the axis, choosing format, and then setting its font to bold.

To make an axis bold in Tableau, you typically right-click directly on the axis in your view. From the context menu that appears, you select 'Format,' which opens the Format pane. Within this pane, you can then navigate to the 'Font' section and set the desired font style, including bold, for the axis labels and title.

Assume you have a bar graph. Which of the following happens when we group by labels in a view?

Answer: A new mark (bar) is created, which consolidates all members of the group.

When you group by labels (or marks) in a Tableau view, such as selecting multiple bars in a bar graph, Tableau consolidates the selected members into a single, new mark. This new mark (e.g., a single bar) represents the aggregated value of all the members within that group, effectively combining them visually in the chart. Additionally, a new group field is created in the Dimensions pane.

True/False: Two fixed points cannot be used to create a Reference Band.

Answer: B) False

This statement is False. A Reference Band in Tableau is specifically designed to shade an area between two values on an axis. These two values can indeed be fixed points (constant values), parameters, or computed values from a field, defining the upper and lower boundaries of the band.

True/False: A continuous axis cannot be used in a Reference Distribution plot.

Answer: A) False

This statement is False. A Reference Distribution plot in Tableau is specifically used to shade a range of values along a *continuous* axis. It helps visualize the distribution of data, often using percentages, quantiles, or standard deviations, and therefore requires a continuous measure to define these ranges.

When __________________, the aggregation method attr() returns a *.

Answer: There are more than one value in all rows in the group

The aggregation method ATTR() (Attribute) in Tableau returns an asterisk (*) when there is more than one distinct value for the expression within all rows in the group. If there is only a single, unique value for all rows in the group, ATTR() will return that specific value. It's useful for checking if a dimension is unique at a certain level of detail.

Which of the following is not a model with a trend line?

Answer: Binomial Trend Line

Tableau offers several types of trend line models to analyze patterns in data, including Linear, Logarithmic, Exponential, and Polynomial. A 'Binomial Trend Line' is not a standard or available trend line model option within Tableau's analytics pane for fitting data. Binomial typically refers to a probability distribution, not a regression model for trend analysis.

True/False: For the entire worksheet, the Highlighting action can be turned off.

Answer: B) True

This statement is True. Highlighting actions in Tableau can be configured and managed. You can specifically turn off the highlighting action for an entire worksheet or dashboard, preventing marks from being highlighted when selections are made in other views or within the same view. This provides control over the interactive behavior of your visualizations.

Is it able to use a URL action on a dashboard object to open a Web Page within a dashboard instead of the system's default web browser?

Answer: True, with the use of a Web Page object

Yes, it is possible to use a URL action on a dashboard object to open a web page directly within the dashboard itself, rather than launching the system's default web browser. This is achieved by first adding a 'Web Page' object to your dashboard and then configuring the URL action to target that specific Web Page object.

Is it allowed to utilize the same measure in various views (for example, SUM and AVG)?

Answer: A) Yes

Yes, it is absolutely allowed to utilize the same measure in various views with different aggregations in Tableau. You can drag a measure like 'Sales' onto the view multiple times and then set each instance to a different aggregation, such as SUM(Sales) and AVG(Sales), allowing for diverse analyses and comparisons within a single worksheet or across multiple views.

We use _________________ to make variable-size bins.

Answer: Calculated fields

To create variable-size bins in Tableau, you typically use calculated fields. While Tableau's built-in bin feature creates bins of equal size, calculated fields allow you to define custom logic using IF/ELSEIF statements or other functions to categorize your data into ranges of different widths or specific criteria, thus creating variable-sized bins.

Tableau, by definition, shows measurements over time as a ____________.

Answer: Line

Tableau, by default, shows measurements over time as a Line chart. This is because line charts are highly effective for visualizing trends, patterns, and changes in data over a continuous period, making them the standard choice when a date or time dimension is used on an axis with a measure.

A ______________ is the icon associated with the field that has been grouped.

Answer: Paper Clip

In Tableau, a Paper Clip icon is associated with a field that has been grouped. This visual cue helps users quickly identify grouped fields in the Data pane, distinguishing them from regular dimensions, measures, sets, or parameters.

What is the profitably moving average for November 2013, including the four months before and after?

Answer: $8,441

To calculate the profitability moving average for November 2013, including the four months before and four months after, you would sum the profitability values for the nine months from July 2013 to March 2014 (inclusive). Then, you would divide this sum by nine to get the average. The specific value of $8,441 would be derived from the underlying data provided in the original context of the question.

In your view, the best trend model is the one that has?

Answer: R-Squared value closest to 1

In Tableau, the best trend model is generally the one that has an R-Squared value closest to 1. R-Squared (Coefficient of Determination) indicates the proportion of the variance in the dependent variable that is predictable from the independent variable(s). A value closer to 1 signifies that the model explains a larger proportion of the variance and thus provides a better fit to the data.

In the event of blended data sources, what is the default join type?

Answer: Left outer Join

In the event of blended data sources in Tableau, the default join type is effectively a Left Outer Join. When blending, Tableau queries the primary data source for all its rows and then queries the secondary data source for rows that match the linking fields, bringing in only the matching data from the secondary source.

True/False: Dimensions cannot be used to form bins.

Answer: B) True

This statement is True. In Tableau, bins are specifically created from *measures*, which are typically continuous numerical data. Bins allow you to group these continuous values into discrete, equal-sized ranges. Dimensions, by nature, are already discrete or categorical, so the concept of creating bins from them does not apply in the same way.

True/False: In a dashboard, the highlight action is comparable to the filtering action in a worksheet.

Answer: A) False

This statement is False. While both highlighting and filtering actions are interactive features in Tableau, they serve different purposes. A highlighting action visually emphasizes related marks across different worksheets or dashboards without removing any data from the view, whereas a filtering action *removes* non-selected data from the view, thereby changing the data displayed. They are not comparable in their fundamental effect on the data.