Exploring and Analyzing Data Flashcards
5 cards from real Tableau practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 5 Exploring and Analyzing Data flashcards as text
Which of the following would you use to restrict your data to show only records where "Sales" is greater than $1,000?
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.
If you want to organize data in ascending order of "Order Date," which Tableau feature should you use?
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.
When creating a calculated field, which of the following formulas would correctly calculate "Profit Margin" if "Profit" and "Sales" are already existing fields?
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.
You want to summarize "Sales" by showing the total for each region. Which option would best accomplish this?
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.
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?
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.