FREE Tableau Desktop Associate Exploring and Analyzing Data Questions and Answers
You want to summarize "Sales" by showing the total for each region. Which option would best accomplish this?
Aggregation allows you to summarize data, such as calculating the total "Sales" for each "Region." Aggregated measures provide a higher-level overview of data by grouping values.
Which of the following would you use to restrict your data to show only records where "Sales" is greater than $1,000?
Filtering allows you to restrict data based on specific criteria, such as showing only records with "Sales" greater than $1,000. This makes it easy to focus on particular data segments for analysis.
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?
A calculated field can be used to create new dimensions or measures based on existing data. Here, you could create a calculated field with an IF statement to categorize customers as "High Value" or "Regular" based on their sales.
If you want to organize data in ascending order of "Order Date," which Tableau feature should you use?
Sorting arranges data in a specified order, such as ascending or descending. Sorting by "Order Date" in ascending order will display the data from the earliest to the latest date.
When creating a calculated field, which of the following formulas would correctly calculate "Profit Margin" if "Profit" and "Sales" are already existing fields?
To calculate "Profit Margin," you divide "Profit" by "Sales" to get the ratio of profit to sales, which is a common way to assess the profitability of sales.