DA0-002 Visualization and Reporting Practice Test 13 — 15 Questions

Question 1

A business analyst is creating a dashboard to monitor sales performance. The primary goal is to quickly identify which regions are underperforming compared to the target. Which design principle is most important to apply?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Visual hierarchy. Visual hierarchy ensures that the most important metrics (like underperforming regions) are prominently displayed, drawing the user's attention first.

Answer

Data-ink ratio

Answer

Appropriate precision

Answer

Consistent color coding

Question 2

A marketing manager wants to visualize the conversion rate at each stage of a sales funnel, from leads to closed deals. The data shows the number of prospects at each stage. Which chart type is most appropriate for this pipeline analysis?

Accepted Answer

Funnel chart. A funnel chart is specifically designed to show the progressive reduction of data as it moves through stages, making it ideal for visualizing conversion rates in a sales pipeline. It displays the number of prospects at each stage, with the width of each section representing the quantity, clearly illustrating drop-offs.

Answer

Treemap

Answer

Waterfall chart

Answer

Stacked bar chart

Question 3

A data analyst needs to show the relationship between advertising spend (in dollars) and the number of website visits. Both variables are continuous. Which chart type is most suitable?

Accepted Answer

Scatter plot. A scatter plot is the correct choice for visualizing the relationship between two continuous variables, such as advertising spend and website visits. It plots each observation as a point on a two-dimensional plane, allowing the analyst to observe correlation, trends, clusters, and outliers. This makes it ideal for bivariate continuous data analysis.

Answer

Line chart

Answer

Box plot

Answer

Bar chart

Question 4

A financial analyst wants to create a dashboard that shows the monthly profit and loss, highlighting how each component (revenue, cost of goods sold, operating expenses) contributes to the final net profit. Which chart type is most appropriate?

Accepted Answer

Waterfall chart. A waterfall chart is purpose-built to show how an initial value is incrementally increased or decreased by a series of positive and negative contributors to arrive at a final total. For a P&L, it starts at revenue, subtracts COGS and operating expenses as downward steps, and lands on net profit — making each component's contribution visually explicit. This is exactly the 'bridge' or 'walk' visualization finance teams use for variance and P&L analysis.

Answer

Pie chart

Answer

Stacked bar chart

Answer

Area chart

Question 5

A data analyst is creating a dashboard in Looker Studio for an e-commerce company. They want to display the average order value by product category, and also allow users to filter by date range. Which combination of elements should be used?

Accepted Answer

Dimension: Product Category; Metric: Average Order Value; Control: Date Range. In Looker Studio, the field you group by is the dimension and the field you aggregate is the metric. To show average order value by product category, Product Category must be the dimension and Average Order Value the metric, with a Date Range control added for user filtering. This is the only option that assigns the roles correctly and includes the required control.

Answer

Dimension: Order Value; Metric: Product Category; Control: Date Range

Answer

Dimension: Date; Metric: Product Category; Control: None

Answer

Dimension: Average Order Value; Metric: Product Category; Control: Date Range

Question 6

A data analyst is creating a presentation for executives to explain why customer churn has increased over the last quarter. The analyst wants to present the story in a compelling way. Which narrative structure is most appropriate?

Accepted Answer

Situation, Complication, Resolution. The Situation-Complication-Resolution structure is ideal for executive presentations because it first establishes the context (situation), then introduces the problem (complication—increased churn), and finally proposes a solution (resolution). This narrative arc aligns with how executives process strategic issues, making the data story compelling and actionable. In contrast, other structures are better suited for technical reports or hypothesis testing, not high-level storytelling.

Answer

Problem, Hypothesis, Test

Answer

Background, Analysis, Recommendation

Answer

Data, Visualization, Conclusion

Question 7

A data analyst wants to compare the sales revenue of five different product categories for the current month. Which chart type is most suitable for this comparison?

Accepted Answer

Bar chart. A bar chart encodes each product category as a discrete bar whose length maps to revenue, making side-by-side comparison of five categorical values immediate and precise. Categorical comparisons are the canonical use case for bar charts because the human eye judges length differences far more accurately than angles or slopes.

Answer

Histogram

Answer

Pie chart

