Brainscape's Knowledge GenomeTM

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


See full index

Tableau Data Analyst Certification > Unsorted Flashcards > Flashcards

Unsorted Flashcards

Sourced from around the Web

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
Q

What are examples of drag and drop analytics from the analytics pane

A

clusters, trend lines, reference lines, reference bands, or distribution bands

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

What do clusters do

A

color dots on scatter plots based on certain variables

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

Filled maps make use of blank and not blank

A

color not size

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

What are the default properties

A

comment, color, shape, and sort

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

Fixed LOD

A

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

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

Include LOD

A

computes values using the specified dimensions in addition to whatever dimensions are in the view

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

What type of filter do you use to get sub categories with sales overr 100k?

A

Condition Filter

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

All fields must be aggregate or constant when using table calculation functions. What should go with the RANK formula?

A

Condition Filter

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

Green pills are

A

continuous

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

What are the steps to creating a Quick LOD expression?

A

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

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

PROPER

A

converts a text string to proper title casing by capitalizing the initial letter of each word while lower casing all other letters

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

UPPER & LOWER

A

converts text string to all upper case or lower case letters

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

How do you create a table showing the number of orders by category?

A

Create a function using the COUNT([Order ID]) and then drag the function to the text shelf then category to the row shelf

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

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?

A

datetrunc()

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

Measures are aggregated by

A

default

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

What does this data story type shape mean in Tableau?

A

Describes how something your audience cares about relates to the bigger picture

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

What affects the level of detail in a view?

A

Dimension

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

You can only create aliases for

A

dimensions

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

Dimensions show as blank data and appear as what color?

A

dimensions show as qualitative data and show as blue pills

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

Blue pills are

A

discrete

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

Aliases can only be applied to …

A

discrete dimensions and not continuous dimensions

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

How to get the top 5 in a data set with sub categories that changes month over month?

A

do a nested sort on the sub category and then create a calculated field on the larger category using the rank formula

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

How to convert an ordinary bar chart to a stacked bar chart?

A

drag a dimension to color on the marks card

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

How to create hierarchies

A

drag and drop pills on top of each other

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

When you create a new set using only one dimension they are

A

dynamic by default which means if you make a change in the data set it will automatically transfer over to tableau

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

Fixed LOD can be used for

A

either dimensions or measures

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

Exclude LOD

A

explicitly remove dimensions from the expression that is they subtract dimension from the iew level of detail

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

What are valid worksheet actions in tableau?

A

filter, highlight, go to URL

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

Valid dashboard sizes

A

fixed, range, and automatic

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

what does the following formula mean: {INCLUDE [Product]: Sum ([Sales])}

A

for every dimension in the view AND product compute the sum of sales

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

what does the following formula mean: {EXCLUDE [Sub Category]: Sum ([Sales])}

A

for every dimension in the view EXCEPT sub category compute the sum of sales

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

What does the datepart() function do?

A

gives the date as an integer

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

What does the datename() function do?

A

gives the name of the specified input (ex: june, 23)

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

To add a trend line

A

go to analysis > trendlines > add trendlines

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

Pills turn what color when added to a context filter

A

grey

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

Sets differ from groups because

A

groups are fixed and sets are not

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

Groups can be made x or by using x

A

groups can be made manually or by using find members

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

Tableau will create what based on blue pills?

A

headers

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

What is the equation to replace missing values with 0’s in the table?

A

IFNULL(LOOKUP(SUM[Sales],0),0)

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

Context filters function to

A

improve performance or create a dependent numerical or top N filter

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

Sets create

A

in groups and out groups

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

Level of detail exprressions

A

include, exclude, fixed

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

You cannot make reference lines, bands, and distributions for

A

instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation

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

Trend lines

A

instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation

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

A regular trend line (linear)

A

instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation

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

A logarithmic trend line

A

instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation

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

Exponential Trend LIne

A

instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation

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

Sets have what icon

A

interlocking circles

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

Nested Sort

A

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.

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

Field sort

A

lets you specify the field value used to determine the sort order. The field doesn’t need to be used the visualization.

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

Sets can be made by using what three options

A

manually, conditions, or top

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

Include and exclude must always be

A

measures

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

Measures show blank data and appear as what color?

A

measures show as numeric/quantitative data (usually) and appear as green this is because they can be aggregated (ex: summed)

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

What matters in hierarchies

A

order

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

Groups have what icon

A

paper clip

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

exclude LOD expressions are useful for

A

percent of total or difference from overall average scenarios and are comparable to totals and reference lines

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

What is the function to get the median([Sales])?

A

Percentile([Sales],.5)

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

How to make a dual axis

A

requires two dimensions on the second measure pill use the drop down to select dual axis

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

LEFT & RIGHT formulas

A

return the specified number of characters from either the left or the right

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

SPLIT

A

returns a substring from a string as determined by a delimiter

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

What does datetrunc() do?

A

returns a truncated date of the same data type

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

LEN fomula

A

returns number of characters in given string

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

MID

A

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.

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

What does the maekdate() function do?

A

returns the date value that corresponds to a specified integer for a year month and day

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

What does the window formula do?

A

Returns the sample variance of the expression within the window

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

STARTSWITH/ ENDSWITH

A

returns true if a string starts with or ends with a specific set of charaters

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

CONTAINS

A

returns true if string contains the substring

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

List the quick table calcs

A

running total, difference, percent difference, percent of total, rank, percentile, moving average

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

How to add quick table calculatioons

A

select the drop down menu on a measure and select quick table calculations

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

Reference bands

A

shade an area behind the marks in the view between two constant or computed values on the axis

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

Box and Whisker Plot

A

shows the range of values along with the average and interquartile ranges

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

Reference distributions

A

similar to reference bands but are more powerful. instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation

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

Histogram

A

split a single continuous measure into bins or groups to analyze distribution

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

How to create a bar in bar chart

A

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

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

What is a .tsv file?

A

Tab separated value

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

What are the output file types in tableau prep?

A

tableau data extract, Microsoft excel, CSV

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

Bullet Graph

A

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

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

What is the mark type for a cross tab map

A

text

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

What section do you use to open a .tsv file in Tableau Prep Builder?

A

Text file

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

P value means

A

the data is significant or unsignificant

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

Measure names contains

A

the names of all the measures in your data collected into a single field with discrete values

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

The shaded portion of the graph is called

A

the prediction or confidence interval

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

R value means

A

the ratio of the models unexplained variance to the total variance in the data

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

if tableau prep builder samples the data in the input step what occurs?

A

the sampled data is used in the flow but the entire data set is used to create the output

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

You can click on forecast in the marks card and see

A

the upper prediction interval and lower prediction interval and add to tool tip

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

If you go to analytics and describe forecast

A

there will be a summary and model which will tell you how the forecast is calculated

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

How to get the difference between two dates?

A

to do this used a fixed function to create a max an min of a date and then use the date diff function

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

Bar Chart

A

used to compare data across categories you can have horizontal bar charts, stacked bar charts, or side by side bar charts

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

Scatter plot

A

used to explore the correlation between two measures with independent axes and often combined with trendlines

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

Pie Chart

A

used to show how a few dimensions compare to one another and the whole (requires 1 or more dimensions or 1 or 2 measures)

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

Line Chart

A

used to show trends across time intervals and multiple lines can be used to compare categories within a dimension

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

Packed Bubble Chart

A

uses size as the primary visual element to allow for comparison between categories

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

What is the formula to get the moving average of profit for 5 days

A

WINDOW_AVG(SUM([Profit]),-4,0)

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

What can you publish to tableau server?

A

worksheets, workbooks, and data sources

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

Can you filter from headers

A

yes by using the drop down or the exclude and keep only buttons

120
Q

Can you filter directly from the view

A

yes by using the keep only, exclude, group, or set buttons that appear when you hover over the visual

121
Q

P value

A

· 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
Q

Discrete

A

(blue) - finite set of values -> year, category, country ADD A NEW HEADER (normally dimensions)

123
Q

Animations

A

add transitions using filters, filter actions, calculations and more

124
Q

Forecasting

A

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
Q

Hierarchies

A

allow users to define custom levels of detail and create drill-down functionality. Live in workbook as metadata, not back to original source.

126
Q

Stories

A

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
Q

Grouping

A

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
Q

Unions

A

appends two or more tables to form a new combined table (good for data with the same number of rows and data types)

129
Q

Extracts

A

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
Q

Geographic fields

A

assign a geographic role. Most will auto assign. All are string type data except for latitude and longitude

131
Q

Tableau Prep - Flow pane

A

at the top and shows a visual representation of each step in the data prep process

132
Q

Alias

A

can only be created for a dimension

133
Q

Aggregation

A

Combining and summarizing data into a single representative value. Both dimensions and measures can be aggregated

134
Q

Table Calculations

A

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
Q

LOD element - exclude

A

compute at a coarse grain or higher than the view (impacted by filters/dimensions in the view)

136
Q

LOD element - fixed

A

compute at a course or fine grain. They are not impacted by filters/dimensions in the view

137
Q

LOD element - include

A

compute at a finer grain and are lower than the view (impacted by filters/dimensions in the view)

138
Q

COUNTD

A

converts a dimension into a measure

139
Q

relationships

A

create contextually appropriate joins (displayed as flexible noodles between logical tables)

140
Q

User roles are

A

creator, explorer, and viewer

141
Q

Sets

A

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
Q

Tableau Server

A

customer-managed sharing platform where creators, explorers and viewers can create, interact, and share content

143
Q

Tableau Prep

A

desktop based visual ETL program. It enables developers to connect to data, create workflows, automate jobs and share flows with others.

144
Q

Logical

A

determines if a conditional statement is true or false

145
Q

Context Filters

A

dimension filters that supersede their normal order of operations. COMMON USE CASE: Dependent Top N Filters.

146
Q

Tableau Prep - Data grid

A

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
Q

Tableau Prep - Profile pane

A

displays a summary of each field in the data sample

148
Q

R-squared

A

explains how the variance of one variable explains the variance of another. R2 ranges from 0-1, and closer to 1 is better.

149
Q

Analytics Pane

A

Find the options to add a: Trend Line, Forecast, Custom Reference Line, Reference Band, Distribution Band, Box Plot

150
Q

Dashboard sizes

A

fixed, automatic, or range

151
Q

physical layer

A

for creating unions and joins between tables (joins tables together)

152
Q

full vs. incremental refresh

A

full refresh replaces all of the contents in the extract. An incremental refresh only adds rows that are new since the previous refresh.

153
Q

Regression Models

A

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
Q

Continuous

A

infinite range of values -> age, temperature, profit -> ADD A NEW AXIS (normally measures)

155
Q

Highlighting

A

interactive tool to draw attention to specific data points in a visual

156
Q

Census data

A

is already built in to tableaus data layer

157
Q

Tableau Prep - Connections Pane

A

is on the left side and it’s the space where you connect to your data sources

158
Q

View Toolbar

A

map workspace feature gives users the ability to pan and zoom

159
Q

Joins

A

merges multiple tables based on a clause - this creates a new fixed table

160
Q

Dimension calculations

A

min/max (a/z), count, distinct count

161
Q

Scatter plots

A

Multi-axis charts. Require 2 measures and 0 dimensions.

162
Q

Field type

A

number, date, sting, Boolean or geographic role

163
Q

Dimensions

A

qualitative (used to categorize, segment, and filter) eg names and dates (normally discrete)

164
Q

Measures

A

quantitative (can be counted or aggregated) eg $, ratios, or quantities (normally continuous)

165
Q

Histogram

A

Require 1 measure and 0 dimensions

166
Q

Heatmap

A

Require 1 measure and 1 or more dimensions

167
Q

Tree maps

A

Require 1 or 2 measures and 1 or more dimensions

168
Q

Bullet Graphs

A

Require 2 measures and 1 or more dimensions

169
Q

Aggregate

A

rolls up the level of granularity on visible dimensions (used to reduce data size) **impacts the way your calculations function

170
Q

Live Connection

A

sends queries to the database/flat file and updates the view depending on the results

171
Q

sets vs groups

A

Sets are different than groups because they put the data into buckets. Groups are constant, but sets can be computed

172
Q

zip codes

A

should be coded as strings to avoid map errors

173
Q

Linear

A

shows the relationship between variables (either increasing or decreasing)

174
Q

Measure calculations

A

sum, average, median, count, Min/max, Stand. Dev., variance

175
Q

Tableau Online

A

Tableau Prep

176
Q

logical layer

A

the canvas for creating relationships between tables

177
Q

Blending

A

the canvas for creating relationships between tables

178
Q

Published Data Source

A

the data source can be either a live connection or an extract

179
Q

Exponential

A

the rate of change rises at increasingly higher rates (positive only)

180
Q

Geographic Fields and Spatial Data Files

A

The two primary forms of geospatial data

181
Q

Special data fields

A

these use geometry fields. This is usually a special .shp file. When dropping a Geometry field, everything will display as one mark.

182
Q

LOD Expressions

A

type of calculated field leverages computations that support aggregation at dimensionalities other than the view-level

183
Q

Specific and Wildcard

A

types of unions that are available in the physical layer

184
Q

Logarithmic

A

When a trend increases then levels off (only positive values)

185
Q

aggregation mix error

A

when aggregate and non-aggregate fields are used in a calculation

186
Q

Power

A

When the dependent variable (y) changes at a predetermined rate

187
Q

Polynomial

A

when variables have a fluctuating relationship (revenue over time)

188
Q

Parameters

A

workbook variables such as number, string, or date which can replace a constant value in a calculation, filter or reference line

189
Q

Flat files

A

xlsx, csv, pdf, tdsx –.TIFF files are not accessible via tableau desktop data collection window

190
Q

What can be selected to change grouping or aggregation logic in an aggregate step?

A

Card Headers

191
Q

What feature is used to combine multiple axis in a sheet?

A

Dual Axis

192
Q

What file format do Tableau Desktop proprietary data files come out as?

A

Hyper files

193
Q

What needs to be selected on a dashboard before creating an alert?

A

An axis

194
Q

What type of source can leverage a refresh schedule on Tableau Server?

A

Extracts

195
Q

When publishing a workbook to server, which menu allows you to embed authentication to data?

A

Data Sources

196
Q

Where can you union 10+ tables at once in Tableau Prep?

A

Input Step

197
Q

Which filter option in Tableau Prep must use a boolean calculation to work?

A

Calculation Filter

198
Q

Which part of the Tableau Prep workspace is defined as “A visual representation of each operation or step in the data preparation process”?

A

Flow pane

199
Q

Which source can be used in Tableau Prep if you don’t have local credentials to a database?

A

Published Data Sources

200
Q

Which step transposes rows to columns?

A

Pivot

201
Q

Which subscription option stops a subscription if no data is found?

A

Don’t send if view is empty

202
Q

Which tool helps enable Tableau Online to refresh flat files and other local sources?

A

Tableau Bridge

203
Q

Which transformation function in the data source interface works like Excel’s text-to-columns function?

A

Split

204
Q

What is the difference between a data source and a connection?

A

-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
Q

What is the wildcard tab for when filtering on dimensions?

A

(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
Q

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

A
  1. comparing the actual against the target sales
207
Q

______ is a relationship of data from different databases or text tables based on a COMMON DIMENSION. Behaves like a left join.

A

A Blend

208
Q

______ is a relationship across two different databases or text tables based on a common field.

A

A cross database join

209
Q

The icon associated with the field that has been grouped is a ______.

A

a paper clip

210
Q

_____ appends rows fro different tables with the same column names.

A

a union

211
Q

what default properties can you change for fields?

A

aggregation, comments, number formatting, color, shape, and totals (based on the type of field)

212
Q

Level of Detail (LOD) Expression

A

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
Q

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

A

B - The Tableau Desktop workflow consists of connecting to, analyzing, and sharing your data

214
Q

What type of chart is useful when wanting to evaluate two measures without stacking marks or expanding the axis?

A

bar in bar

215
Q

Which of the following is not a Trend Line model1. Linear2. Exponential3. Binomial4. Log

A

binomial

216
Q

If you want to create a histogram, what tool in tableau may be helpful?

A

Bins

217
Q

what data combinations method should you Use when combining data from different levels of detail.

A

Blend

218
Q

When using multiple data sources, the primary connection shows up as:

A

blue

219
Q

A ________ graph is a variation of a bar chart.

A

bullet

220
Q

For creating variable size bins we use __________.

A

Calculated Fields

221
Q

how do you get the the “Performance Recorder” in tableau desktop?

A

Click the Help menu, and then select Settings and Performance > Stop Performance Recording.

222
Q

What does the table calculation ‘Pane ( across then down)’ do ?

A

Computes across an entire pane and then down the pane.

223
Q

What does the table calculation ‘Table (across)’ do ?

A

Computes across the length of the table and restarts after every partition

224
Q

What does the table calculation ‘Table (across then down)’ do ?

A

Computes across the length of the table, and then down the length of the table.

225
Q

What does the table calculation ‘Pane ( down)’ do ?

A

Computes down an entire pane (NOT the whole of the table)

226
Q

What does the table calculation ‘Pane ( down then across)’ do ?

A

Computes down an entire pane and then across the pane

227
Q

What does the table calculation ‘Table (down)’ do ?

A

Computes down the length of the table and restarts after every partition.

228
Q

What does the table calculation ‘Table (down then across)’ do?

A

Computes down the length of the table, and then across the length of the table.

229
Q

What does the table calculation ‘Specific Dimension’ do ?

A

Computes only within the dimensions you specify.

230
Q

Are reference lines added to a discrete or continuous axis in a view?

A

continuous

231
Q

What can you do if you want to rename how members of a dimension appear in a visual?

A

Create aliases

232
Q

Data blends can be created by using data sources with common fields or by establishing_____________ relationships.

A

custom

233
Q

Where are data connections added in the data pane?

A

Data connections are added from the Add link in the Left pane.

234
Q

What is the difference in functionality between tableau Desktop and Tableau Online when it comes to configuring reference lines and reference bands?

A

Desktop has an option for Box Plot, web version does not

235
Q

What do relationships do?

A

Establish the potential for joins between two tables based on related fields. Does not merge data together

236
Q

Whiskers of a box plot typically show the _________ of the data. However, they can show 1.5x the _________ range.

A

extremes, interquartile

237
Q

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.

A

False - A sheet can be used within a story directly.

238
Q

T/F there are 3 different model types for trend lines.

A

False - there are 4 models1. Linear2. Log3. Exponent4. Poly/degree

239
Q

T/F Calculated fields are processed locally by tableau

A

False, calculated fields are processed in the database

240
Q

T/F Context filters do not use temp tables to reduce query size.

A

False, context filters use temp tables to reduce query size

241
Q

T/F In the formula editor, field names are represented with [Purple Text].

A

False, field names appear in [orange text] and parameters appear in [purple text]

242
Q

T/F Sets cannot be used as a filter.

A

false, sets can be used as filters

243
Q

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)

A

False. Both axes must contain a field that can be interpreted as a number.

244
Q

Where in tableau can you change the data type of a field?

A

In the data source page as well as the the data pane in a sheet

245
Q

Where do you create relationships between data sources?

A

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
Q

When updating a data extract, once can use an _______ extract, which only updates new rows since the previous extract.

A

incremental

247
Q

How do you identify a continuous field in Tableau?

A

It is identified by a green pill in a visualization

248
Q

what data combination method should you Use when you want to add more columns of data across the same row structure.

A

Join

249
Q

Use a ________ when you want to analyze data that exists in 2 separate tables within the same database

A

join

250
Q

Data blends use a ______ join to incorporate the secondary data source with the primary.

A

left

251
Q

What types of trendlines can you add in tableau?

A

linear, logarithmic, exponential, and polynomial

