Tableau Data Analyst Exam Questions
with Complete Answers
Unions - Answer-appends two or more tables to form a new combined table (good
for data with the same number of rows and data types)
Blending - Answer-visualizes data from separate sources within the same view via
blended fields (the result is similar to a left join)
Specific and Wildcard - Answer-types of unions that are available in the physical
layer
Dimensions - Answer-qualitative (used to categorize, segment, and filter) eg names
and dates (normally discrete)
Measures - Answer-quantitative (can be counted or aggregated) eg $, ratios, or
quantities (normally continuous)
Discrete - Answer-(blue) - finite set of values -> year, category, country ADD A NEW
HEADER (normally dimensions)
Continuous - Answer-infinite range of values -> age, temperature, profit -> ADD A
NEW AXIS (normally measures)
Bar Charts
Line charts
Histogram - Answer-Require 1 measure and 0 dimensions
Scatter plots
Multi-axis charts - Answer-Require 2 measures and 0 dimensions
Crosstabs
Highlight tables
Heatmap - Answer-Require 1 measure and 1 or more dimensions
Tree maps - Answer-Require 1 or 2 measures and 1 or more dimensions
Bullet Graphs - Answer-Require 2 measures and 1 or more dimensions
Geographic Fields and Spatial Data Files - Answer-The two primary forms of
geospatial data
View Toolbar - Answer-map workspace feature gives users the ability to pan and
zoom
Census data - Answer-is already built in to tableaus data layer
, Geographic fields - Answer-assign a geographic role. Most will auto assign. All are
string type data except for latitude and longitude
Special data fields - Answer-these use geometry fields. This is usually a special .shp
file. When dropping a Geometry field, everything will display as one mark.
zip codes - Answer-should be coded as strings to avoid map errors
Analytics Pane - Answer-Find the options to add a: Trend Line, Forecast, Custom
Reference Line, Reference Band, Distribution Band, Box Plot
Regression Models - Answer-In tableau they are represented in the form of trend
lines
It is a statistical modeling technique used to estimate trends/relationships between
variables
Logarithmic - Answer-When a trend increases then levels off (only positive values)
Linear - Answer-shows the relationship between variables (either increasing or
decreasing)
Exponential - Answer-the rate of change rises at increasingly higher rates (positive
only)
Polynomial - Answer-when variables have a fluctuating relationship (revenue over
time)
Power - Answer-When the dependent variable (y) changes at a predetermined rate
R-squared - Answer-explains how the variance of one variable explains the variance
of another. R2 ranges from 0-1, and closer to 1 is better.
P value - Answer-· is the probability of obtaining results as extreme as observed
results. P value ranges from 0-1, and a value of <.05 is good. It means the trendline
is an accurate predictor of future trends.
Forecasting - Answer-algorithms evaluate patterns in historical data to a project
potential future data point. -> drag and drop forecast tools from the analytics pane ->
choose forecast length
order of operations tableau uses to calculate - Answer-1. Extract Filters
2. Data Source Filters
3. Context Filters
4. Dimension Filters
5. Measure Filters
6. Table Calc Filter
Calculated Fields can - Answer-Segment data, convert field types, aggregate data,
filter results, calculate new metrics
with Complete Answers
Unions - Answer-appends two or more tables to form a new combined table (good
for data with the same number of rows and data types)
Blending - Answer-visualizes data from separate sources within the same view via
blended fields (the result is similar to a left join)
Specific and Wildcard - Answer-types of unions that are available in the physical
layer
Dimensions - Answer-qualitative (used to categorize, segment, and filter) eg names
and dates (normally discrete)
Measures - Answer-quantitative (can be counted or aggregated) eg $, ratios, or
quantities (normally continuous)
Discrete - Answer-(blue) - finite set of values -> year, category, country ADD A NEW
HEADER (normally dimensions)
Continuous - Answer-infinite range of values -> age, temperature, profit -> ADD A
NEW AXIS (normally measures)
Bar Charts
Line charts
Histogram - Answer-Require 1 measure and 0 dimensions
Scatter plots
Multi-axis charts - Answer-Require 2 measures and 0 dimensions
Crosstabs
Highlight tables
Heatmap - Answer-Require 1 measure and 1 or more dimensions
Tree maps - Answer-Require 1 or 2 measures and 1 or more dimensions
Bullet Graphs - Answer-Require 2 measures and 1 or more dimensions
Geographic Fields and Spatial Data Files - Answer-The two primary forms of
geospatial data
View Toolbar - Answer-map workspace feature gives users the ability to pan and
zoom
Census data - Answer-is already built in to tableaus data layer
, Geographic fields - Answer-assign a geographic role. Most will auto assign. All are
string type data except for latitude and longitude
Special data fields - Answer-these use geometry fields. This is usually a special .shp
file. When dropping a Geometry field, everything will display as one mark.
zip codes - Answer-should be coded as strings to avoid map errors
Analytics Pane - Answer-Find the options to add a: Trend Line, Forecast, Custom
Reference Line, Reference Band, Distribution Band, Box Plot
Regression Models - Answer-In tableau they are represented in the form of trend
lines
It is a statistical modeling technique used to estimate trends/relationships between
variables
Logarithmic - Answer-When a trend increases then levels off (only positive values)
Linear - Answer-shows the relationship between variables (either increasing or
decreasing)
Exponential - Answer-the rate of change rises at increasingly higher rates (positive
only)
Polynomial - Answer-when variables have a fluctuating relationship (revenue over
time)
Power - Answer-When the dependent variable (y) changes at a predetermined rate
R-squared - Answer-explains how the variance of one variable explains the variance
of another. R2 ranges from 0-1, and closer to 1 is better.
P value - Answer-· is the probability of obtaining results as extreme as observed
results. P value ranges from 0-1, and a value of <.05 is good. It means the trendline
is an accurate predictor of future trends.
Forecasting - Answer-algorithms evaluate patterns in historical data to a project
potential future data point. -> drag and drop forecast tools from the analytics pane ->
choose forecast length
order of operations tableau uses to calculate - Answer-1. Extract Filters
2. Data Source Filters
3. Context Filters
4. Dimension Filters
5. Measure Filters
6. Table Calc Filter
Calculated Fields can - Answer-Segment data, convert field types, aggregate data,
filter results, calculate new metrics