Answer

Line chart

Question 8

A data analyst is using Power BI to create a report that shows sales by region. The data includes duplicate rows for some transactions due to a data entry error. The analyst needs to count only unique transactions. Which DAX function should be used to create a measure for unique count?

Accepted Answer

DISTINCTCOUNT. DISTINCTCOUNT is the DAX function specifically designed to count the number of distinct (unique) values in a column, ignoring duplicates. In this scenario, the analyst needs to count unique transactions despite duplicate rows, so DISTINCTCOUNT on the transaction ID column will return the correct count.

Answer

COUNT

Answer

COUNTROWS

Answer

SUMX

Question 9

A data analyst wants to visualize the distribution of employee salaries across departments and identify any outliers. Which chart type would best show quartiles, median, and potential outliers?

Accepted Answer

Box plot. A box plot is purpose-built to display the five-number summary — minimum, first quartile (Q1), median, third quartile (Q3), and maximum — with whiskers extending to 1.5×IQR and individual points plotted beyond that as outliers. This makes it the ideal chart for comparing salary distributions across departments while simultaneously surfacing outliers. No other listed chart encodes quartiles and outliers in a single view.

Answer

Heat map

Answer

Histogram

Answer

Scatter plot

Question 10

An analyst wants to show the trend of monthly sales over the past two years. Which chart type is most appropriate?

Accepted Answer

Line chart. A line chart is best for showing trends over time.

Answer

Pie chart

Answer

Bar chart

Answer

Scatter plot

Question 11

An analyst wants to visualize the relationship between advertising spend (x-axis) and revenue (y-axis) for 100 different products. Each product is in one of three categories. Which chart type best displays this data?

Accepted Answer

Scatter plot with points colored by category. A scatter plot with color-coded categories effectively shows relationships between two continuous variables and a third categorical dimension.

Answer

Bubble chart

Answer

Stacked bar chart

Answer

Line chart with three lines

Question 12

A business intelligence analyst is designing a dashboard for executives. The dashboard includes revenue, profit margin, and customer satisfaction score. To maximize the data-ink ratio, the analyst should:

Accepted Answer

Remove gridlines, use minimal colors, and avoid decorative elements. Maximizing the data-ink ratio means every drop of ink should convey data, so removing gridlines, minimizing color, and stripping decorative elements directly increases the proportion of ink devoted to actual data. This aligns with Edward Tufte's principle that non-data ink and redundant ink should be eliminated or minimized. Executives need fast, clear signal, so a clean chart with minimal chrome communicates revenue, margin, and CSAT more effectively.

Answer

Add a background image of the company logo

Answer

Use different font styles for each metric label

Answer

Use 3D pie charts with shadow effects

Question 13

Which chart type is best for showing the sales pipeline from leads to closed deals, illustrating how many prospects drop off at each stage?

Accepted Answer

Funnel chart. A funnel chart is designed to show a sequential process where values decrease through stages, making it ideal for visualizing a sales pipeline from leads to closed deals and highlighting drop-off at each stage. Its tapering shape directly communicates conversion and attrition, which is exactly what the question asks for.

Answer

Treemap

Answer

Waterfall chart

Answer

Stacked bar chart

Question 14

A financial analyst needs to show how net income is derived from revenue, costs, and expenses over a period. The chart should highlight the contribution of each component. Which chart type is most appropriate?

Accepted Answer

Waterfall chart. A waterfall chart shows how an initial value is affected by a series of positive and negative changes, making it ideal for financial breakdowns.

Answer

Line chart

Answer

Area chart

Answer

Pie chart

Question 15

A data analyst is creating a report to compare the performance of sales regions across multiple years. The report will be used by regional managers to identify trends. Which visualization approach best supports this?

Accepted Answer

Small multiples of line charts, one per region. Small multiples of line charts, one per region, allow regional managers to easily compare trends across years without visual clutter. Each region gets its own chart with consistent axes, making patterns and outliers clear. This approach supports the goal of identifying trends per region while enabling cross-region comparison.

Answer

A single line chart with all regions overlaid

Answer

A bar chart with years on x-axis and regions as grouped bars

Answer

A stacked area chart with all regions