Data Tools and Visualization Flashcards
7 cards from real DAC practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Tools and Visualization flashcards as text
What does a boxplot primarily communicate about a dataset?
Answer: Distribution, median, and outliers
A boxplot shows the median, quartiles, spread, and outliers of a distribution.
In Excel, which feature creates an interactive summary table that can be quickly re-arranged by dragging fields?
Answer: PivotTable
A PivotTable summarizes and reorganizes data interactively by dragging fields.
Which Python library is most commonly used for statistical data visualization built on top of matplotlib?
Answer: Seaborn
Seaborn builds on matplotlib to simplify statistical visualizations.
A stacked bar chart is best used to show what?
Answer: Composition of a total across categories
Stacked bars show how a total is composed of subcategories across categories.
In dashboard design, what does the term 'data-ink ratio' encourage?
Answer: Removing non-essential visual clutter
A high data-ink ratio means removing clutter so ink represents actual data.
Which visualization best shows how a value flows and splits between stages or categories?
Answer: Sankey diagram
A Sankey diagram uses proportional flows to show movement and splitting between stages.
In Power BI, what is the purpose of a slicer?
Answer: To provide an on-canvas visual filter for viewers
A slicer is an on-canvas control that lets viewers filter visuals interactively.