태블로 문제 유형 정리 - Part3

Q. What refers to the level of detail for a piece of data, wherever you are looking.

Data Cleanliness

Data granularity

Data connectivity

Data Load

Ans. B. Data granularity

Q. How will you change the Default Aggregation for a measure in Tableau?

Data Cleanliness

Data granularity

Data connectivity

Data Load

Ans. B. Data granularity

Q. How will you change the Default Aggregation for a measure in Tableau?

By changing its properties manaually every time we need to use it

By double clicking on the measure,and then choosing Window->Default

By right clicking the measure ->Default properties and choosing Aggregation

By right clicking the dimension -> Default properties and choosing Aggregation

Ans. C. By right clicking the measure ->Default properties and choosing Aggregation

측정값에서 가져오는 것이지, 차원이 아니다!!

Q. What field shows average home values for the United States in 2016 is most likely :

A discrete date part dimension

A continuous date value dimension

A geographical

An aggregated measure

Ans. D. An aggregated measure

When Aggregate Measures is selected, Tableau will attempt to aggregate measures in the view by default. This means that it collects individual row values from your data source into a single value adjusted to the level of detail in your view.

Q. What does the box in a box plot represent?

A. Maximum value of the data

B. Minimum value of the data

C. The interquartile range

D. The median of the middle half of the data points

Answer. C. The interquartile range

The IQR is the interquartile range – the difference between the upper quartile and the lower quartile.

사분범위 라고 불리는 것으로, 25~75% 값(50% 사이에 두고, 위아래) 를 포함한 것이 박스 플롯이다

Q. [실습 문제] How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?
A . 1
B . 2
C . 3
D . 4

풀이 :https://www.exam4training.com/how-many-quarters-did-the-electronics-assortment-show-a-negative-percent-difference-in-the-average-inventory-on-hand/

Q. [가장 큰 특징, Blend]

What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

A. No difference,calculated fields cannot be created in Blends

B. The calculated fields created in Blends cannot use more than 2 fields

C. The calculated fields created in Blends cannot be edited once created

D. Fields used in Blends must first be aggregated

Answer. D. Fields used in Blends must first be aggregated

Question. How would you calculate GDP per capital in Tableau?

SUM([GDP]/[POPULATION])

SUM([Population]/[GDP]])

SUM([GDP]*[POPULATION])

SUM([GDP])/SUM([Population])

Question. Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system’s web browser?

YES,we can do this with the help of a plugin

No,this is not currently possible in Tableau

YES,we can do this with the help of a Web-Page object

YES,we can do this with the help of Tableau Public

Which of the following are the options to export the data used to build the view or visualisations?

CSV file

PDF File

JSON format

MS Access Database

How to add a context filter?

They are executed before normal filters.
Right click on the field you want to be a context filter and click 'add to context'
(ex: find top 5 for each sub-category)

How to add a reference line or a trend line?

You can only add a reference line to continuous fields.

A. Go to the Analytics pane and drag the reference line to the visualization

B. Right click the axis and select 'add reference line'

How do you edit the bin size of a histogram?

a bin is the bucket size of each histogram bar. Right click the field you want to create a bin for, go to create and select 'bin'

You can either input a number or you can create a parameter to edit the bin size.

How do you create a calculated field (ex. string, date, simple arithmetic)?

this is a new field from our existing data.

Right click the blank area in the data pane and select "create calculated field". You can then select functions to help you create your calculated field

How to create a parameter?

Right click the empty area in the data pane and select 'create parameter'. You can then click on the parameter and select 'view parameter control'.

Use this to find the top N or bottom N values of a set

Explain the difference between discrete date parts and continuous date values in Tableau

date parts are the parts that make up the date
date values imply a level of detail in a timeline.

It will determine how the timeline is organized

Describe how an aggregated measure changes when dimensions are added to the view

the level of detail changes when a dimension is added, so the aggregation will change

What do you need to create a scatter plot?

at least two continuous measures

What do you need to create a histogram?

one continuous measure

What do you need to create a text table/cross tab/cross table/pivot table?

one discrete dimension and one continuous measure

Measure

contain numeric, quantitative values that you can measure. Measures can be aggregated. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default).

Dimension

contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view. Only exception is when the column ends in "ID"

Discrete Field

individually separate
This will show as a blue pull.

Continuous Field

forming an unbroken whole, without interruption. This will show as a green pill.

What are italic fields in Tableau?

These are automatically created by Tableau

Marks

these are the data points you have in your current view.

What are the differences between .twb and .twbx

.twb = without data
.twbx = with data

How is the filtering different for discrete and continuous fields?

discrete are filtered individually

