Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Tableau Certified Data Analyst Exam > Tableau > Flashcards

Tableau Flashcards

1
Q

Alias

A

Definition: An alternate name for members in a dimension. It makes a label appear differently in the view.

Discrete dimensions only. Aliases cannot be used for continuous dimensions, dates, or measures.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Histogram

A

Looks like a bar chart

Each bar represents data points that fall within a given range (a “bin”)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Geographic Role

A

Tableau assigns latitude and longitude values to every geographic role.

How 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 precise role needed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How to change a data field’s data type

A

Can be done on either the Data Source page or the Data pane.

Click the icon to the left of the field name and choose the new type.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Relationships vs. Joins

A

Relationships:

  • The primary means of combining data in Tableau
  • More dynamic and flexible than joins
  • Are displayed as flexible noodles between logical tables
  • Require you to select matching fields between two logical tables
  • Do not require you to select join types
  • Make all row and column data from related tables potentially available in the data source
  • Maintain each table’s level of detail in the data source and during analysis
  • Create independent domains at multiple levels of detail. Tables aren’t merged together in the data source.
  • During analysis, create the appropriate joins automatically, based on the fields in use.
  • Do not duplicate aggregate values (when Performance Options are set to Many-to-Many)
  • Keep unmatched measure values (when Performance Options are set to Some Records Match)

Joins:

  • No longer the primary means of combining data in Tableau
  • More static than relationships
  • Are displayed with Venn diagram icons between physical tables
  • Require you to select join types and join clauses
  • Joined physical tables are merged into a single logical table with a fixed combination of data
  • May drop unmatched measure values
  • May duplicate aggregate values when fields are at different levels of detail
  • Support scenarios that require a single table of data, such as extract filters and aggregation
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Types of LOD Expressions

A

There are three LOD expressions:

  1. FIXED - computes a value using the specified dimensions without reference to the dimensions in the view
  2. INCLUDE - computes a value using the specified dimensions in addition to whatever dimensions are in the view
  3. EXCLUDE - declares dimensions to omit from the view level of detail
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Joins

A

The merging of multiple data sources based on each source’s leftmost column of data.

There are four join types:

  • Inner: matches in both tables
  • Left: all values from the left table and any matches from the right table. When a value in the left table doesn’t have a match in the right table, you see a null value.
  • Right: all values from the right table and any matches from the left table. When a value in the right table doesn’t have a match in the left table, you see a null value.
  • Full Outer: all values from both tables. When a value from either table doesn’t have a math with the other table, you see a null value.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Unions

A

Combining data sources by appending rows of one table into another table.

Fields (aka column headers) must match for the union to work correctly.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Discrete Date Parts vs. Continuous Date Values

A

Discrete Date Parts

  • Blue
  • Produce headers in a view
  • Behave like dimensions

Continuous Date Values

  • Green
  • Produce axes in a view
  • Behave like measures
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Parameter

A

A workbook variable that replaces a constant value in a calculation, filter, or reference line.

Parameters can depend on the input of the user.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Aggregation type: Dimension

A

Returns a list of all unique values in a measure or dimension.

Example: if the measure contains values [1, 2, 2, 3] the Dimension aggregation will return [1, 2, 3]

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Aggregation type: Attribute

A

Returns the value only if all rows have the same value, otherwise it returns an asterisk.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Dimension vs. Measure

A

Dimension = qualitative values. Examples: names, dates, geographical data

Measure = numeric, quantitative values. Measures are aggregated when added to a view. The type of default aggregation depends on the context of the view.

Dimensions and measures can be either discrete or continuous.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Data Sources: Live Connection vs. Extract

A

Live connection: direct connection to underlying data, providing real-time data. Fresher data but slower performance. Stored in storage (hard drive) as opposed to memory (RAM).

Extract: a snapshot of data. Optimized for aggregation. Faster performance but less fresh data. .tde or .hyper file types. Extracts are stored in memory (RAM) as opposed to storage (hard drive).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Discrete fields vs. Continuous fields

A

Discrete = Blue. Finite. Column headers.

Continuous = Green. Infinite. Axes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Calculated Field

A

Calculated fields allow you to create new data from data that already exists in your data source. When you create a calculated field, you are essentially creating a new field (or column) in your data source, the values or members of which are determined by a calculation that you control. This new calculated field is saved to your data source in Tableau, and can be used to create more robust visualizations. But don’t worry: your original data remains untouched.

