LOD Flashcards
True or False?
Datasets with more records always contain higher lvl of granularity than datasets with less records
False
the amount of records is not a direct indicator of the data granularity. It’s what one record of data represents that determines the level of detail of the dataset
True or False:
LOD expressions require the same dimensions to be present in the canvas
False
LOD expressions are used so that the dimensions DON’T have to be present in the canvas
Unlike ___ LOD expressions, ____ is sensitive to adding or removing dimensions in the view, as doing this will change the calculation.
FIXED
INCLUDE & EXCLUDE
What will happen to a FIXED LOD expression if you add/remove dimensions in the view?
Nothing
What will happen to an INCLUDE LOD expression if you add/remove dimensions in the view?
the calculations will change therefore the results will change
What will happen to an EXCLUDE LOD expression if you add/remove dimensions in the view?
the calculations will change therefore the results will change
Why would you use an EXCLUDE LOD instead of the Analysis tab for calculating subtotals?
B/c using the analysis tab does not allow us to further calculate the totals, for example, using the total to create a new column calculating the percentage
see image in doc.
Instead of using the “subtotal” option in the “Analysis” tab of the Worksheet, you can create an _____ LOD so that we can ______.
EXCLUDE
use the subtotals in another calculation
Where do FIXED LODs lie in the Order of Operations
Context Filters then
Fixed LODs then
Dimension Filters
Where do Include/Exclude LODs lie in the Order of Operations
Dimension Filters then
Include/Exclude LOD then
Measure Filters
What is the full Order of Operations for Filters and LODs
Measure Filters
Table Calc Filters
Fixed LOD
Context Filters
Extract Filters
Exclude/Include LOD
Data Source Filters
Dimension Filters
Extract Filters
Data Source Filters
Context Filters
Fixed LOD
Dimension Filters
Exclude/Include LOD
Measure Filters
Table Calc Filters
A typical use case of ___ is calculating totals & subtotals
Exclude
____ calculates at a higher LOD than the one which is present in the visualization
Exclude
Calculates at a lower LOD than the database
Include
Calculates at a finer LOD than the database
Include
___ LOD expression allows you to calculate on a finer detail of the data and re-aggregate it on the canvas on a coarser level.
INCLUDE
Are there any syntax errors?
{ EXCLUDE : SUM(Sales) }
No
Unlike EXCLUDE, INCLUDE calculation is not sensitive to adding or removing dimensions from the view.
T/F
False
All LOD Expressions are performed b/f dimension filters, considering Tableau’s order of operations.
T/F
False
All LOD Expressions are performed b/f Measure filters, considering Tableau’s order of operations.
T/F
True
All LOD Expressions are performed a/f Context filters, considering Tableau’s order of operations.
T/F
True
What is Survival Analysis?
Analyzing how many subjects remain in data set on a given day (or other time-series)
E.g. who still keeps their NY resolutions in February?
Where for Fixed LOD occur?
Extract Filters
Data Source Filters
Context Filters
Dimension Filters
Measure Filters
Table Calc Filters
b/f dimensions
Where for INCLUDE/EXCLUDE LOD occur?
Extract Filters
Data Source Filters
Context Filters
Dimension Filters
Measure Filters
Table Calc Filters
after dimensions
Include
EXCLUDE
Fixed
Calculating at ___ LOD than the visual
The visual with the LOD is at a/n ____ granular lvl as compared to a visual without the LOD.
Lower - More,
Higher - Less,
Exactly specific - Independent
Which LOD would you use to calculate measures b/t various dimensions?
Fixed
Which LOD would you use to swap b/t daily and weekly?
Fixed
What is Cohort Analysis?
Analyzing repetitive behavior of a group
E.g. usage of a product by various client groups/cohorts
