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

Question 1

In Power BI, an analyst wants to create a measure that calculates the total sales for the current year up to the latest date in the data. Which DAX function should be used?

Accepted Answer

TOTALYTD. TOTALYTD is a time intelligence function that sums values for the year up to the last date in the filter context (or specified end date).

Answer

SAMEPERIODLASTYEAR

Answer

CALCULATE

Answer

SUMX

Question 2

A data analyst needs to visualize the distribution of customer ages in a dataset. The analyst wants to see the frequency of ages grouped into bins. Which chart type should be used?

Accepted Answer

Histogram. A histogram groups continuous data into bins and shows the frequency of each bin, making it ideal for visualizing the distribution of a continuous variable like age.

Answer

Pie chart

Answer

Box plot

Answer

Bar chart

Question 3

Which chart type is best for showing the number of website visitors at each stage of a conversion funnel, from initial visit to purchase?

Accepted Answer

Funnel chart. A funnel chart is specifically designed to visualize the progressive reduction in volume across stages of a linear process, such as a conversion funnel. It clearly shows the number of visitors at each stage (e.g., initial visit, product view, add to cart, purchase) and the drop-off between them, making it the optimal choice for this scenario.

Answer

Stacked bar chart

Answer

Treemap

Answer

Waterfall chart

Question 4

In Tableau, an analyst wants to create a calculated field that returns the average sales per customer only for customers who have made more than five purchases. Which Tableau function or approach would be most efficient?

Accepted Answer

Use a Level of Detail expression to count purchases per customer, then filter. Level of Detail (LOD) expressions like { FIXED [Customer ID] : SUM(…) } allow computations at a granular level. Then using an IF condition on the LOD result filters to customers with >5 purchases.

Answer

Use a table calculation for running sum

Answer

Use a context filter on the number of records

Answer

Create a parameter to filter customers

Question 5

A data analyst is presenting a time-series chart of monthly sales to executives. The sales dropped sharply in March due to a one-time supply chain disruption. Which storytelling technique would best help the audience understand this anomaly?

Accepted Answer

Add an annotation explaining the supply chain disruption. Adding an annotation directly on the chart provides immediate context for the March sales drop, allowing executives to understand the anomaly without leaving the visualization. This technique follows the principle of 'contextual annotation' in data storytelling, where key events are marked to prevent misinterpretation of trends. It preserves data integrity while clarifying the cause, which is essential for accurate decision-making.

Answer

Remove the March data point to avoid confusion

Answer

Use a different chart type to hide the drop

Answer

Use a moving average to smooth the drop

Question 6

A data analyst is working in Looker Studio and wants to add a metric that counts the number of unique customers per month. In the context of Looker Studio, which type of field is this metric?

Accepted Answer

Metric. In Looker Studio, a metric is a field that aggregates numeric data, such as counts, sums, or averages. Counting unique customers per month requires an aggregation (COUNT_DISTINCT) applied to a numeric or identifier field, which is the defining characteristic of a metric. Dimensions are used for grouping and categorizing data, not for performing calculations like counting unique values.

Answer

Dimension

Answer

Parameter

Answer

Blend

Question 7

A sales analyst is designing a report for the sales team that includes the number of new leads, conversion rate, and total revenue. The team wants to identify which metrics are Key Performance Indicators (KPIs) tied to the strategic goal of increasing revenue. Which TWO of the following should be classified as KPIs?

Accepted Answer

Total revenue. Total revenue is a direct measure of the strategic goal of increasing revenue, making it a clear Key Performance Indicator (KPI). It quantifies the financial outcome that the sales team is aiming to improve, aligning perfectly with the stated objective.

Answer

Average deal size

Answer

Customer satisfaction score

Answer

Number of new leads

Question 8

A data analyst is creating a dashboard to monitor e-commerce performance. The dashboard will be used by both executives (strategic view) and operations managers (detailed view). The analyst plans to use interactive filters. Which THREE design principles or features are most important to apply for effective dashboard design?

Accepted Answer

Consistent color coding across all charts. Visual hierarchy ensures executives see key metrics first. Consistent color coding helps users quickly associate colors with categories. Interactive filters allow different users to drill down to their required level of detail. Data-ink ratio is important but less critical for multi-user dashboards. Annotations are useful for storytelling but not a core design principle for interactive dashboards.

Answer

Including annotations on every data point

Answer

Maximizing the data-ink ratio by removing all labels and titles

Question 9

An analyst is creating a dashboard in Power BI to track sales performance. They want to ensure that when a user selects a specific product category on a slicer, all other visuals on the page filter to show data only for that category. Which TWO actions should the analyst take?

Accepted Answer

Edit interactions between the slicer and other visuals to ensure filtering is enabled. In Power BI, slicers by default filter all visuals on a page. However, if the analyst wants to ensure cross-filtering, they can edit interactions to enable filtering. Also, using the 'Sync slicers' pane is for syncing slicers across pages, not for enabling filtering. The 'Filters' pane is for manual filters, not for slicer interactions.

Answer

Use the 'Sync slicers' pane to synchronize the slicer across all pages

Answer

In the 'Format' pane, set the slicer to 'Single select'

Answer

Create a measure using the CALCULATE function with ALLEXCEPT

Question 10

A business analyst needs to show the monthly sales trend for the past three years. Which chart type is most appropriate?

Accepted Answer

Line chart. Line charts are ideal for displaying trends over time, making them suitable for showing monthly sales trends.

Answer

Histogram

Answer

Pie chart

Answer

Scatter plot

Question 11

A data analyst wants to compare the revenue across five different product categories. Which chart type is best suited?

Accepted Answer

Bar chart. Bar charts are ideal for comparing categories because they display discrete values side by side.

Answer

Scatter plot

Answer

Pie chart

Answer

Line chart

Question 12

In Tableau, you want to create a view showing the total sales per region, but also want to allow users to filter by year without losing the ability to see all regions. What feature should you use to compute the total sales that ignores the year filter?

Accepted Answer

LOD expression: { FIXED [Region] : SUM([Sales]) }. A Level of Detail (LOD) expression with FIXED can compute a value at the region level, ignoring other dimensions like year.

Answer

Table calculation running total

Answer

Parameter action

Answer

Calculated field using SUM([Sales])

Question 13

When designing a dashboard for executives, which principle is most important to follow to ensure key information is immediately visible?

Accepted Answer

Create a visual hierarchy with the most important metric prominently displayed.. Visual hierarchy ensures the most important metric is prominently placed and sized to draw attention first.

Answer

Apply consistent color coding across all charts.

Answer

Use as many colors as possible to highlight different data points.

Answer

Include all available data to provide complete context.

Question 14

A data analyst needs to show the cumulative revenue over time, with emphasis on the total magnitude. Which chart type is most appropriate?

Accepted Answer

Area chart. Area charts display cumulative values over time, filling the area under the line to emphasize magnitude.

Answer

Scatter plot

Answer

Bar chart

Answer

Pie chart

Question 15

Which chart type is best for displaying the distribution of a continuous variable, such as the age distribution of customers?

Accepted Answer

Histogram. A histogram is the correct choice because it groups continuous data (like age) into bins along the x-axis and displays the frequency of observations within each bin as bars, making the distribution shape immediately visible. This directly addresses the need to show how customer ages are spread across the range, which is the definition of a distribution for a continuous variable.

Answer

Box plot

Answer

Line chart

Answer

Pie chart