TABLEAU DESKTOP SPECIALIST
CERTIFICATION QUESTIONS &
ANSWERS!!
Automatic folder created by Tableau in the Documents folder. - ANSWERMy
Tableau Repository
Each column in a dataset has... - ANSWERa Role and a Type
Role - ANSWEREither a dimension (qualitative) or a measure (numeric). Each
column in a dataset has a Role.
Type - ANSWERData type (number (decimal), number (whole), date & time, date,
string, boolean, geographic). Each column in a dataset has a Type.
Continuous - ANSWER- Green
- Creates Axes
- Usually Measures
Discrete - ANSWER- Blue
- Creates Headers
- Usually Dimensions
Auto-generated Fields - ANSWER- Measure Names
- Measure Values
- Latitude
- Longitude
- Number of Records
Connections - ANSWER- Live (default)
- Extract (saved subset)
Live Connection - ANSWERdefault
Blends - ANSWER- Combines data from multiple sources
- Brings in additional info from a secondary data source and displays it with data
from the primary data source directly in the view
- An asterik (*) in a view with blended data indicates multiple values
- Never truly combines data
- Results are aggregated to the appropriate level, and the results are presented
visually together in the view
- Aggregates, and then combines data
- Always LEFT join
Extract Connection - ANSWER- Saved subset
- Can use filters/et.c to get a subset of a large dataset
- Resides in Tableau
, - Creats a .hyper file
Advantages:
- Supports large data sets
- Help improve performance
- Support additional functionality (ex. allows you to compute Count Distinct)
- Provide offline access to data
- Full refresh or incremental refresh (only rows that are new since previous refresh)
.tds - ANSWER- Data Source
- Info necessary to connect to the data, but no visualizations
- Data source type
- Connection information
- Groups, sets, calculated fields, and bins
- Default file properties (formats, aggregation, and sort order)
Use Data Source (.tds) if everyone who will use the data source has access to the
underlying file or database
.tdsx - ANSWER- Packaged Data Source
- Contains all info in the data source (.tds) file, as well as a copy of any local file-
based data or extracts
- A single zipped file
Use Packaged Data Source (.tdsx) if you want to share your data with people who
do no thave access to the underlying data
Data Source File Types - ANSWER- .tds (Data Sorce)
- .tdsx (Packaged Data Source)
.twb - ANSWER- Workbook
- Workbooks hold one or more worksheets, plus zero ro more dashboards and
stories
- Visualizations, but no copy of the data
.twbx - ANSWER- Packaged Workbook
- A single zip file that contains a workbook along with anly supporting local file data
and background images
- Includes data and visualizations
Best for sharing with those who don't have access to the data
Workbook Data Types - ANSWER- .twb (Workbook)
- .twbx (Packaged Workbook)
Joins - ANSWER- A method of combining data based on common fields
- Increases number of columns
- Join a max of 32 tables
- Can cause data loss or duplication
- Combines data, and then aggregates
CERTIFICATION QUESTIONS &
ANSWERS!!
Automatic folder created by Tableau in the Documents folder. - ANSWERMy
Tableau Repository
Each column in a dataset has... - ANSWERa Role and a Type
Role - ANSWEREither a dimension (qualitative) or a measure (numeric). Each
column in a dataset has a Role.
Type - ANSWERData type (number (decimal), number (whole), date & time, date,
string, boolean, geographic). Each column in a dataset has a Type.
Continuous - ANSWER- Green
- Creates Axes
- Usually Measures
Discrete - ANSWER- Blue
- Creates Headers
- Usually Dimensions
Auto-generated Fields - ANSWER- Measure Names
- Measure Values
- Latitude
- Longitude
- Number of Records
Connections - ANSWER- Live (default)
- Extract (saved subset)
Live Connection - ANSWERdefault
Blends - ANSWER- Combines data from multiple sources
- Brings in additional info from a secondary data source and displays it with data
from the primary data source directly in the view
- An asterik (*) in a view with blended data indicates multiple values
- Never truly combines data
- Results are aggregated to the appropriate level, and the results are presented
visually together in the view
- Aggregates, and then combines data
- Always LEFT join
Extract Connection - ANSWER- Saved subset
- Can use filters/et.c to get a subset of a large dataset
- Resides in Tableau
, - Creats a .hyper file
Advantages:
- Supports large data sets
- Help improve performance
- Support additional functionality (ex. allows you to compute Count Distinct)
- Provide offline access to data
- Full refresh or incremental refresh (only rows that are new since previous refresh)
.tds - ANSWER- Data Source
- Info necessary to connect to the data, but no visualizations
- Data source type
- Connection information
- Groups, sets, calculated fields, and bins
- Default file properties (formats, aggregation, and sort order)
Use Data Source (.tds) if everyone who will use the data source has access to the
underlying file or database
.tdsx - ANSWER- Packaged Data Source
- Contains all info in the data source (.tds) file, as well as a copy of any local file-
based data or extracts
- A single zipped file
Use Packaged Data Source (.tdsx) if you want to share your data with people who
do no thave access to the underlying data
Data Source File Types - ANSWER- .tds (Data Sorce)
- .tdsx (Packaged Data Source)
.twb - ANSWER- Workbook
- Workbooks hold one or more worksheets, plus zero ro more dashboards and
stories
- Visualizations, but no copy of the data
.twbx - ANSWER- Packaged Workbook
- A single zip file that contains a workbook along with anly supporting local file data
and background images
- Includes data and visualizations
Best for sharing with those who don't have access to the data
Workbook Data Types - ANSWER- .twb (Workbook)
- .twbx (Packaged Workbook)
Joins - ANSWER- A method of combining data based on common fields
- Increases number of columns
- Join a max of 32 tables
- Can cause data loss or duplication
- Combines data, and then aggregates
