HOTSPOT (Drag and Drop is not supported)You have a data set that contains three columns named Sales, Profit, and Quantity.You need to build the following scatter plot.
Answer(s): A
To build the scatter plot shown in the image, you need to place the Profit measure on the Rows shelf and the Sales measure on the Columns shelf. This will create a Cartesian chart with Profit as the y- axis and Sales as the x-axis. Then, you need to change the mark type to Circle on the Marks card. This will display the data points as circles that vary in size according to the Quantity measure. You can also add color or shape encoding to the marks to show additional dimensions or measures in the view.
Build a Scatter PlotUnderstanding and Using Scatter PlotsScatter plot in Tableau
DRAG DROP (Drag and Drop is not supported)You have the following calculated fields in a worksheet.[Calc1] = DATEADD ('year', -1, TODAY ())[Calc2] = DATETRUNC ( 'month' , DATEADD ('year', -1, TODAY ())You want to calculate the month to date value of the prior year.How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and [Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.
Finding the Month-to-Date Values for the Prior Year[DATEADD Function][DATETRUNC Function]
You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.You want to combine the tables to meet the following requirements:. Each record in Employeelnfo must be retained in the combined table. . The records must contain the Department Name, Size, and VP fields.· Every record must have a full name.Which type of join should you use?
Answer(s): B
To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this:
Join Your Data - TableauJoin Types in Tableau
You want to create the following dashboard.The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.How should you lay out the objects on the dashboard?
Answer(s): D
To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories.
Size and Lay Out Your Dashboard - TableauCreate a Dashboard - TableauFormat Dashboard Layout in Tableau - GeeksforGeeks
You are creating an annual report in Microsoft Word.In Tableau Desktop, you build a chart in a worksheet.You want to create an image of the chart that you can add to the annual report.What are two ways to create the image? Choose two.
Answer(s): A,B
To create an image of the chart that you can add to the annual report, you can use either the Export option or the Copy option from the Worksheet menu. The Export option will allow you to save the image as a file in a specified location, name, and format. The Copy option will allow you to copy the image to the clipboard and paste it into another application, such as Microsoft Word. Both options will let you choose which elements to include in the image, such as title, caption, legend, etc.
Export Views from Tableau Desktop to Another Application Copy and Paste Views from Tableau Desktop to Another Application
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.