_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

• A.Tableau Packaged Workbook (.twbx)
• B.Tableau Workbook (.twb)
• C.Tableau Data Extract (.tde)
• D.Tableau Data Source (.tds)

Comment: *

Name: *

Email: *

Verification: *

If you see the following Filter, then you're working with _______________________ Larger image

• A.Grouped Dates
• B.Date Functions
• C.Date Parts
• D.Date Values

Correct Answer: D

Explanation
Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display.
The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values.
Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter.
Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.

Comment: *

Name: *

Email: *

Verification: *

What are two requirements to combine two tables by using a union? Choose two.

• A.Related fields must have matching data types.
• B.Related fields must have different names.
• C.The tables must come from different connections.
• D.The tables must have the same number of fields.

Comment: *

Name: *

Email: *

Verification: *

Which statement accurately describes an extract when the Physical Tables option is selected?

• A.Data is limited to only the Top N of data for the connection.
• B.All the data is tolled up to the current visible fields.
• C.An individual table is created for each physical table in the extract.
• D.Data shown in the Data pane is separated based on the table type.

Comment: *

Name: *

Email: *

Verification: *

To use a quick table calculation, which of the following programming languages do you need to know?

• A.ython
• B.Java
• C.Javascript
• D.None of these

Correct Answer: D

You don't need to know ANY programming language to use quick table calculations!
Follow along with the steps below to learn how to apply a quick table calculation to a visualization:
1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.
2) Navigate to a new worksheet.
3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf.
4) From the Data pane, under Dimensions, drag State to the Rows shelf.
5) From the Data pane, under Measures, drag Sales to Text on the Marks Card.
6) From the Data pane, under Measures, drag Profit to Color on the Marks Card.
7) On the Marks card, click the Mark Type drop-down and select Square.

The visualization updates to look like this:

Apply the quick table calculation
1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.
Note: You can only perform quick table calculations on measures in the view.
A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.

Comment: *

Name: *

Email: *

Verification: *