You have the following dataset.Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
Answer(s): B
The formula in option B calculates the percent difference in sales relative to the same quarter the previous year. It subtracts the sales of the same quarter from the previous year from the current year's sales, and then divides this by the previous year's sales. This gives a percentage change, which aligns with what is shown in the Calculation field of your dataset. The LOOKUP function returns the value of a specified offset from the current row in the partition. In this case, the offset is -4, which means the value of the same measure four rows above the current row. This corresponds to the same quarter of the previous year, assuming the data is sorted by quarter.
LOOKUP Function - TableauTable Calculations - TableauTableau Certified Data Analyst Study Guide
HOTSPOT (Drag and Drop is not supported)You have a blank dashboard.You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)
Answer(s): A
To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting "Add Show/Hide Button." You can also customize the appearance and behavior of the button. To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows.The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button.
Add Show/Hide Buttons - TableauLayout Containers - Tableau
HOTSPOT (Drag and Drop is not supported)You receive a tab-delimited data file name sales.tsv.You need to connect to the file.Which option should you select in Tableau Desktop?
To connect to a tab-delimited data file named sales.tsv, you should select the option To a File > Text file in Tableau Desktop. This option will allow you to browse and select the file from your local or network drive and connect to it as a data source. You can then specify the text file properties, such as the delimiter, the text qualifier, and whether the first row contains column names. You can also join, union, or blend the data with other data sources if needed.
Text File - TableauTableau Certified Data Analyst Study Guide
You have a sales dataset that contains the following fields.You need to analyze the average revenue per product in different regions over time.Which two fields should be measures? Choose two.
Answer(s): D,E
To analyze the average revenue per product in different regions over time, you need to use two fields that contain numeric, quantitative values that you can measure and aggregate. Quantity and Revenue are both measures that fit this criterion. You can multiply Quantity and Revenue to get the total sales for each product, and then divide by the number of products to get the average revenue. You can also use these measures to create charts and tables that show the trends and comparisons over time and across regions.
Dimensions and Measures, Blue and Green - TableauTableau Certified Data Analyst Study Guide
You are subscribed to several views.You need to unsubscribe from the views.What should you use?
To unsubscribe from the views, you should use the My Content area of Tableau web pages. This area allows you to manage your subscriptions, as well as your workbooks, views, and data sources. You can select the views you want to unsubscribe from, click Actions, and then click Unsubscribe. You can also change the subscription options, such as the schedule, the format, or the message.
Create a Subscription to a View or Workbook - TableauTableau Certified Data Analyst Study Guide
Post your Comments and Discuss Salesforce Certified Tableau Data Analyst exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the Certified Tableau Data Analyst content, but please register or login to continue.