You create calculated fields using calculations. There are three main types of calculations you can use to create calculated fields in Tableau:

  • Basic calculations - Basic calculations allow you to transform values or members at the data source level of detail (a row-level calculation) or at the visualization level of detail (an aggregate calculation).
  • Level of Detail (LOD) expressions - Just like basic calculations, LOD calculations allow you to compute values at the data source level and the visualization level. However, LOD calculations give you even more control on the level of granularity you want to compute. They can be performed at a more granular level (INCLUDE), a less granular level (EXCLUDE), or an entirely independent level (FIXED) with respect to the granularity of the visualization.
  • Table calculations - Table calculations allow you to transform values at the level of detail of the visualization only.
17
Q

Table Calculation

A

A special type of calculated field that computes on the local data in Tableau. It transforms values in a visualization. They’re calculated based on what is currently in the visualization.

Examples:

  • Transform values into rankings
  • Transform values to show running totals
  • Transform values to show percent of total
18
Q

Crosstab

A

Just another term for a text table

In the Worksheet menu, there is a “duplicate as crosstab” option which will create a new worksheet with the data formatted as a text table.

19
Q

Order of Operations

A
  1. Extract Filters
  2. Data Source Filters
  3. Context Filters
    - -Sets, conditional filters, top N, Fixed LOD
  4. Dimension Filters
    - -Include/Exclude LOD, data blending
  5. Measure Filters
    - -Forecasts, table calcs, clusters, totals
  6. Table Calc Filters
    - -Trend lines, reference lines

(EDC-DMT)

https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm

20
Q

1.1.1. Choose an appropriate data source

A

https://help.tableau.com/current/pro/desktop/en-us/datasource_plan.htm

Important distinction between the Tableau data source and the source data itself. A Tableau data source is the link between your source data and Tableau. A Tableau data source is created when connecting to data.

Important distinction between a Tableau data source and a data connection. A single Tableau data source may contain multiple data connections to different databases or files.

21
Q

1.1.9. Replace the connected data source with another data source for an existing chart or sheet

A

While viewing a sheet, go to Data -> New Data Source. Select the replacement data source. Both data sources should then be listed at the top of the data pane.

In order to replace a data source, there must be at least one field in the view.

With at least one field in the view, go to Data -> Replace data source. A dialog window appears to allow the user to perform the replacement.

22
Q

How to create Data Source Filters and Extract Filters

A

Data source filter: On the data source page, in the top right corner, it says “Filters”. Click “Add”. When creating an extract from a data source, any existing data source filters will be recommended to become extract filters.

Extract filter: On the data source page, click the radio button for Extract, then click edit. In the dialog window that appears, extract filters can be created.

23
Q

Calculation building blocks

A

There are four basic components to calculations in Tableau:

  • Functions - Statements used to transform the values or members in a field.
  • Fields - Dimensions or measures (columns) from your data source.
  • Operators - Symbols that denote an operation.
  • Literal expressions - Constant values that are represented “as is”, such as “Profitable” and “Unprofitable”.

Additionally, calculations can contain:

  • Parameters - Placeholder variables that can be inserted into calculations to replace constant values.
  • Comments - Notes about a calculation or its parts, not included in the computation of the calculation.
24
Q

Transforming Data

A

Two main types of operations to transform data

  • Field operations. Change the field type or geographic role.
  • Value operations. Rename the field values themselves.
25
Q

Tableau Data Model

A

Split into 2 layers:

  • Logical layer - relationships. Keeps tables separated, but defines the relationships between them.
  • Physical layer - joins and unions. Tables are actually combined.
26
Q

Data Blending

A

Combining data from multiple sources at the sheet level while keeping the sources fundamentally separate (unlike joins or unions).

Two types of sources, primary and secondary. Primary source is determined by the first fields pulled into the view. It gets a blue check mark. Secondary sources get an orange check mark. Only the primary source can contribute dimensions to the view. Secondary sources can only contribute measures.

Fields which share the same name and data type across primary and secondary sources will automatically become available for blending.
-To manually define how fields map between sources, you can Edit Blend Relationships and select Custom option.

For calculated fields within blends, aggregation must be applied.

27
Q

Tableau-Generated Fields

A

Three types:

  1. Measure names & measure values - these contain all measure names and continuous values that exist in the workbook
  2. Count of table - The number of records in the table
  3. Latitude and Longitude

Tableau Certified Data Analyst Exam (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions