Tableau Desktop Associate Creating and Formatting Visualizations 1 — Questions and Answers
Question 1: Which chart type would be most appropriate for showing the trend of sales over time?
- Bar Chart
- Scatter Plot
- Line Chart (Correct answer)
- Pie Chart
Correct answer: Line Chart
Line charts are specifically designed to display trends and changes over a continuous period, making them ideal for visualizing how a measure like 'Sales' evolves over time. The connected data points clearly illustrate the progression, direction, and patterns of the trend. This makes it easy to spot increases, decreases, or seasonality.
Question 2: How can you make specific data points, such as "Top 10 Customers by Sales," stand out in a bar chart?
- By applying filters
- By adding a color field to distinguish the top 10 (Correct answer)
- By sorting the chart in ascending order
- By increasing the font size of labels
Correct answer: By adding a color field to distinguish the top 10
Using color is a highly effective way to draw attention to specific data points or categories in a visualization. By creating a calculated field to identify the 'Top 10 Customers' and then dragging this field to the Color shelf, you can visually highlight these customers. This makes them stand out from the rest, immediately drawing the viewer's eye to key insights.
Question 3: When would you use a dual-axis chart in Tableau?
- When you want to compare two related measures on the same chart (Correct answer)
- When you want to display a single measure on two different scales
- When you want to reduce the amount of data shown
- When you want to create a table-like structure
Correct answer: When you want to compare two related measures on the same chart
A dual-axis chart allows you to display two different measures that might have different scales or units on the same graph, using two independent Y-axes. This is particularly useful for comparing their trends or relationships side-by-side, such as sales and profit over time. It helps in understanding how two related metrics interact.
Question 4: To drill down from "Category" to "Sub-Category" in a chart, which Tableau feature should you use?
- Filter
- Hierarchy (Correct answer)
- Tooltip
- Group
Correct answer: Hierarchy
Hierarchies in Tableau allow users to drill down or roll up through different levels of detail within a dimension, such as from 'Category' to 'Sub-Category' or 'Year' to 'Quarter.' This provides an interactive way to explore data at various granularities directly within a chart. It enables deeper analysis without creating multiple separate charts.
Question 5: Which of the following can you customize to improve the readability of a chart in Tableau?
- Color, font, and size of labels (Correct answer)
- Sorting and filtering options only
- Data source connection
- Data blending options
Correct answer: Color, font, and size of labels
Tableau offers extensive formatting options to enhance the visual appeal and readability of charts. Customizing elements like colors, fonts, and the size of labels directly impacts how easily users can interpret the data and understand the insights presented. These adjustments ensure the visualization is clear, professional, and effective.
Which chart type would be most appropriate for showing the trend of sales over time?