Tableau Desktop Specialist ACTUAL
UPDATED Questions and CORRECT
Answers
Start Page - CORRECT ANSWER - Welcomes you to Tableau
1. Connect
2. Open
3. Discover
Data Source Page - CORRECT ANSWER - Opens when you connect to a data source
1. Left Panel
2. Commissary
3. Data grid
4. Metadata
Measure - CORRECT ANSWER - Numerical data
Dimension - CORRECT ANSWER - Textual data & IDs
Italicized Fields - CORRECT ANSWER - Fields generated by Tableau
Marks - CORRECT ANSWER - Data points
Tableau Workbook - CORRECT ANSWER - .twb
Your project without data
Tableau Packaged Workbook - CORRECT ANSWER - .twbx
,Your project with data
.tds - CORRECT ANSWER - Data Source
Your path/directory (default properties, calculated fields) WITHOUT data
.tdsx - CORRECT ANSWER - Packaged Data Source
Your path/directory (default properties, calculated fields) WITH data
.hyper - CORRECT ANSWER - Extract file
Discrete Data - CORRECT ANSWER - Data with space between possible data values.
Graphs are represented by dots.
- Form: individually separate
- Color: blue
- Filtered individually
- Nature: countable
- Generally adds headers to view (creates categories)
- Brings level of detail
- Color Mark: color palette (all different colors)
Continuous Data - CORRECT ANSWER - Data that can take on any value. There is no
space between data values for a given domain. Graphs are represented by solid lines.
- Form: unbroken whole
- Color: green
- Filtered in a range
- Nature: measurable
- Generally adds axes to view (unbroken form)
- Brings aggregated numbers
, - Color Mark: 1 gradient color
What is true of discrete and continuous data 99% of the time? - CORRECT ANSWER -
Dimensions tend to be discrete
Measures tend to be continuous
How can a measure be discrete? (turned from a continuous measure) - CORRECT
ANSWER - Create buckets (good/bad buckets) by adding a if/else calculated field
How does Tableau aggregate data? - CORRECT ANSWER - Tableau aggregates measures
at the current level of detail (LOD)
What are the various aggregation functions? - CORRECT ANSWER - - Sum (default)
- Average
- Median
- Min
- Max
- Count
- CountD (distinct count)
- Standard Deviation & Variance
How do you change the default aggregation? - CORRECT ANSWER - Go to left sidebar -
-> right click "Default Properties" --> click "Aggregation" --> change function
Granularity - CORRECT ANSWER - The level of detail in the model. Breaking our data
points into smaller pieces
How do you increase and decrease granularity? - CORRECT ANSWER - Increase
granularity by dropping fields into the color, shape, and size Marks card boxes
Decrease granularity by removing fields from the Marks card
UPDATED Questions and CORRECT
Answers
Start Page - CORRECT ANSWER - Welcomes you to Tableau
1. Connect
2. Open
3. Discover
Data Source Page - CORRECT ANSWER - Opens when you connect to a data source
1. Left Panel
2. Commissary
3. Data grid
4. Metadata
Measure - CORRECT ANSWER - Numerical data
Dimension - CORRECT ANSWER - Textual data & IDs
Italicized Fields - CORRECT ANSWER - Fields generated by Tableau
Marks - CORRECT ANSWER - Data points
Tableau Workbook - CORRECT ANSWER - .twb
Your project without data
Tableau Packaged Workbook - CORRECT ANSWER - .twbx
,Your project with data
.tds - CORRECT ANSWER - Data Source
Your path/directory (default properties, calculated fields) WITHOUT data
.tdsx - CORRECT ANSWER - Packaged Data Source
Your path/directory (default properties, calculated fields) WITH data
.hyper - CORRECT ANSWER - Extract file
Discrete Data - CORRECT ANSWER - Data with space between possible data values.
Graphs are represented by dots.
- Form: individually separate
- Color: blue
- Filtered individually
- Nature: countable
- Generally adds headers to view (creates categories)
- Brings level of detail
- Color Mark: color palette (all different colors)
Continuous Data - CORRECT ANSWER - Data that can take on any value. There is no
space between data values for a given domain. Graphs are represented by solid lines.
- Form: unbroken whole
- Color: green
- Filtered in a range
- Nature: measurable
- Generally adds axes to view (unbroken form)
- Brings aggregated numbers
, - Color Mark: 1 gradient color
What is true of discrete and continuous data 99% of the time? - CORRECT ANSWER -
Dimensions tend to be discrete
Measures tend to be continuous
How can a measure be discrete? (turned from a continuous measure) - CORRECT
ANSWER - Create buckets (good/bad buckets) by adding a if/else calculated field
How does Tableau aggregate data? - CORRECT ANSWER - Tableau aggregates measures
at the current level of detail (LOD)
What are the various aggregation functions? - CORRECT ANSWER - - Sum (default)
- Average
- Median
- Min
- Max
- Count
- CountD (distinct count)
- Standard Deviation & Variance
How do you change the default aggregation? - CORRECT ANSWER - Go to left sidebar -
-> right click "Default Properties" --> click "Aggregation" --> change function
Granularity - CORRECT ANSWER - The level of detail in the model. Breaking our data
points into smaller pieces
How do you increase and decrease granularity? - CORRECT ANSWER - Increase
granularity by dropping fields into the color, shape, and size Marks card boxes
Decrease granularity by removing fields from the Marks card
