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!