Tableau Study guides, Class notes & Summaries

Which of the following are pre-defined aggregations - ANSWER sum avg countd Default aggregation in Tableau is? Can it be changed? - ANSWER Sum; Yes Color palettes are different for dimensions and measures. True or False? - ANSWER True - Color palettes are available for both dimensions and measures Are color of dimensions individual or continuous? - ANSWER Dimensions are individual and are not usually continuous. So they are assigned individual colors and not range of colors. Assign pa...

Which of the following is the best reason to use an extract instead of a live connection? a. Your data source only supports a live connection via ODBC. b. You need the freshest possible data at all times. c. You need to apply an aggregation that takes too long when using a live connection. d. You need to join tables that are in the data source. - ANSWER c. You need to apply an aggregation that takes too long when using a live connection. 2. You created a group by selecting field label...

T/F Dates and times are automatically placed in the dimension area of the data pane? (for relational data sources) - ANSWER True ________ dates represent the chronological progression of time. - ANSWER Continuous _______ dates show the data organized by date units. - ANSWER Discrete _____ dates show up as blue pills. - ANSWER Discrete _____ dates show up as green pills. - ANSWER Continuous Data source files contain: - ANSWER 1. A single connection or multiple connections 2. Modif...

Are color of dimensions individual or continuous? - ANSWER-Dimensions are individual and are not usually continuous. So they are assigned individual colors and not range of colors. Assign palette options will only be present for dimensions # represents the following datatype - ANSWER-numerical values Abc represents the following data type - ANSWER-text values globe icon represents the following data type - ANSWER-data with location that can show on map Calendar icon represents the fo...

You created a group by selecting field labels in a view. How can you remove members from the group? a. In the view, right-click the group members you want to remove and select Exclude. b. In the Data pane, right-click the group and select Edit Group. c. In the view, right-click the group members you want to remove and select Format. d. On a color legend,

Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's browser? - ANSWER-Yes, with the use of a Web Page object Can the highlighting action be disabled for the entire workbook? - ANSWER-Yes Can a sheet be used within a story directly? - ANSWER-False How do you identify a continuous field in Tableau? - ANSWER-It is identified by a green pill in visualization. Is it possible to use measures in the same view mu...

Workbook - ANSWER-Is the entire Tableau file containing your sheets and dashboards. Measure - ANSWER-A variable from the dataset that is meant to be aggregated. (This means it should be a number that it makes sense to do math with: sum, average, and so on.) Measures are often continuous data. Examples include GPA, sales, quantity, quota, height, and salary. Dimension - ANSWER-A categorical variable from the dataset that is used to slice and dice the data into different categories. Dimensio...

what is stored in the .tds file - ANSWER-data connection information renamed dimensions and measures folders created to organize dimensions and measures when your data is stored in tables from different databases, what method allows you to combine the data into a single viz? - ANSWER-a data blend or a cross-database join what is useful when you want to join data but the database you're using doesn't allow joins? - ANSWER-a blend what is useful when combining two tables that have the...

EXTRACT - creates a static snapshot of your data - better performance and portability - save and refresh the snapshot - best to use when numbers aren't as important How to save metadata properties in a .TDS - ANSWER-1. go to the sheet 2. right click on the data source 3. select 'Add to Saved Data Sources' 4. make sure the end of the file ends in .TDS When is it best to use a blend? - ANSWER-1. Cross-database join is not supported 2. Tables are at different LOD 3. Joins creat...