Tableau Desktop Associate Exploring and Analyzing Data

Question 1

Which of the following would you use to restrict your data to show only records where "Sales" is greater than $1,000?

Accepted Answer

Filtering

Answer

Filtering is the specific process in Tableau used to restrict the data shown based on specified conditions or criteria. To display only records where 'Sales' is greater than $1,000, you would apply a filter to the 'Sales' field with that exact condition. This allows you to focus on a relevant subset of your data.

Question 2

If you want to organize data in ascending order of "Order Date," which Tableau feature should you use?

Accepted Answer

Sort

Answer

Sorting is the specific Tableau feature used to arrange data in a particular order, whether ascending or descending, based on the values of a chosen field. To organize data by 'Order Date,' you would apply a sort to that dimension. This helps in analyzing trends or sequences over time.

Question 3

When creating a calculated field, which of the following formulas would correctly calculate "Profit Margin" if "Profit" and "Sales" are already existing fields?

Accepted Answer

Profit / Sales

Answer

Profit Margin is a common financial metric calculated by dividing the profit by the sales revenue. Therefore, the correct formula in Tableau to create a calculated field for 'Profit Margin' would be `Profit / Sales`. This calculated field allows you to derive new insights from existing data.

Question 4

You want to summarize "Sales" by showing the total for each region. Which option would best accomplish this?

Accepted Answer

Aggregation

Answer

Aggregation is the process of summarizing data, such as calculating a sum, average, count, or maximum. To show the total 'Sales' for each region, you would aggregate the 'Sales' measure (e.g., SUM(Sales)) and display it broken down by the 'Region' dimension. This provides a high-level overview of sales performance.

Question 5

If you want to categorize customers into "High Value" (sales over $5,000) and "Regular" (sales under $5,000), which Tableau feature should you use?

Accepted Answer

Calculated Field

Answer

A calculated field allows you to create new data based on existing fields using formulas. To categorize customers based on a sales threshold, you would create a calculated field with an IF/THEN statement, such as `IF [Sales] > 5000 THEN "High Value" ELSE "Regular" END`. This dynamically assigns categories based on your specified logic.

Tableau Practice Test

Tableau Practice Test

Tableau Desktop Associate Exploring and Analyzing Data