Analytics-101 sample questions

Question 1

You are analyzing a dataset containing sales transactions where the 'Order Date' field is currently recognized as a String data type (e.g., '20230115'). You need to use this field for time-series analysis in Tableau. Which method efficiently converts this field to a Date type without modifying the underlying source file?

Accepted Answer

Create a calculated field using the DATEPARSE function to interpret the string format.

Answer

Right-click the field in the Data pane and select 'Convert to Measure'.

Answer

Use the 'Split' function to separate the year, month, and day into different columns.

Answer

Change the default properties of the field to 'Number (Whole)'.

Question 2

A data analyst connects to an Excel file where the data starts on row 5, and rows 1-4 contain merged cells and titles. The data in Tableau appears messy with nulls in the headers. What is the most efficient way to resolve this in the Data Source page?

Accepted Answer

Enable the 'Use Data Interpreter' checkbox in the left pane.

Answer

Manually delete the first four rows in the Excel file before connecting.

Answer

Create a data filter to exclude rows where the header is Null.

Answer

Hide the fields that contain the merged title information.

Question 3

You have survey data where each question is a separate column (e.g., Q1, Q2, Q3) with the respondent's answer as the value. You want to analyze the distribution of answers across all questions in a single bar chart. How should you reshape the data in the Data Source page?

Accepted Answer

Select columns Q1, Q2, and Q3, right-click, and choose 'Pivot'.

Answer

Create a calculated field that concatenates Q1, Q2, and Q3.

Answer

Union the table to itself three times.

Answer

Group the three columns into a single Group field.

Question 4

You are building a view using two tables: 'Orders' and 'Returns'. You want to analyze sales performance but also identify which orders were returned. Not all orders have returns. Which method of combining data is best suited to avoid duplicating measure values from the 'Orders' table while keeping all order records?

Accepted Answer

Use a Relationship (Noodle) between Orders and Returns on Order ID.

Answer

Use a Left Join on Order ID.

Answer

Use an Inner Join on Order ID.

Answer

Blend the data using Returns as the primary data source.

Question 5

A user needs to combine 12 separate Excel files, one for each month of the year, into a single data source in Tableau. All files are in the same folder and have identical schema. What is the most efficient way to achieve this?

Accepted Answer

Use a Wildcard Union to match files in the directory (e.g., 'Sales_2023_*.xlsx').

Answer

Manually drag each of the 12 sheets into the Union box in the Data Source canvas.

Answer

Copy and paste the data from all Excel files into a single master Excel file.

Answer

Use Data Blending to link the 12 data sources on the 'Date' field.

Question 6

You have created a scatter plot showing 'Sales' vs 'Profit'. You notice a cluster of outliers and want to exclude them from the view to focus on the main trend. After selecting the outliers, which option should you choose to remove them from the visualization but keep them in the underlying data source?

Accepted Answer

Right-click the selected marks and choose 'Exclude'.

Answer

Right-click the selected marks and choose 'Hide'.

Answer

Delete the rows corresponding to these points from the Data Source tab.

Answer

Create a Set containing the outliers and filter the set to 'In'.

Top vendors

Top exams

Free Analytics-101 sample questions

A data analyst connects to an Excel file where the data starts on row 5, and rows 1-4 contain merged cells and titles. The data in Tableau appears messy with nulls in the headers. What is the most efficient way to resolve this in the Data Source page?

You have survey data where each question is a separate column (e.g., Q1, Q2, Q3) with the respondent's answer as the value. You want to analyze the distribution of answers across all questions in a single bar chart. How should you reshape the data in the Data Source page?

A user needs to combine 12 separate Excel files, one for each month of the year, into a single data source in Tableau. All files are in the same folder and have identical schema. What is the most efficient way to achieve this?

6 more free samples are waiting