Unsorted Flashcards
Sourced from around the Web
What are the export options for Tableau?
.png, .csv, .xlxs
What is the formula to concatenate two strings in Tableau?
[String One]+’’+[String 2]
Example of Fixed LOD with dimension specified
{FIXED [Category] : Sum [Sales]} this means go get all the categories and store their sum with you
For a horizontal bar chart what is needed?
0 or more dimensions or 1 or more measures
A forecast requires
1 date dimension and 1 measure
Area charts require
1 date, 0 or more dimensions, 1 or more measures
Dual line charts require
1 date, 0 or more dimensions, and 2 measures
Dual combination graphs (bar & line) require
1 date, 0 or more measures, and 2 measures
Gant Chart requires
1 date, 1 or more dimensions, and 0 to 2 measures
For a stacked bar chart what is needed?
1 or more dimensions or 1 or more measures
What are the steps to create a context filter
1) create a set 2) in the filters box click the set and add to context
In tableau cloud, what is the minimum frequency at which you can schedule a data extract refresh?
15 minutes
What is a choropleth map?
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.
For a trend line to be in the view, both axes must contain
a field that can be interpreted as a number
What are the two things that tableau has assigned in a data set?
a role and type
A story is
a sequence of visualizations that work together to convey information
A story point is
a single worksheet or dashboard
Tree Maps
a tree map breaks the whole into its parts using a quantitative measure to determine the size of each square
Measure Values contains
all the measures in your data collected into a single field with continuous values
Tableau will create what based on green pills?
an axis
What is needed to create a pie chart?
at least 1 dimension or 1 or 2 measures
Reference lines
can be added at a constant or computed value on the axis
Story navigation types
caption boxes, numberrs, arrows only or dotts
To make a map go from a symbol map to a filled map you
change the mark type to map
What are examples of drag and drop analytics from the analytics pane
clusters, trend lines, reference lines, reference bands, or distribution bands
What do clusters do
color dots on scatter plots based on certain variables
Filled maps make use of blank and not blank
color not size
What are the default properties
comment, color, shape, and sort
Fixed LOD
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
Include LOD
computes values using the specified dimensions in addition to whatever dimensions are in the view
What type of filter do you use to get sub categories with sales overr 100k?
Condition Filter
All fields must be aggregate or constant when using table calculation functions. What should go with the RANK formula?
Condition Filter
Green pills are
continuous
What are the steps to creating a Quick LOD expression?
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
PROPER
converts a text string to proper title casing by capitalizing the initial letter of each word while lower casing all other letters
UPPER & LOWER
converts text string to all upper case or lower case letters
How do you create a table showing the number of orders by category?
Create a function using the COUNT([Order ID]) and then drag the function to the text shelf then category to the row shelf
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?
datetrunc()
Measures are aggregated by
default
What does this data story type shape mean in Tableau?
Describes how something your audience cares about relates to the bigger picture
What affects the level of detail in a view?
Dimension
You can only create aliases for
dimensions
Dimensions show as blank data and appear as what color?
dimensions show as qualitative data and show as blue pills
Blue pills are
discrete
Aliases can only be applied to …
discrete dimensions and not continuous dimensions
How to get the top 5 in a data set with sub categories that changes month over month?
do a nested sort on the sub category and then create a calculated field on the larger category using the rank formula
How to convert an ordinary bar chart to a stacked bar chart?
drag a dimension to color on the marks card
How to create hierarchies
drag and drop pills on top of each other
When you create a new set using only one dimension they are
dynamic by default which means if you make a change in the data set it will automatically transfer over to tableau
Fixed LOD can be used for
either dimensions or measures
Exclude LOD
explicitly remove dimensions from the expression that is they subtract dimension from the iew level of detail
What are valid worksheet actions in tableau?
filter, highlight, go to URL
Valid dashboard sizes
fixed, range, and automatic
what does the following formula mean: {INCLUDE [Product]: Sum ([Sales])}
for every dimension in the view AND product compute the sum of sales
what does the following formula mean: {EXCLUDE [Sub Category]: Sum ([Sales])}
for every dimension in the view EXCEPT sub category compute the sum of sales
What does the datepart() function do?
gives the date as an integer
What does the datename() function do?
gives the name of the specified input (ex: june, 23)
To add a trend line
go to analysis > trendlines > add trendlines
Pills turn what color when added to a context filter
grey
Sets differ from groups because
groups are fixed and sets are not
Groups can be made x or by using x
groups can be made manually or by using find members
Tableau will create what based on blue pills?
headers
What is the equation to replace missing values with 0’s in the table?
IFNULL(LOOKUP(SUM[Sales],0),0)
Context filters function to
improve performance or create a dependent numerical or top N filter
Sets create
in groups and out groups
Level of detail exprressions
include, exclude, fixed
You cannot make reference lines, bands, and distributions for
instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
Trend lines
instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
A regular trend line (linear)
instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
A logarithmic trend line
instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
Exponential Trend LIne
instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
Sets have what icon
interlocking circles
Nested Sort
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.
Field sort
lets you specify the field value used to determine the sort order. The field doesn’t need to be used the visualization.
Sets can be made by using what three options
manually, conditions, or top
Include and exclude must always be
measures
Measures show blank data and appear as what color?
measures show as numeric/quantitative data (usually) and appear as green this is because they can be aggregated (ex: summed)
What matters in hierarchies
order
Groups have what icon
paper clip
exclude LOD expressions are useful for
percent of total or difference from overall average scenarios and are comparable to totals and reference lines
What is the function to get the median([Sales])?
Percentile([Sales],.5)
How to make a dual axis
requires two dimensions on the second measure pill use the drop down to select dual axis
LEFT & RIGHT formulas
return the specified number of characters from either the left or the right
SPLIT
returns a substring from a string as determined by a delimiter
What does datetrunc() do?
returns a truncated date of the same data type
LEN fomula
returns number of characters in given string
MID
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.
What does the maekdate() function do?
returns the date value that corresponds to a specified integer for a year month and day
What does the window formula do?
Returns the sample variance of the expression within the window
STARTSWITH/ ENDSWITH
returns true if a string starts with or ends with a specific set of charaters
CONTAINS
returns true if string contains the substring
List the quick table calcs
running total, difference, percent difference, percent of total, rank, percentile, moving average
How to add quick table calculatioons
select the drop down menu on a measure and select quick table calculations
Reference bands
shade an area behind the marks in the view between two constant or computed values on the axis
Box and Whisker Plot
shows the range of values along with the average and interquartile ranges
Reference distributions
similar to reference bands but are more powerful. instead of using max and min you can use percentages, percentiles, quantiles, and standard deviation
Histogram
split a single continuous measure into bins or groups to analyze distribution
How to create a bar in bar chart
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
What is a .tsv file?
Tab separated value
What are the output file types in tableau prep?
tableau data extract, Microsoft excel, CSV
Bullet Graph
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
What is the mark type for a cross tab map
text
What section do you use to open a .tsv file in Tableau Prep Builder?
Text file
P value means
the data is significant or unsignificant
Measure names contains
the names of all the measures in your data collected into a single field with discrete values
The shaded portion of the graph is called
the prediction or confidence interval
R value means
the ratio of the models unexplained variance to the total variance in the data
if tableau prep builder samples the data in the input step what occurs?
the sampled data is used in the flow but the entire data set is used to create the output
You can click on forecast in the marks card and see
the upper prediction interval and lower prediction interval and add to tool tip
If you go to analytics and describe forecast
there will be a summary and model which will tell you how the forecast is calculated
How to get the difference between two dates?
to do this used a fixed function to create a max an min of a date and then use the date diff function
Bar Chart
used to compare data across categories you can have horizontal bar charts, stacked bar charts, or side by side bar charts
Scatter plot
used to explore the correlation between two measures with independent axes and often combined with trendlines
Pie Chart
used to show how a few dimensions compare to one another and the whole (requires 1 or more dimensions or 1 or 2 measures)
Line Chart
used to show trends across time intervals and multiple lines can be used to compare categories within a dimension
Packed Bubble Chart
uses size as the primary visual element to allow for comparison between categories
What is the formula to get the moving average of profit for 5 days
WINDOW_AVG(SUM([Profit]),-4,0)
What can you publish to tableau server?
worksheets, workbooks, and data sources
Can you filter from headers
yes by using the drop down or the exclude and keep only buttons
Can you filter directly from the view
yes by using the keep only, exclude, group, or set buttons that appear when you hover over the visual
P value
· 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.
Discrete
(blue) - finite set of values -> year, category, country ADD A NEW HEADER (normally dimensions)
Animations
add transitions using filters, filter actions, calculations and more
Forecasting
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
Hierarchies
allow users to define custom levels of detail and create drill-down functionality. Live in workbook as metadata, not back to original source.
Stories
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
Grouping
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.
Unions
appends two or more tables to form a new combined table (good for data with the same number of rows and data types)
Extracts
are saved subsets of data that improve performance and take advantage of Tableau functionality, allowing you to refresh the data on a regular basis.
Geographic fields
assign a geographic role. Most will auto assign. All are string type data except for latitude and longitude
Tableau Prep - Flow pane
at the top and shows a visual representation of each step in the data prep process
Alias
can only be created for a dimension
Aggregation
Combining and summarizing data into a single representative value. Both dimensions and measures can be aggregated
Table Calculations
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
LOD element - exclude
compute at a coarse grain or higher than the view (impacted by filters/dimensions in the view)
LOD element - fixed
compute at a course or fine grain. They are not impacted by filters/dimensions in the view
LOD element - include
compute at a finer grain and are lower than the view (impacted by filters/dimensions in the view)
COUNTD
converts a dimension into a measure
relationships
create contextually appropriate joins (displayed as flexible noodles between logical tables)
User roles are
creator, explorer, and viewer
Sets
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.
Tableau Server
customer-managed sharing platform where creators, explorers and viewers can create, interact, and share content
Tableau Prep
desktop based visual ETL program. It enables developers to connect to data, create workflows, automate jobs and share flows with others.
Logical
determines if a conditional statement is true or false
Context Filters
dimension filters that supersede their normal order of operations. COMMON USE CASE: Dependent Top N Filters.
Tableau Prep - Data grid
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
Tableau Prep - Profile pane
displays a summary of each field in the data sample
R-squared
explains how the variance of one variable explains the variance of another. R2 ranges from 0-1, and closer to 1 is better.
Analytics Pane
Find the options to add a: Trend Line, Forecast, Custom Reference Line, Reference Band, Distribution Band, Box Plot
Dashboard sizes
fixed, automatic, or range
physical layer
for creating unions and joins between tables (joins tables together)
full vs. incremental refresh
full refresh replaces all of the contents in the extract. An incremental refresh only adds rows that are new since the previous refresh.
Regression Models
In tableau they are represented in the form of trend lines. It is a statistical modeling technique used to estimate trends/relationships between variables.
Continuous
infinite range of values -> age, temperature, profit -> ADD A NEW AXIS (normally measures)
Highlighting
interactive tool to draw attention to specific data points in a visual
Census data
is already built in to tableaus data layer
Tableau Prep - Connections Pane
is on the left side and it’s the space where you connect to your data sources
View Toolbar
map workspace feature gives users the ability to pan and zoom
Joins
merges multiple tables based on a clause - this creates a new fixed table
Dimension calculations
min/max (a/z), count, distinct count
Scatter plots
Multi-axis charts. Require 2 measures and 0 dimensions.
Field type
number, date, sting, Boolean or geographic role
Dimensions
qualitative (used to categorize, segment, and filter) eg names and dates (normally discrete)
Measures
quantitative (can be counted or aggregated) eg $, ratios, or quantities (normally continuous)
Histogram
Require 1 measure and 0 dimensions
Heatmap
Require 1 measure and 1 or more dimensions
Tree maps
Require 1 or 2 measures and 1 or more dimensions
Bullet Graphs
Require 2 measures and 1 or more dimensions
Aggregate
rolls up the level of granularity on visible dimensions (used to reduce data size) **impacts the way your calculations function
Live Connection
sends queries to the database/flat file and updates the view depending on the results
sets vs groups
Sets are different than groups because they put the data into buckets. Groups are constant, but sets can be computed
zip codes
should be coded as strings to avoid map errors
Linear
shows the relationship between variables (either increasing or decreasing)
Measure calculations
sum, average, median, count, Min/max, Stand. Dev., variance
Tableau Online
Tableau Prep
logical layer
the canvas for creating relationships between tables
Blending
the canvas for creating relationships between tables
Published Data Source
the data source can be either a live connection or an extract
Exponential
the rate of change rises at increasingly higher rates (positive only)
Geographic Fields and Spatial Data Files
The two primary forms of geospatial data
Special data fields
these use geometry fields. This is usually a special .shp file. When dropping a Geometry field, everything will display as one mark.
LOD Expressions
type of calculated field leverages computations that support aggregation at dimensionalities other than the view-level
Specific and Wildcard
types of unions that are available in the physical layer
Logarithmic
When a trend increases then levels off (only positive values)
aggregation mix error
when aggregate and non-aggregate fields are used in a calculation
Power
When the dependent variable (y) changes at a predetermined rate
Polynomial
when variables have a fluctuating relationship (revenue over time)
Parameters
workbook variables such as number, string, or date which can replace a constant value in a calculation, filter or reference line
Flat files
xlsx, csv, pdf, tdsx –.TIFF files are not accessible via tableau desktop data collection window
What can be selected to change grouping or aggregation logic in an aggregate step?
Card Headers
What feature is used to combine multiple axis in a sheet?
Dual Axis
What file format do Tableau Desktop proprietary data files come out as?
Hyper files
What needs to be selected on a dashboard before creating an alert?
An axis
What type of source can leverage a refresh schedule on Tableau Server?
Extracts
When publishing a workbook to server, which menu allows you to embed authentication to data?
Data Sources
Where can you union 10+ tables at once in Tableau Prep?
Input Step
Which filter option in Tableau Prep must use a boolean calculation to work?
Calculation Filter
Which part of the Tableau Prep workspace is defined as “A visual representation of each operation or step in the data preparation process”?
Flow pane
Which source can be used in Tableau Prep if you don’t have local credentials to a database?
Published Data Sources
Which step transposes rows to columns?
Pivot
Which subscription option stops a subscription if no data is found?
Don’t send if view is empty
Which tool helps enable Tableau Online to refresh flat files and other local sources?
Tableau Bridge
Which transformation function in the data source interface works like Excel’s text-to-columns function?
Split
What is the difference between a data source and a connection?
-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.
What is the wildcard tab for when filtering on dimensions?
(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.
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
- comparing the actual against the target sales
______ is a relationship of data from different databases or text tables based on a COMMON DIMENSION. Behaves like a left join.
A Blend
______ is a relationship across two different databases or text tables based on a common field.
A cross database join
The icon associated with the field that has been grouped is a ______.
a paper clip
_____ appends rows fro different tables with the same column names.
a union
what default properties can you change for fields?
aggregation, comments, number formatting, color, shape, and totals (based on the type of field)
Level of Detail (LOD) Expression
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.
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
B - The Tableau Desktop workflow consists of connecting to, analyzing, and sharing your data
What type of chart is useful when wanting to evaluate two measures without stacking marks or expanding the axis?
bar in bar
Which of the following is not a Trend Line model1. Linear2. Exponential3. Binomial4. Log
binomial
If you want to create a histogram, what tool in tableau may be helpful?
Bins
what data combinations method should you Use when combining data from different levels of detail.
Blend
When using multiple data sources, the primary connection shows up as:
blue
A ________ graph is a variation of a bar chart.
bullet
For creating variable size bins we use __________.
Calculated Fields
how do you get the the “Performance Recorder” in tableau desktop?
Click the Help menu, and then select Settings and Performance > Stop Performance Recording.
What does the table calculation ‘Pane ( across then down)’ do ?
Computes across an entire pane and then down the pane.
What does the table calculation ‘Table (across)’ do ?
Computes across the length of the table and restarts after every partition
What does the table calculation ‘Table (across then down)’ do ?
Computes across the length of the table, and then down the length of the table.
What does the table calculation ‘Pane ( down)’ do ?
Computes down an entire pane (NOT the whole of the table)
What does the table calculation ‘Pane ( down then across)’ do ?
Computes down an entire pane and then across the pane
What does the table calculation ‘Table (down)’ do ?
Computes down the length of the table and restarts after every partition.
What does the table calculation ‘Table (down then across)’ do?
Computes down the length of the table, and then across the length of the table.
What does the table calculation ‘Specific Dimension’ do ?
Computes only within the dimensions you specify.
Are reference lines added to a discrete or continuous axis in a view?
continuous
What can you do if you want to rename how members of a dimension appear in a visual?
Create aliases
Data blends can be created by using data sources with common fields or by establishing_____________ relationships.
custom
Where are data connections added in the data pane?
Data connections are added from the Add link in the Left pane.
What is the difference in functionality between tableau Desktop and Tableau Online when it comes to configuring reference lines and reference bands?
Desktop has an option for Box Plot, web version does not
What do relationships do?
Establish the potential for joins between two tables based on related fields. Does not merge data together
Whiskers of a box plot typically show the _________ of the data. However, they can show 1.5x the _________ range.
extremes, interquartile
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.
False - A sheet can be used within a story directly.
T/F there are 3 different model types for trend lines.
False - there are 4 models1. Linear2. Log3. Exponent4. Poly/degree
T/F Calculated fields are processed locally by tableau
False, calculated fields are processed in the database
T/F Context filters do not use temp tables to reduce query size.
False, context filters use temp tables to reduce query size
T/F In the formula editor, field names are represented with [Purple Text].
False, field names appear in [orange text] and parameters appear in [purple text]
T/F Sets cannot be used as a filter.
false, sets can be used as filters
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)
False. Both axes must contain a field that can be interpreted as a number.
Where in tableau can you change the data type of a field?
In the data source page as well as the the data pane in a sheet
Where do you create relationships between data sources?
in the logical layer of the data source. This is the default view of the canvas that you see in the Data Source page.
When updating a data extract, once can use an _______ extract, which only updates new rows since the previous extract.
incremental
How do you identify a continuous field in Tableau?
It is identified by a green pill in a visualization
what data combination method should you Use when you want to add more columns of data across the same row structure.
Join
Use a ________ when you want to analyze data that exists in 2 separate tables within the same database
join
Data blends use a ______ join to incorporate the secondary data source with the primary.
left
What types of trendlines can you add in tableau?
linear, logarithmic, exponential, and polynomial
Are logical tables or physical tables the default for extracts?
Logical Tables
Area code boundaries, streets, and place names are all what kind of map feature?
map layers
The boxes of a box plot show the _____ ____% of the data
middle 50, or middle two quartiles of data
What does the box in a box plot represent?
middle 50% of data, the 2 middle quartiles of the data distribution
Where are new data sources added in the data pane?
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
can you define relationships between published data sources?
NO
can you define relationships based on geographic fields?
NO
what does an incremental refresh of an extract do?
only includes new rows since the previous refresh.
why may it be useful to use parameters when creating calculations?
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.
what data combination method should you Use when combining data from different levels of detail
relationship
relationships are to ______ tables as Joins are to ________tables
relationships are to logical tables and joins are to physical tables
When using a cross-database join, data integration results at the _____ level,
row
When making complex changes to filters on a dashboard, which animation type should you use?
Sequential Animations
What types of reference lines can you add in tableau?
table, pane, and cell
A __________ _______________ _________________ is a user-defined data subset from a data source.
tableau data extract
what are partitioning fields?
The dimensions that define how to group the calculation (the scope of data it is performed on)
How do dynamic sets work?
The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.
how do fixed sets work?
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.
How do you relate tables across different databases?
they must be added as data connections within the same data source, not a new data source.
T/F The Highlighting action can be disabled for the entire workbook.
True - From the toolbar the Highlighting action can be disabled for the entire workbook.
what data combination should you Use when you want to add more rows of data with the same column structure
Union
What is the condition tab for when filtering on dimensions?
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.
what are some possible downfalls or should be considerations when using physical tables?
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
if you want to rename a dimension what can you do?
You can not rename the original dimension; but you can create a duplicate and rename that to achieve this
3 ways you can sort on a visualization in tableau
you can sort from the header, axis, or field label
T/F When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted field.
FALSE
T/F Store procedures are available for multi-connection data sources.
FALSE
T/F Data from different databases can be unioned?
FALSE
T/F A Reference Distribution plot cannot be along a continuous axis.
FALSE
T/F: Advanced Settings aren’t compatible with Filters in extracts
TRUE
T/F Context Filters are executed after data source filters.
TRUE
T/F An aggregated calculation can be multiplied by a non-aggregated constant
TRUE
T/F A TDE file contains both modified and original data attributes?
TRUE
T/F Calculated fields, sets, and or parameters are contained in a TDE file?
TRUE
T/F Data from different sources cannot be used in a pivot?
TRUE
T/F Sets are fields created on existing dimensions.
TRUE
T/F Combined sets allow you to compare multiple sets to one another to determine intersections or differences across the sets.
TRUE
T/F Context filters improve performance when the data source is large.
TRUE
T/F Table calculations are performed locally by tableau.
TRUE
T/F You will need to use an aggregated when data from multiple dimensions doesn’t have a consistent level of detail.
TRUE
T/F when using Min() or MAX() if either argument is null then the function returns null.
TRUE
T/F LOD calcs use data source level queries.
TRUE
T/F Forecasting is not supported for multidimensional data sources.
TRUE
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.
MAKEDATE([Year],int([Month]),1)
What is the easiest way to make a Top N filter?
Make a Set off of the field
