Tableau 10 Desktop Qualified Associate_Visual Analytics_21 Videos

Which of the following CANNOT be done? 1. Parameters w/ Filters 2. Parameters w/ Sets 3. Parameters w/ Calculated Fields 4. Parameters w/ Reference Lines

ALL CAN BE DONE

Give an expression to add 4 months to the date 2014-03-12?

DATEADD('month', 4, #2014-03-12#)

These levels of detail expressions subtract dimensions from the view level of detail.

EXCLUDE LOD

It contains connection information and is associated with a workbook.

Embedded Data Source

When the hierarchy has multiple levels, we can not manipulate each level independently anymore - TRUE / FALSE?

FALSE! you can still manipulate it;

This expression computes values using the specified dimensions without reference to any other dimensions in the view.

FIXED LOD

What is the difference of a FILTER vs. PARAMETER in Tableau?

Filters *trim down data in the view, showing data only for the specific criteria selected Parameters - provide a single output to another element, such as providing the reference value for the calculated field on Color

This level of detail expressions compute values using the specified dimensions in addition to whatever dimensions are in the view.

INCLUDE LOD

when to use Joins versus Blending in Tableau?

If data resides in a single source,we use Joins but when your data is not in one place blending is used.

What is a parameter?

It adds interactivity; like a variable in an equation whose value can be controlled by the end user.

An orphan parameter has no impact, because that parameter is not tied to anything, it's like adjusting a dial with no wires attached.

TRUE

Continuous green pills can be sorted by: 1. Quick sort on axis 2. Toolbar sort buttons, but they have no sort option in the pill's dropdown.

TRUE

Discrete measures, such as AVG(Discount), offer only source or manual sorting.

TRUE

INCLUDE and EXCLUDE level of detail expressions are always measures and FIXED can be either

TRUE

Multidimensional data sources are limited to their pre-built hierarchies - TRUE / FALSE?

TRUE

Only dimensions / blue pills have full sort options

TRUE

TRUE / FALSE : Date fields, depending on their level of granularity, are automatically brought into the view as hierarchies

TRUE

Not all pills will have all sort options - TRUE/FALSE

TRUE!