while continuous is filtered as a range

(continuous measures will ask you to define the aggregation)

What do discrete and continuous fields add to the view?

discrete will add the header to the view
continuous will add axes to the view

What do discrete and continuous fields "bring"

discrete brings a level of detail
continuous brings and aggregated number

Most of the time what will measure and dimension values be categorized as?

measure = continuous
dimension = discrete

note - it can also go the other way

Which data types can NOT be continuous?

Do you use dimensions or measures to bring the level of detail in your data?

dimensions

What is the default connection type?

live

How do you refresh an extract?

Right click on data source
Go to extract
Refresh extract

In what order will tableau refresh filters on data sources?

1. will first refresh the extract filter
2. will then refresh the data source filter

How do you save a data source connection?

1. Go to Worksheet
2. Right click on data source
3. Add to saved data source
4. options .tds + .tdsx (you will want to use .tds)

How do you remove a data source completely?

go to the start page and click the "x"

What do each of the file extensions mean?
.twb
.twbx
.tds
.tdsx
.hyper

.twb - your project without data
.twbx - your project with data
.tds - the directory of data source + modification without data
.tdsx - the directory of data source + modification with data
.hyper - extract

What needs to be true in order to have a union?

1. tables must have the same structure
2. same column names
3. same data types

returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is NULL in the right side when there is no match.

Inner join

includes rows in the query only when the joined field matches records in both tables.

Full join

Returns all rows from both tables

When would you use blending? (4) Hint : Cross Granularity Duplicate Cleaning Lot Time

1. when cross database joins are not supported
2. Tables are at a different granularity
3. Joins create duplicate data or data cleaning is required
4. If there is a lot of data and it just takes time to run

In which resource, group or set, can you create a parameter?

set

What is a static/fixed set?

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.

What is a dynamic set?

it can automatically change when the underlying data changes. These can only be based on a single dimension

How is a group different from a set?

Grouping in Tableau is grouping multiple members/values into several groups which will create a higher category of the dimension.

Creating a set in Tableau is putting multiple values IN my a single set depending on a condition or by manually picking them. In a set you have two options, you are either in my set or out my set.

How do you create a hierarchy?

A. Drag the subordinate field onto the primary field
B. Right click and select "create hierarchy"

What are context filters?

These are filters that are executed before normal filters. If you want to add a value to these context filter, just right click and select "add to context"

Normal filters are practiced independently on the whole data source. Use context filters if you want to find "top 10 products by state"

Manual Sort

by using the color legend, you can drag and drop dimensions to be able to order the values

Automatic Sort

Right click on the value and select sort

P Value

The probability level which forms basis for deciding if results are statistically significant (not due to chance). < 0.05 is considered significant

R^2

How the model fits into the data. A right R^2 is considered "better"

how to add reference line to the view?

A. Click on analyst tab, pull reference line to table
B. Right click on the axis and select reference line

How to find % of total?

This is done within the table calculations, it is an option available for a quick table calculation

How to determine the rank?

This is an option under "quick table calculation"

What is the only thing you need to create a histogram?

a continuous measure

How do you create a group?

1. Right click on the field you want to group, click "create group".
2. Select the fields you want to add in your group, click the group button

How to create two sets and find values (aggregations)

right click on one of the sets and select "combined set" this will allow you select members and start the process

What is another name for a combined axis chart?

shared axis chart

What does LOD mean?

level of detail

How to add a dashboard action

when you are in the dashboard, click Action, and "Add Action"

What is and how do you create a segment filter?

click on the carat and select 'filter' and then 'segment'

What do continuous fields bring to a visualization?

gradient color and range filter

In general, what do discrete and continuous fields bring to a view?

discrete - add a header
continuous - add an axis

What are two additional names of a pivot table?

text table and cross-tab

What do you need in order to create a stacked bar chart?

at least 1 measure and 1 dimension

What does the '=' mean in front of a field mean?

it means this field is a calculated field

What does 'AGG' mean if it's in front of a calculated field?

it already contains an aggregation

What can you NOT drop as far as measures and dimensions?

a measure in front of a dimension

Which of the following should you use if you are making a presentation and the correctness of the numbers is more important than the performance of a dashboard?

live

Why should you create a saved data source as a .tdsx file?

You want to save default field properties, groups, sets, calculated fields, and the data itself

(데이터까지 같이 챙김)

What do you need for a better union result? [유사]

1. the number of columns should be the same in each table
2. column names should be the same in each table
3. data types for those columns should be the same

Which method(s) are available if your data comes from the same data base?

union, join, and blending

What is the main difference between sets and groups?

sets are more advanced than groups

How can you remove an element from a group?

