Unsorted Flashcards

Sourced from around the Web (297 cards)

1
Q

What are the export options for Tableau?

A

.png, .csv, .xlxs

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

What is the formula to concatenate two strings in Tableau?

A

[String One]+’’+[String 2]

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

Example of Fixed LOD with dimension specified

A

{FIXED [Category] : Sum [Sales]} this means go get all the categories and store their sum with you

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

For a horizontal bar chart what is needed?

A

0 or more dimensions or 1 or more measures

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

A forecast requires

A

1 date dimension and 1 measure

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

Area charts require

A

1 date, 0 or more dimensions, 1 or more measures

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

Dual line charts require

A

1 date, 0 or more dimensions, and 2 measures

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

Dual combination graphs (bar & line) require

A

1 date, 0 or more measures, and 2 measures

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

Gant Chart requires

A

1 date, 1 or more dimensions, and 0 to 2 measures

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

For a stacked bar chart what is needed?

A

1 or more dimensions or 1 or more measures

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

What are the steps to create a context filter

A

1) create a set 2) in the filters box click the set and add to context

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

In tableau cloud, what is the minimum frequency at which you can schedule a data extract refresh?

A

15 minutes

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

What is a choropleth map?

A

A choropleth map is a thematic map that visualizes geographical areas or regions with clearly divided colors, shades, or patterns in relation to a given variable.

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

For a trend line to be in the view, both axes must contain

A

a field that can be interpreted as a number

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

What are the two things that tableau has assigned in a data set?

A

a role and type

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

A story is

A

a sequence of visualizations that work together to convey information

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

A story point is

A

a single worksheet or dashboard

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

Tree Maps

A

a tree map breaks the whole into its parts using a quantitative measure to determine the size of each square

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

Measure Values contains

A

all the measures in your data collected into a single field with continuous values

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

Tableau will create what based on green pills?

A

an axis

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

What is needed to create a pie chart?

A

at least 1 dimension or 1 or 2 measures

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

Reference lines

A

can be added at a constant or computed value on the axis

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

Story navigation types

A

caption boxes, numberrs, arrows only or dotts

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

To make a map go from a symbol map to a filled map you

A

