Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.
Open the link to Book1 found on the desktop. Open the Line worksheet.
Modify the chart to show only main and max values of both measures in each region.
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.
Open the link to Book1 found on the desktop. Open the sales dashboard.
Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.
Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.
You want to add a comment to March 2020 as shown in the following visualization.
You have the following sets in a Tableau workbook
• Top N Customers
• Customers of 2020
• Top N Products
• Sellers of 2020
Which two sets can you combine? Choose two
You have the following dataset.
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.
You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?
You have the following box plot that shows the distribution of average profits made in every state by region.
Which region has the smallest distribution of profits?
You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.
The following is a sample of the sales data for me division in Germany.
You have population data in a file named Populatio.csv. the following is a sample of the data.
You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
You need to prepare the data to support the planned visualization. The data source must support being published .
Which four actions should you perform in order?
(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
Use Answer Area arrows to re-order the options)
You have the following line chart that shows the average sales by month.
Which month had the biggest increase in swage sales compared to me previous month in 2019?
You have the following data source in tableau Server.
You need to ensure that the data is updated every hour.
What should you select?
You have the Mowing dashboard.
Which two elements are floating? Choose two.
You have the following dataset.
You need to create the following worksheet.
The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)
You have the following chart that shows the cumulative of sales from various dates.
You want the months to appear as shown in the following chart.
What should you do?
You have the following tiled dashboard that has one sheet.
You want to replace the sheet with Sheet2.
What should you do?
You have a data source that contains the following columns.
You want to sort customers based on the most expensive orders.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
You are developing a data source in Tableau Prep.
You have two tables named Orders and Employees.
The Orders table was created in 2019 and contains the following columns.
The Employees table contains all the employee information for the various sales teams in the sales department and contains the following columns
You want to prepare the data so that you can analyze sales trends over time for every sales team.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area. Use Answer Area arrows to re-order the options.)
You conned to a Microsoft SQL Server database
You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned
How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
You publish a dashboard that uses an extract. The extract refreshes every Monday at 10:00.
You need to ensure that the extract also refreshes on the last day of the month at 18:00.
What should you do?
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.)
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.
You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.