right click to the group field in the data pane
click to edit
unselect the element

What does Tableau do if you drop a date field into the filter shelf?

asks for a selection between discrete or continuous

Aliases

Alternative names for the members in a dimension

What are three alternative ways to sort

1. manually (example: changing the order of elements in the color legend)
2. set the default sort order for values in a categorical field
3. sort by a field even if the field is not in the current view

What does a '+' mean in front of a field?

indicates the field is a hierarchy

What is a trend line?

an equation that shows the relationship between fields

Can you see the confidence intervals if you hover over a linear trend line?

NO, (CI : 신뢰구간, )

What can a story point contain?

1 sheet OR only 1 dashboard

What are four reasons to use blending?

1. when there is no support for cross-database joins
2. when two data sources have different LOD
3. when the data needs cleaning
4. when a join causes duplicate data

When would you use the 'export as' option?

downgrade the Tableau features of your view to a specific version

When would you use the 'print PDF' option

to create a vector based file

What is the image format for Mac and Windows?

Mac - TIFF (Tagged Image File Format)
Windows - BMP (Bitmap) or EMF (Enhanced Metafile) (폭탄인가?ㅋㅋ)

Which functions have an 'in/out' feature

set

[무엇..?] What do discrete fields bring to a visualization?

color palate and individual filter options

What does a triangle in front a field mean?

the field is a table calculation

What is a shadow extract?

you can't open or modify them [접근불가인가?]

If you want to share your project with data, which extension should you use?

.twbx

Can you create combined groups and sets? What about dynamic groups and sets

sets = yes
groups = no

What is good to use for faster comparisons?

reference lines

[직접 해보는 문제, 중요!!] How to create a set that shows the top 10/5 states? (dynamic set with a parameter)

Right click the states field
click new and then set
Navigate to the 'top section'
Rather than having them by a fixed number, select 'new parameter'.
Within the parameter, select "show parameter control"
Add all of the values you want to see in your view

What does dynamic set mean?

the members of the set are not fixed

How is the dual axis chart different from the combined axis chart?

dual axis chart creates two independent axis that you can plot two different measures on one chart.

combined axis merges two or more measures into a single axis

How do static sets differ from dynamic sets?

static set = fixed

What should you use if you are creating a report structure and there will be maintenance on the dashboard that you are connected?

Extract

When do you save your workbook as a .twbx file?

You want to share the workbook with someone who does not have access to the datasource and the external files associated with that workbook

Can you union tables from different databases?

no, have to have the same connection

What can you do if your data comes from different databases?

blend or cross database join

Static Set

you cannot control the elements with a parameter

Can you create a dynamic set based on another field or using your own formula?

yes

What does tableau do if you drop a continuous field to the filter shelf?

asks for an aggregated function

What are reference lines and what are they good for?

They are lines that can be placed in your view to make faster comparisons

What is a reference band?

like reference lines but with areas

What are bins?

they divide the continuous measure from a histogram into separate buckets

What are your options when you want to save your project?

1. Tableau Workbook (.twb) has no data
2. Tableau Packaged Workbook (.twbx) has data - good to use when someone doesn't have access to the data

How do you make a continuous measure discrete?

by creating a calculated field

What is another name for a combination chart?

dual axis chart

What is an important thing to do when creating a combination chart?

be sure to synchronized your axis

A blend is most similar to which type of join?

Left outer

What does it mean if the field is purple?

it's a parameter

What would be a good reason to create a saved data source as a .TDS file?

You want to save the default field properties such as number formats and sort order.

If you have bar chart with a single bar, but you want to subdivide that bar into multiple categories, what should you add to your view?

dimension

What does a .TDS file do?

TDS files save the data source metadata, such as the connection information, default field formatting, and sort order. They do not save the data source itself, and hence you should use this format if everyone who will use the data source has access to the underlying file or database defined in the connection information

Does a context filter execute before or after a dimension filter?

FIXED level of detail expressions compute a value using the specified dimensions, without reference to the dimensions in the view.

Which filters work best for a date filter?

slider filter

저작자표시

'🗝️소프트웨어 > ☕️Tableau' 카테고리의 다른 글

태블로 문제 유형 정리 - Part 2 (0)	2022.01.15
태블로 문제 유형 정리 - Part1 (3)	2022.01.15
태블로 자격증 접수 (0)	2022.01.14
[태블로/Tableau] 조인 기능 활용한 대시보드 - 12일차 (0)	2022.01.14
태블로 자격증 시험 준비(for Free) (0)	2022.01.14

'🗝️소프트웨어 > ☕️Tableau' 카테고리의 다른 글

티스토리툴바