252
Q

Are logical tables or physical tables the default for extracts?

A

Logical Tables

253
Q

Area code boundaries, streets, and place names are all what kind of map feature?

A

map layers

254
Q

The boxes of a box plot show the _____ ____% of the data

A

middle 50, or middle two quartiles of data

255
Q

What does the box in a box plot represent?

A

middle 50% of data, the 2 middle quartiles of the data distribution

256
Q

Where are new data sources added in the data pane?

A

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
Q

can you define relationships between published data sources?

A

NO

258
Q

can you define relationships based on geographic fields?

A

NO

259
Q

what does an incremental refresh of an extract do?

A

only includes new rows since the previous refresh.

260
Q

why may it be useful to use parameters when creating calculations?

A

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
Q

what data combination method should you Use when combining data from different levels of detail

A

relationship

262
Q

relationships are to ______ tables as Joins are to ________tables

A

relationships are to logical tables and joins are to physical tables

263
Q

When using a cross-database join, data integration results at the _____ level,

A

row

264
Q

When making complex changes to filters on a dashboard, which animation type should you use?

A

Sequential Animations

265
Q

What types of reference lines can you add in tableau?

A

table, pane, and cell

266
Q

A __________ _______________ _________________ is a user-defined data subset from a data source.

A

tableau data extract

267
Q

what are partitioning fields?

A

The dimensions that define how to group the calculation (the scope of data it is performed on)

268
Q

How do dynamic sets work?

A

The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.

269
Q

how do fixed sets work?

A

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
Q

How do you relate tables across different databases?

A

they must be added as data connections within the same data source, not a new data source.

271
Q

T/F The Highlighting action can be disabled for the entire workbook.

A

True - From the toolbar the Highlighting action can be disabled for the entire workbook.

272
Q

what data combination should you Use when you want to add more rows of data with the same column structure

A

Union

273
Q

What is the condition tab for when filtering on dimensions?

A

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
Q

what are some possible downfalls or should be considerations when using physical tables?

A

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
Q

if you want to rename a dimension what can you do?

A

You can not rename the original dimension; but you can create a duplicate and rename that to achieve this

276
Q

3 ways you can sort on a visualization in tableau

A

you can sort from the header, axis, or field label

277
Q

T/F When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted field.

A

FALSE

278
Q

T/F Store procedures are available for multi-connection data sources.

A

FALSE

279
Q

T/F Data from different databases can be unioned?

A

FALSE

280
Q

T/F A Reference Distribution plot cannot be along a continuous axis.

A

FALSE

281
Q

T/F: Advanced Settings aren’t compatible with Filters in extracts

A

TRUE

282
Q

T/F Context Filters are executed after data source filters.

A

TRUE

283
Q

T/F An aggregated calculation can be multiplied by a non-aggregated constant

A

TRUE

284
Q

T/F A TDE file contains both modified and original data attributes?

A

TRUE

285
Q

T/F Calculated fields, sets, and or parameters are contained in a TDE file?

A

TRUE

286
Q

T/F Data from different sources cannot be used in a pivot?

A

TRUE

287
Q

T/F Sets are fields created on existing dimensions.

A

TRUE

288
Q

T/F Combined sets allow you to compare multiple sets to one another to determine intersections or differences across the sets.

A

TRUE

289
Q

T/F Context filters improve performance when the data source is large.

A

TRUE

290
Q

T/F Table calculations are performed locally by tableau.

A

TRUE

291
Q

T/F You will need to use an aggregated when data from multiple dimensions doesn’t have a consistent level of detail.

A

TRUE

292
Q

T/F when using Min() or MAX() if either argument is null then the function returns null.

A

TRUE

293
Q

T/F LOD calcs use data source level queries.

A

TRUE

294
Q

T/F Forecasting is not supported for multidimensional data sources.

A

TRUE

295
Q

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.

A

MAKEDATE([Year],int([Month]),1)

296
Q

What is the easiest way to make a Top N filter?

A

Make a Set off of the field

297
Q
A

Tableau Data Analyst Certification (5 decks)

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