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

Question 1

A data analyst is building a report in Power BI and needs to create a measure that calculates the total sales for the current year, but only for products that have at least one sale in the previous year. Which DAX function combination is most appropriate?

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

Accepted Answer

CALCULATE with FILTER and SAMEPERIODLASTYEAR. Using CALCULATE with a FILTER that checks for sales in the previous year via SAMEPERIODLASTYEAR or a similar time intelligence filter achieves this dynamic filtering.

Answer

RELATED to pull product data

Answer

TOTALYTD with a filter on Date table

Answer

SUMX with a FILTER on Sales table

Question 2

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, dimensions are fields like product category, metrics are aggregations like average order value, and date range controls provide filtering.

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 3

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 4

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 is ideal for comparing discrete categories across a single metric like sales revenue.

Answer

Histogram

Answer

Pie chart

Answer

Line chart

Question 5

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 for counting unique values in a column.

Answer

COUNT

Answer

COUNTROWS

Answer

SUMX

Question 6

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 displays the median, quartiles (Q1 and Q3), and outliers, making it ideal for identifying outliers in distribution.

Answer

Heat map

Answer

Histogram

Answer

Scatter plot

Question 7

A data analyst is designing a dashboard for a sales team. Which TWO of the following are key performance indicators (KPIs) rather than operational metrics?

Accepted Answer

Customer retention rate. Customer retention rate (B) is a key performance indicator (KPI) because it measures the long-term health of customer relationships and directly reflects strategic business goals, such as loyalty and recurring revenue. It is a high-level metric that tracks performance against strategic objectives, unlike operational metrics which focus on day-to-day activities.

Answer

Number of emails sent to prospects

Answer

Number of sales calls made per day

Answer

Average time to close a deal

Question 8

A data analyst is creating a dashboard in Tableau to monitor sales performance. The dashboard will be used by executives to quickly identify trends. Which THREE design principles should the analyst apply?

Accepted Answer

Clear labels and titles. Visual hierarchy ensures key metrics stand out; consistent color coding aids interpretation; clear labels prevent confusion. Data-ink ratio is important but not as critical for executive dashboards as clarity; including many interactive filters may clutter.

Answer

Maximize data-ink ratio

Answer

Include as many interactive filters as possible

Question 9

A data analyst in a healthcare organization needs to visualize patient wait times across different departments. The data includes department names (categorical), wait times in minutes (continuous), and time of day. Which THREE chart types could be effectively used to explore this data?

Accepted Answer

Scatter plot. Box plots show distribution and outliers; scatter plots can show wait time vs. time of day; heat maps can show average wait time by department and time period. Histograms show distribution of a single variable, funnel charts are for pipelines.

Answer

Funnel chart

Answer

Histogram

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

A data analyst needs to display the distribution of customer ages in a dataset. The ages range from 18 to 85, and the analyst wants to see the shape of the distribution and identify any outliers. Which chart type should be used?

Accepted Answer

Histogram. A histogram shows the distribution of a continuous variable, while a box plot shows quartiles and outliers. The question asks for distribution shape, so histogram is more appropriate.

Answer

Scatter plot

Answer

Bar chart

Answer

Box plot

Question 12

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 13

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 data-ink ratio means removing non-data ink (chartjunk) and redundant labels, focusing on the data itself.

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 14

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 specifically designed to show conversion or drop-off rates in a pipeline.

Answer

Treemap

Answer

Waterfall chart

Answer

Stacked bar chart

Question 15

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