Tableau Desktop Associate Exploring and Analyzing Data 1 — Questions and Answers
Question 1: Which of the following would you use to restrict your data to show only records where "Sales" is greater than $1,000?
- Grouping
- Filtering (Correct answer)
- Sorting
- Aggregating
Correct answer: Filtering
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?
- Filter
- Group
- Sort (Correct answer)
- Aggregate
Correct answer: Sort
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?
- Profit + Sales
- Profit * Sales
- Profit / Sales (Correct answer)
- (Profit - Sales) / Sales
Correct answer: Profit / Sales
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?
- Sorting
- Filtering
- Grouping
- Aggregation (Correct answer)
Correct answer: Aggregation
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?
- Filter
- Grouping
- Calculated Field (Correct answer)
- Aggregation
Correct answer: Calculated Field
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 Desktop Associate Exploring and Analyzing Data 1
Which of the following would you use to restrict your data to show only records where "Sales" is greater than $1,000?