change the mark type to map

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
What are examples of drag and drop analytics from the analytics pane
clusters, trend lines, reference lines, reference bands, or distribution bands
26
What do clusters do
color dots on scatter plots based on certain variables
27
Filled maps make use of blank and not blank
color not size
28
What are the default properties
comment, color, shape, and sort
29
Fixed LOD
computes a value using the specified dimensions without reference to the dimension in the view meaning it doesn't care about the visual LOD it will just compute a value from the data source based directly on your instructions
30
Include LOD
computes values using the specified dimensions in addition to whatever dimensions are in the view
31
What type of filter do you use to get sub categories with sales overr 100k?
Condition Filter
32
All fields must be aggregate or constant when using table calculation functions. What should go with the RANK formula?
Condition Filter
33
Green pills are
continuous
34
What are the steps to creating a Quick LOD expression?
Control click (or command click on a mac) the measure you want to aggregate and drag it to the dimension you want to aggregate one
35
PROPER
converts a text string to proper title casing by capitalizing the initial letter of each word while lower casing all other letters
36
UPPER & LOWER
converts text string to all upper case or lower case letters
37
How do you create a table showing the number of orders by category?
Create a function using the COUNT([Order ID]) and then drag the function to the text shelf then category to the row shelf
38
You have a dataset with a date field that contains dates in the "MM/DD/YYYY' format but you want to create a view that shows the sum of sales by quarter what function would you use to accomplish this?
datetrunc()
39
Measures are aggregated by
default
40
What does this data story type shape mean in Tableau?
Describes how something your audience cares about relates to the bigger picture
41
What affects the level of detail in a view?
Dimension
42
You can only create aliases for
dimensions
43
Dimensions show as blank data and appear as what color?
dimensions show as qualitative data and show as blue pills
44
Blue pills are
discrete
45
Aliases can only be applied to ...
discrete dimensions and not continuous dimensions
46
How to get the top 5 in a data set with sub categories that changes month over month?
do a nested sort on the sub category and then create a calculated field on the larger category using the rank formula
47
How to convert an ordinary bar chart to a stacked bar chart?
drag a dimension to color on the marks card
48
How to create hierarchies
drag and drop pills on top of each other
49
When you create a new set using only one dimension they are
dynamic by default which means if you make a change in the data set it will automatically transfer over to tableau
50
Fixed LOD can be used for
either dimensions or measures
51
Exclude LOD
explicitly remove dimensions from the expression that is they subtract dimension from the iew level of detail
52
What are valid worksheet actions in tableau?
filter, highlight, go to URL
53
Valid dashboard sizes
fixed, range, and automatic
54
what does the following formula mean: {INCLUDE [Product]: Sum ([Sales])}
for every dimension in the view AND product compute the sum of sales
55
what does the following formula mean: {EXCLUDE [Sub Category]: Sum ([Sales])}
for every dimension in the view EXCEPT sub category compute the sum of sales
56
What does the datepart() function do?
gives the date as an integer
57
What does the datename() function do?
gives the name of the specified input (ex: june, 23)
58
To add a trend line
go to analysis > trendlines > add trendlines
59
Pills turn what color when added to a context filter
grey
60
Sets differ from groups because
groups are fixed and sets are not
61
Groups can be made x or by using x
groups can be made manually or by using find members
62
Tableau will create what based on blue pills?
headers
63
What is the equation to replace missing values with 0's in the table?
IFNULL(LOOKUP(SUM[Sales],0),0)
64
Context filters function to
improve performance or create a dependent numerical or top N filter
65
Sets create
in groups and out groups
66
Level of detail exprressions
include, exclude, fixed
67
You cannot make reference lines, bands, and distributions for
instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
68
Trend lines
instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
69
A regular trend line (linear)
instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
70
A logarithmic trend line
instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
71
Exponential Trend LIne
instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
72
Sets have what icon
interlocking circles
73
Nested Sort
lets you select the field value used to determine the sort order & the field doesn't need to be used in the visualization. Nested sort is different from a field sort because a nested sort considers each pane independently and sorts the rows per pane.
74
Field sort
lets you specify the field value used to determine the sort order. The field doesn't need to be used the visualization.
75
Sets can be made by using what three options
manually, conditions, or top
76
Include and exclude must always be
measures
77
Measures show blank data and appear as what color?
measures show as numeric/quantitative data (usually) and appear as green this is because they can be aggregated (ex: summed)
78
What matters in hierarchies
order
79
Groups have what icon
paper clip
80
exclude LOD expressions are useful for
percent of total or difference from overall average scenarios and are comparable to totals and reference lines
81
What is the function to get the median([Sales])?
Percentile([Sales],.5)
82
How to make a dual axis
requires two dimensions on the second measure pill use the drop down to select dual axis
83
LEFT & RIGHT formulas
return the specified number of characters from either the left or the right
84
SPLIT
returns a substring from a string as determined by a delimiter
85
What does datetrunc() do?
returns a truncated date of the same data type
86
LEN fomula
returns number of characters in given string
87
MID
returns the characters from the middle of a text string given a starting position and length. The first character in the string position is 1. if the length is not inlcuded all characters to the end of the string are returned. If the length is included up to that many characters are returned.
88
What does the maekdate() function do?
returns the date value that corresponds to a specified integer for a year month and day
89
What does the window formula do?
Returns the sample variance of the expression within the window
90
STARTSWITH/ ENDSWITH
returns true if a string starts with or ends with a specific set of charaters
91
CONTAINS
returns true if string contains the substring
92
List the quick table calcs
running total, difference, percent difference, percent of total, rank, percentile, moving average
93
How to add quick table calculatioons
select the drop down menu on a measure and select quick table calculations
94
Reference bands
shade an area behind the marks in the view between two constant or computed values on the axis
95
Box and Whisker Plot
shows the range of values along with the average and interquartile ranges
96
Reference distributions
similar to reference bands but are more powerful. instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
97
Histogram
split a single continuous measure into bins or groups to analyze distribution
98
How to create a bar in bar chart
start with a normal bar chart and then drag the second measure onto the existing axis until you see two horizontal lines then drag measure names from the rows shelf onto color and size in the marks card next go to analysis and turn the stack marks off
99
What is a .tsv file?
Tab separated value
100
What are the output file types in tableau prep?
tableau data extract, Microsoft excel, CSV
101
Bullet Graph
take a bar chart and adds additional elements to create a compact way to analyze performance against a goal or threshold - or comparing the performance of a primary measure against a secondary measure
102
What is the mark type for a cross tab map
text
103
What section do you use to open a .tsv file in Tableau Prep Builder?
Text file
104
P value means
the data is significant or unsignificant
105
Measure names contains
the names of all the measures in your data collected into a single field with discrete values
106
The shaded portion of the graph is called
the prediction or confidence interval
107
R value means
the ratio of the models unexplained variance to the total variance in the data
108
if tableau prep builder samples the data in the input step what occurs?
the sampled data is used in the flow but the entire data set is used to create the output
109
You can click on forecast in the marks card and see
the upper prediction interval and lower prediction interval and add to tool tip
110
If you go to analytics and describe forecast
there will be a summary and model which will tell you how the forecast is calculated
111
How to get the difference between two dates?
to do this used a fixed function to create a max an min of a date and then use the date diff function
112
Bar Chart
used to compare data across categories you can have horizontal bar charts, stacked bar charts, or side by side bar charts
113
Scatter plot
used to explore the correlation between two measures with independent axes and often combined with trendlines
114
Pie Chart
used to show how a few dimensions compare to one another and the whole (requires 1 or more dimensions or 1 or 2 measures)
115
Line Chart
used to show trends across time intervals and multiple lines can be used to compare categories within a dimension
116
Packed Bubble Chart
uses size as the primary visual element to allow for comparison between categories
117
What is the formula to get the moving average of profit for 5 days
WINDOW_AVG(SUM([Profit]),-4,0)
118
What can you publish to tableau server?
worksheets, workbooks, and data sources
119
Can you filter from headers
yes by using the drop down or the exclude and keep only buttons
120
Can you filter directly from the view
yes by using the keep only, exclude, group, or set buttons that appear when you hover over the visual
121
P value
· 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.
122
Discrete
(blue) - finite set of values -> year, category, country ADD A NEW HEADER (normally dimensions)
123
Animations
add transitions using filters, filter actions, calculations and more
124
Forecasting
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
125
Hierarchies
allow users to define custom levels of detail and create drill-down functionality. Live in workbook as metadata, not back to original source.
126
Stories
allow you to create visual sequences to build narratives, add context, and bring data to life - think of it as a mix between tableau and PowerPoint
127
Grouping
allows you to combine related members of a given field. Commonly used to roll up data to a different level of detail. Grouping is a static function and wont change.
128
Unions
appends two or more tables to form a new combined table (good for data with the same number of rows and data types)
129
Extracts
are saved subsets of data that improve performance and take advantage of Tableau functionality, allowing you to refresh the data on a regular basis.
130
Geographic fields
assign a geographic role. Most will auto assign. All are string type data except for latitude and longitude
131
Tableau Prep - Flow pane
at the top and shows a visual representation of each step in the data prep process
132
Alias
can only be created for a dimension
133
Aggregation
Combining and summarizing data into a single representative value. Both dimensions and measures can be aggregated
134
Table Calculations
Computations that are applied to the values within a view, and computed in Tableau. Sheet based calculations that only evaluate within a given visualization. You cannot add table calculations from the analytics pane
135
LOD element - exclude
compute at a coarse grain or higher than the view (impacted by filters/dimensions in the view)
136
LOD element - fixed
compute at a course or fine grain. They are not impacted by filters/dimensions in the view
137
LOD element - include
compute at a finer grain and are lower than the view (impacted by filters/dimensions in the view)
138
COUNTD
converts a dimension into a measure
139
relationships
create contextually appropriate joins (displayed as flexible noodles between logical tables)
140
User roles are
creator, explorer, and viewer
141
Sets
custom fields that define a subset of data based on some conditions - they can be constant or computed, and can be made more dynamic using set actions.
142
Tableau Server
customer-managed sharing platform where creators, explorers and viewers can create, interact, and share content
143
Tableau Prep
desktop based visual ETL program. It enables developers to connect to data, create workflows, automate jobs and share flows with others.
144
Logical
determines if a conditional statement is true or false
145
Context Filters
dimension filters that supersede their normal order of operations. COMMON USE CASE: Dependent Top N Filters.
146
Tableau Prep - Data grid
displays a preview of the rows and columns of the data source. Any changes that are made in to profile pane will automatically show in the data grid
147
Tableau Prep - Profile pane
displays a summary of each field in the data sample
148
R-squared
explains how the variance of one variable explains the variance of another. R2 ranges from 0-1, and closer to 1 is better.
149
Analytics Pane
Find the options to add a: Trend Line, Forecast, Custom Reference Line, Reference Band, Distribution Band, Box Plot
150
Dashboard sizes
fixed, automatic, or range
151
physical layer
for creating unions and joins between tables (joins tables together)
152
full vs. incremental refresh
full refresh replaces all of the contents in the extract. An incremental refresh only adds rows that are new since the previous refresh.
153
Regression Models
In tableau they are represented in the form of trend lines. It is a statistical modeling technique used to estimate trends/relationships between variables.
154
Continuous
infinite range of values -> age, temperature, profit -> ADD A NEW AXIS (normally measures)
155
Highlighting
interactive tool to draw attention to specific data points in a visual
156
Census data
is already built in to tableaus data layer
157
Tableau Prep - Connections Pane
is on the left side and it's the space where you connect to your data sources
158
View Toolbar
map workspace feature gives users the ability to pan and zoom
159
Joins
merges multiple tables based on a clause - this creates a new fixed table
160
Dimension calculations
min/max (a/z), count, distinct count
161
Scatter plots
Multi-axis charts. Require 2 measures and 0 dimensions.
162
Field type
number, date, sting, Boolean or geographic role
163
Dimensions
qualitative (used to categorize, segment, and filter) eg names and dates (normally discrete)
164
Measures
quantitative (can be counted or aggregated) eg $, ratios, or quantities (normally continuous)
165
Histogram
Require 1 measure and 0 dimensions
166
Heatmap
Require 1 measure and 1 or more dimensions
167
Tree maps
Require 1 or 2 measures and 1 or more dimensions
168
Bullet Graphs
Require 2 measures and 1 or more dimensions
169
Aggregate
rolls up the level of granularity on visible dimensions (used to reduce data size) **impacts the way your calculations function
170
Live Connection
sends queries to the database/flat file and updates the view depending on the results
171
sets vs groups
Sets are different than groups because they put the data into buckets. Groups are constant, but sets can be computed
172
zip codes
should be coded as strings to avoid map errors
173
Linear
shows the relationship between variables (either increasing or decreasing)
174
Measure calculations
sum, average, median, count, Min/max, Stand. Dev., variance
175
Tableau Online
Tableau Prep
176
logical layer
the canvas for creating relationships between tables
177
Blending
the canvas for creating relationships between tables
178
Published Data Source
the data source can be either a live connection or an extract
179
Exponential
the rate of change rises at increasingly higher rates (positive only)
180
Geographic Fields and Spatial Data Files
The two primary forms of geospatial data
181
Special data fields
these use geometry fields. This is usually a special .shp file. When dropping a Geometry field, everything will display as one mark.
182
LOD Expressions
type of calculated field leverages computations that support aggregation at dimensionalities other than the view-level
183
Specific and Wildcard
types of unions that are available in the physical layer
184
Logarithmic
When a trend increases then levels off (only positive values)
185
aggregation mix error
when aggregate and non-aggregate fields are used in a calculation
186
Power
When the dependent variable (y) changes at a predetermined rate
187
Polynomial
when variables have a fluctuating relationship (revenue over time)
188
Parameters
workbook variables such as number, string, or date which can replace a constant value in a calculation, filter or reference line
189
Flat files
xlsx, csv, pdf, tdsx --.TIFF files are not accessible via tableau desktop data collection window
190
What can be selected to change grouping or aggregation logic in an aggregate step?
Card Headers
191
What feature is used to combine multiple axis in a sheet?
Dual Axis
192
What file format do Tableau Desktop proprietary data files come out as?
Hyper files
193
What needs to be selected on a dashboard before creating an alert?
An axis
194
What type of source can leverage a refresh schedule on Tableau Server?
Extracts
195
When publishing a workbook to server, which menu allows you to embed authentication to data?
Data Sources
196
Where can you union 10+ tables at once in Tableau Prep?
Input Step
197
Which filter option in Tableau Prep must use a boolean calculation to work?
Calculation Filter
198
Which part of the Tableau Prep workspace is defined as "A visual representation of each operation or step in the data preparation process"?
Flow pane
199
Which source can be used in Tableau Prep if you don't have local credentials to a database?
Published Data Sources
200
Which step transposes rows to columns?
Pivot
201
Which subscription option stops a subscription if no data is found?
Don't send if view is empty
202
Which tool helps enable Tableau Online to refresh flat files and other local sources?
Tableau Bridge
203
Which transformation function in the data source interface works like Excel's text-to-columns function?
Split
204
What is the difference between a data source and a connection?
-A Data Connection represents the database server information required to log in (connect) to a database, and it also contains the relation for the underlying data.
205
What is the wildcard tab for when filtering on dimensions?
(Tableau Desktop only): Use the Wildcard tab to define a pattern to filter on. For example, when filtering on email addresses you might want to only include emails from a specific domain. You can define a wildcard filter that ends with "@gmail.com" to only include Google email addresses.
206
A good reason to use a bullet graph:1. Analyzing the trend for a time period2. Comparing the actual against the target sales3. Adding data to bins and calculating count measure4. Displaying the sales growth for a particular year
2. comparing the actual against the target sales
207
______ is a relationship of data from different databases or text tables based on a COMMON DIMENSION. Behaves like a left join.
A Blend
208
______ is a relationship across two different databases or text tables based on a common field.
A cross database join
209
The icon associated with the field that has been grouped is a ______.
a paper clip
210
_____ appends rows fro different tables with the same column names.
a union
211
what default properties can you change for fields?
aggregation, comments, number formatting, color, shape, and totals (based on the type of field)
212
Level of Detail (LOD) Expression
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.
213
Which of the following best describes the fundamental end to end workflow for providing insights from data using Tableau ?A - Connect to, Clean & Share the DataB - Connect to, Build Views to Analyse & Share the DataC - Connect to, Build Views to Analyse & Certify the DataD - Connect to, Certify & Share the Data
B - The Tableau Desktop workflow consists of connecting to, analyzing, and sharing your data
214
What type of chart is useful when wanting to evaluate two measures without stacking marks or expanding the axis?
bar in bar
215
Which of the following is not a Trend Line model1. Linear2. Exponential3. Binomial4. Log
binomial
216
If you want to create a histogram, what tool in tableau may be helpful?
Bins
217
what data combinations method should you Use when combining data from different levels of detail.
Blend
218
When using multiple data sources, the primary connection shows up as:
blue
219
A ________ graph is a variation of a bar chart.
bullet
220
For creating variable size bins we use __________.
Calculated Fields
221
how do you get the the "Performance Recorder" in tableau desktop?
Click the Help menu, and then select Settings and Performance > Stop Performance Recording.
222
What does the table calculation 'Pane ( across then down)' do ?
Computes across an entire pane and then down the pane.
223
What does the table calculation 'Table (across)' do ?
Computes across the length of the table and restarts after every partition
224
What does the table calculation 'Table (across then down)' do ?
Computes across the length of the table, and then down the length of the table.
225
What does the table calculation 'Pane ( down)' do ?
Computes down an entire pane (NOT the whole of the table)
226
What does the table calculation 'Pane ( down then across)' do ?
Computes down an entire pane and then across the pane
227
What does the table calculation 'Table (down)' do ?
Computes down the length of the table and restarts after every partition.
228
What does the table calculation 'Table (down then across)' do?
Computes down the length of the table, and then across the length of the table.
229
What does the table calculation 'Specific Dimension' do ?
Computes only within the dimensions you specify.
230
Are reference lines added to a discrete or continuous axis in a view?
continuous
231
What can you do if you want to rename how members of a dimension appear in a visual?
Create aliases
232
Data blends can be created by using data sources with common fields or by establishing_____________ relationships.
custom
233
Where are data connections added in the data pane?
Data connections are added from the Add link in the Left pane.
234
What is the difference in functionality between tableau Desktop and Tableau Online when it comes to configuring reference lines and reference bands?
Desktop has an option for Box Plot, web version does not
235
What do relationships do?
Establish the potential for joins between two tables based on related fields. Does not merge data together
236
Whiskers of a box plot typically show the _________ of the data. However, they can show 1.5x the _________ range.
extremes, interquartile
237
T/F A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.
False - A sheet can be used within a story directly.
238
T/F there are 3 different model types for trend lines.
False - there are 4 models1. Linear2. Log3. Exponent4. Poly/degree
239
T/F Calculated fields are processed locally by tableau
False, calculated fields are processed in the database
240
T/F Context filters do not use temp tables to reduce query size.
False, context filters use temp tables to reduce query size
241
T/F In the formula editor, field names are represented with [Purple Text].
False, field names appear in [orange text] and parameters appear in [purple text]
242
T/F Sets cannot be used as a filter.
false, sets can be used as filters
243
T/F To add a trend line to a view, only the x-axis has to be a numeric value (also includes date/time fields)
False. Both axes must contain a field that can be interpreted as a number.
244
Where in tableau can you change the data type of a field?
In the data source page as well as the the data pane in a sheet
245
Where do you create relationships between data sources?
in the logical layer of the data source. This is the default view of the canvas that you see in the Data Source page.
246
When updating a data extract, once can use an _______ extract, which only updates new rows since the previous extract.
incremental
247
How do you identify a continuous field in Tableau?
It is identified by a green pill in a visualization
248
what data combination method should you Use when you want to add more columns of data across the same row structure.
Join
249
Use a ________ when you want to analyze data that exists in 2 separate tables within the same database
join
250
Data blends use a ______ join to incorporate the secondary data source with the primary.
left
251
What types of trendlines can you add in tableau?
linear, logarithmic, exponential, and polynomial
252
Are logical tables or physical tables the default for extracts?
Logical Tables
253
Area code boundaries, streets, and place names are all what kind of map feature?
map layers
254
The boxes of a box plot show the _____ ____% of the data
middle 50, or middle two quartiles of data
255
What does the box in a box plot represent?
middle 50% of data, the 2 middle quartiles of the data distribution
256
Where are new data sources added in the data pane?
New data sources can be created from the Data menu or the drop down menu from the icon next to the Data Source's name
257
can you define relationships between published data sources?
NO
258
can you define relationships based on geographic fields?
NO
259
what does an incremental refresh of an extract do?
only includes new rows since the previous refresh.
260
why may it be useful to use parameters when creating calculations?
Rather than manually editing the calculation (and all dependent calculations), you can use a parameter. Then when you want to change the value, you open the parameter control, change the value, and all calculations that use that parameter are updated.
261
what data combination method should you Use when combining data from different levels of detail
relationship
262
relationships are to ______ tables as Joins are to ________tables
relationships are to logical tables and joins are to physical tables
263
When using a cross-database join, data integration results at the _____ level,
row
264
When making complex changes to filters on a dashboard, which animation type should you use?
Sequential Animations
265
What types of reference lines can you add in tableau?
table, pane, and cell
266
A __________ _______________ _________________ is a user-defined data subset from a data source.
tableau data extract
267
what are partitioning fields?
The dimensions that define how to group the calculation (the scope of data it is performed on)
268
How do dynamic sets work?
The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.
269
how do fixed sets work?
The members of a fixed set do not change, even if the underlying data changes. A fixed set can be based on a single dimension or multiple dimensions.
270
How do you relate tables across different databases?
they must be added as data connections within the same data source, not a new data source.
271
T/F The Highlighting action can be disabled for the entire workbook.
True - From the toolbar the Highlighting action can be disabled for the entire workbook.
272
what data combination should you Use when you want to add more rows of data with the same column structure
Union
273
What is the condition tab for when filtering on dimensions?
Use the Condition tab in the Filter dialog box to define rules to filter by. For example, in a view showing the average Unit Price for a collection of products, you may want to only show the Products that have an average unit price that is greater than or equal to $25. You can use the built-in controls to write a condition or you can write a custom formula.
274
what are some possible downfalls or should be considerations when using physical tables?
When using the Physical Tables option, other options to help reduce the data in your extract, like extract filters, aggregation, Top N and Sampling are disabled
275
if you want to rename a dimension what can you do?
You can not rename the original dimension; but you can create a duplicate and rename that to achieve this
276
3 ways you can sort on a visualization in tableau
you can sort from the header, axis, or field label
277
T/F When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted field.
FALSE
278
T/F Store procedures are available for multi-connection data sources.
FALSE
279
T/F Data from different databases can be unioned?
FALSE
280
T/F A Reference Distribution plot cannot be along a continuous axis.
FALSE
281
T/F: Advanced Settings aren't compatible with Filters in extracts
TRUE
282
T/F Context Filters are executed after data source filters.
TRUE
283
T/F An aggregated calculation can be multiplied by a non-aggregated constant
TRUE
284
T/F A TDE file contains both modified and original data attributes?
TRUE
285
T/F Calculated fields, sets, and or parameters are contained in a TDE file?
TRUE
286
T/F Data from different sources cannot be used in a pivot?
TRUE
287
T/F Sets are fields created on existing dimensions.
TRUE
288
T/F Combined sets allow you to compare multiple sets to one another to determine intersections or differences across the sets.
TRUE
289
T/F Context filters improve performance when the data source is large.
TRUE
290
T/F Table calculations are performed locally by tableau.
TRUE
291
T/F You will need to use an aggregated when data from multiple dimensions doesn't have a consistent level of detail.
TRUE
292
T/F when using Min() or MAX() if either argument is null then the function returns null.
TRUE
293
T/F LOD calcs use data source level queries.
TRUE
294
T/F Forecasting is not supported for multidimensional data sources.
TRUE
295
Create a calculation that combines Month(formatted as Date in data pane) and Year (formatted as an integer in data pane) into a date field. Set the date to be the first of the month for the specified date and year so that for example “May” and “2018” becomes May 1st, 2018.
MAKEDATE([Year],int([Month]),1)
296
What is the easiest way to make a Top N filter?
Make a Set off of the field
297