Get Tableau Certified

1. You created a calculated field called Index with the formula INDEX (). You used the field in the chart as shown below. There is confusion among your audience between INDEX and RANK.

How would you explain to your audience the difference between RANK and INDEX?

2. You connected to a data source which is excel based and “Use Data Interpreter” feature comes up as shown below.

3. You create a pie chart for customer segments in sample superstore dataset. Part of the requirement is to show the segments with their % contribution to the overall profit. The pie chart should be like the one shown below

4. You want to rebuild a workbook using a new data source, you plan to replace the data source. What is the correct order of steps you will undertake to replace the data source given the listed steps below?

1. Open a workbook that connects to the original data source.
2. In the Replace Data Source dialog box, select the Current data source and the replacement data source.
3. Go to the sheet tab and select Data > Replace Data Source.
4. On the Data Source page, drag a table to the canvas to set up the data.
5. Select Data > New Data Source and then connect to the new data source.
6. When finished, click OK.

5. You have created a chart showing sales by year and category for Superstore dataset as below

You would like the chart to show the sales value above each bar, as shown below.

How will you accomplish the task? [select all that apply]

6. You want to track the average number of days between the Order Date and the Ship Date by Ship Mode. The visual should give the user flexibility of choosing basing on day, week, month or year.

Which function can you use to produce the above results?

7. You want to create the following chart that shows profit by subcategory. The graph should be sorted from the lowest to the highest and color coded from red to green.

What sequence of steps will you take configure the chart?

8. You have Orders table in Microsoft SQL Server as shown below.

You want to create a custom SQL Query to limit the data to only East or West regions. What should you do accomplish this task in Tableau?

A. When connected to SQL Server, Right click the Orders table, Select Custom SQL Query and write the following query:
SELECT * FROM orders WHERE region = 'East' + region = 'West'
B. When collected to SQL Server, Double click New Custom SQL and write the following query:
SELECT * FROM orders WHERE region = 'East' or region = 'West'
C. When collected to SQL Server, Double click New Custom SQL and write the following query:
SELECT * FROM orders WHERE region = 'East' and region = 'West'
D. When collected to SQL Server, Double click New Custom SQL and write the following query:
SELECT * FROM orders WHERE region = ‘East’, WHERE region = 'West'

9. There is a requirement to create a table in Tableau Desktop that shows Total Sales by Region and by Segment as shown below.

You have created a flow in Tableau Prep as shown below.

What other steps will you add to accomplish the task?

10. A company that deals with hiring out different types of vehicles has their monthly revenue by vehicle type as shown in the table. They would want the data to be transformed and have a separate column for each vehicle type instead, so that the data will be easier to analyse.

What actions can you take in Tableau Prep to accomplish the task?

1. Drag the table that you want to pivot to the Flow
2. Select a Revenue field from the left pane and drag it to the Field to aggregate for new columns section in the Pivoted Fields pane
3. Click the plus icon, and select Add Pivot from the context menu.
4. Select a Vehicle Types from the left pane, and drag it to the Field that will pivot rows to columns section in the Pivoted Fields
5. Connect to your data source.
6. In the Pivoted Fields pane, select Rows to Columns from the drop-down list.
7. In the Pivot Results pane, review the results.

11. You have the following dataset:

You want to create the following line chart.

How should you create the line chart?

12. You want to create a map based on the drinks dataset. The map is shown below.

You now want to convert the map to a filled map. What will you do to convert the map to filled map?

13. Which of the following statements is true about Unions in Tableau?

14. Tableau can connect to various data sources including relational databases. When connecting to most relational datasources what is the most common mandatory information required?

15. You have the following dataset:

16. You have a line chart the Monthly sales for the Consumer segment for the year 2020. However you want to see the trend based on previous 30 data points from the current value.

The line should show the following output

What actions will you take to come up with the chart?

17. You want to report year to date (YTD) sales by subcategory.What calculation will you put in the calculated field YTD?

A.
   If [Order Date] <= TODAY() OR DATETRUNC( "year", [Order Date]) = DATETRUNC("year", TODAY())
   THEN [Sales]
   END
B.
   If [Order Date] > TODAY() OR DATETRUNC( "year", [Order Date]) = DATETRUNC("year", TODAY())
   THEN [Sales]
   END
C.
   If [Order Date] <= TODAY() AND DATETRUNC( "year", [Order Date]) = DATETRUNC("year", TODAY())
   THEN [Sales]
   END
D.
   If [Order Date] <= TODAY() AND DATETRUNC( "month", [Order Date]) = DATETRUNC("year", TODAY())
   THEN [Sales]
   END

18. You want to create a set that shows top 10 customers. The requirement is that when a new customer enters top 10 the sets should automatically show that. How will you accomplish that using sets?

19. You created the line chart below that shows sales and another line that is used to predict median sales.

What function and chart configuration are used to create the line chart?

20. Given a line graph showing profit by month of order date, what should you do to show a forecast for the next 3 years?

21. You are creating new dashboard and you have added two sheets to the dashboard in containers as shown below.

What steps were taken to come up with that dashboard?

1. Select Horizontal
2. Drag the container to the dashboard.
3. Under Objects on the Dashboard pane,
4. Add views and objects to the layout container.
5. Select Vertical

22. You have created a map showing Taxi pick up in Manhattan in New York City as shown below.

What extra configurations can you do to change it to a heat map that is shown below?

23. Your users want to be able to navigate from one view to another view in a dashboard. How should you configure the requirement?

1. Specify how people viewing the dashboard will run the action.
2. Click Dashboard > Actions
3. Select source sheet
4. Specify a name for the action
5. Add Action
6. Specify the Target sheet >Then click OK
7. Go to Sheet

24. You have been requested to add a company logo on the dashboard that you are creating. How will you add the company logo?

25. You want to do padding to one of the dashboard contents.  You want to adjust padding for only one side. What should you do?

26. Create basic charts from scratch (bar, line, pie, highlight table, scatter plot, histogram, tree map, bubbles, data tables, Gantt, box plots, area, dual axis, combo)]

You have the following highlight table showing profit Sub-Category and by Region.

You want to create the following heat map.

How should you configure the marks for the heat map?

27. You are publishing a data source to tableau online. When will you consider using an extract?

28. You want to rank your data such that if rows have the same value they share the rank that is assigned to the first instance of the value and no rank values are skipped so that you will see consecutive rank values. Which RANK function should you use?

29. The table below shows quarterly sales.

When LAST() is computed within the Date partition what will be the output for the year 2021 Q2?

30. You have the following data set:

 
When you calculated the average amount you discover that the result is not including the missing data. You want to calculate the Average Amount. What formula should you use?