DA0-001 Visualising Data — Timed 15 Questions

Question 1

A data analyst wants to compare the total sales of four different product categories for a single year. Which chart type is most appropriate for this comparison?

Accepted Answer

Bar chart. A bar chart is ideal for comparing discrete categories because the length of each bar represents the total value, making it easy to see which category has the highest sales.

Answer

Pie chart

Answer

Scatter plot

Answer

Line chart

Question 2

A dashboard designer is creating a sales performance dashboard and wants to minimize non-data ink to improve clarity. Which action best follows the principle of maximizing the data-ink ratio?

Accepted Answer

Removing gridlines that do not add value to the chart. Option A is correct because it directly follows Tufte's data-ink ratio principle by removing non-data ink (gridlines that don't aid interpretation) while preserving the core data. This maximizes the proportion of ink devoted to actual sales metrics, improving clarity without sacrificing information.

Answer

Including a detailed company logo on every chart

Answer

Adding a background image to make the dashboard more visually appealing

Answer

Using 3-D effects on bars to make them stand out

Question 3

An analyst has a dataset with monthly sales figures for the past five years. They want to highlight the cumulative effect of sales over time and show the total contribution of each month stacked on top of previous months. Which chart type is most suitable?

Accepted Answer

Area chart. An area chart is the most suitable choice because it fills the space between the line and the baseline with color, visually emphasizing the cumulative total over time. This allows the analyst to see both the trend of monthly sales and the stacked contribution of each month to the overall cumulative effect, which is exactly what the question requires.

Answer

Line chart

Answer

Stacked bar chart

Answer

Waterfall chart

Question 4

A data analyst is building a dashboard for executives and wants to ensure the most important metric, total revenue, is immediately visible. Which design principle should the analyst apply?

Accepted Answer

Visual hierarchy. Visual hierarchy means arranging elements so that the most important information is most prominent, often by placing it in the top-left or center and making it larger.

Answer

Appropriate precision

Answer

Consistent color coding

Answer

Data-ink ratio

Question 5

Which of the following is a key difference between a Key Performance Indicator (KPI) and a metric?

Accepted Answer

KPIs are tied to strategic objectives, while metrics are broader operational measurements. KPIs are tied to strategic objectives and measure progress toward goals, while metrics can be any operational measurement that may not be directly linked to strategy.

Answer

Metrics are always quantitative, while KPIs can be qualitative

Answer

There is no difference; the terms are interchangeable

Answer

KPIs are always lagging indicators, while metrics are leading indicators

Question 6

A business analyst wants to show the relationship between advertising spend (independent variable) and sales revenue (dependent variable) for 12 different regions. Each region will be represented by a point. Which chart type is most appropriate?

Accepted Answer

Scatter plot. A scatter plot is the most appropriate chart type because it directly visualizes the relationship between two continuous variables—advertising spend (independent) and sales revenue (dependent)—by plotting each of the 12 regions as a point. This allows the analyst to assess correlation, trends, and outliers, which is the core purpose of scatter plots in data visualization.

Answer

Line chart

Answer

Bar chart

Answer

Histogram

Question 7

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 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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