Tableau Desktop Specialist Exam (graded A+)

Tableau Desktop Specialist Exam Which of the following is the best reason to use an extract instead of a live connection? - correct answer You need to apply an aggregation that takes too long when using a live connection. You created a group by using field labels in a view. You need to remove several members from a group. What should you do? - correct answer In the Data pane, right-click the group and select Edit Group Interactive elements that you can add to a dashboard for users include ______________. - correct answer URL actions & filter actions A field that shows average home values for the United States in 2020 is most likely - correct answer An aggregated measure On the Connect pane, what would you click to connect to a Tableau Server data source (like MKT Segmentation)? - correct answer Click "Tableau Server" Which menu option would you use to change the product language? - correct answer Help Choose Language Someone sends you a .CSV file for analysis. What are two ways you could open the file in Tableau Desktop? - correct answer Select "Text file" under "To a File" on the Connect Pane, OR drag and drop the file into Desktop What button would you push to switch between the start screen and the workbook you currently have open? - correct answer The Tableau Sparkle logo under the File menu, top left of window Connect to 'Austin Cat Shelter Data - from Kaggle'. The data is currently split into different sheets by year, so you can union the tables to bring them all into the same data source. What are two ways you can union the data? - correct answer Specific (Manual) and Wildcard (Automatic) What happens if the different sheets have different columns and you try to union them in Tableau? - correct answer The union will still work, but mismatched columns will have NULL data in the unioned table. Once you have unioned the data from the different years, you can join new columns into the data. There's a sheet called 'Cat Facts'. You can use either a join or a relationship to bring in this new data. How would you do this? - correct answer Join the data by double-clicking on the table name in the data source canvas, and then dragging other tables next to it to activate a join (a venn diagram will appear between the two tables). Relate the data by dragging other tables onto the canvas until "noodles" appear between the tables. What are three places you can change a field name? - correct answer (1) in the data source tab; (2) on the worksheet data pane, right click the field and rename; (3) slow double-click the field How can you organize your fields into folders in Desktop? - correct answer On the worksheet data pane, right click a field and select Group By Folder. Then right click any field, and select Folder Create Folder (or add to an existing folder). Once you have created folders, you can drag and drop fields into them to organize your data. How can you add a comment to a field? - correct answer On the worksheet data pane, right click a field and select Default Properties Comment. How can you set the default aggregation of a field? How does this differ for Dimensions vs Measures? - correct answer Right click a field and select Default Properties Aggregation or Total Using. This option won't appear for Dimensions unless you have created a calculated field with a dimension, such as COUNTD([name]). How can you change the fiscal year of a date field? - correct answer Right click a field and select Default Properties Fiscal Year Start. What are three ways you could save all of these metadata properties and share with a teammate? - correct answer (1) Publish the data source to Tableau Server; (2) Publish the workbook to Tableau Server and allow your teammates to download the workbook and/or data; (3) Share the local file of your workbook (either as a .twb or .twbx); (4) Extract the data source and share the .hyper file.