DA0-001 Visualising Data Practice Test 6 — 15 Questions

Question 1

A data analyst wants to show the distribution of customer ages for a retail store. The ages are continuous and the analyst needs to visualize the frequency of different age ranges. Which chart type is most appropriate?

Accepted Answer

Histogram. A histogram is used to display the distribution of a continuous variable by grouping data into bins.

Answer

Bar chart

Answer

Line chart

Answer

Pie chart

Question 2

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?

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 3

A data analyst is creating a dashboard in Tableau to show monthly sales trends. The data source includes daily sales figures. The analyst needs to calculate the cumulative sales for each month and compare it to the same period last year. Which Tableau feature should be used for the year-over-year comparison?

Accepted Answer

Table calculations. Tableau's table calculations can compute running totals and year-over-year comparisons without modifying the data source.

Answer

Calculated fields

Answer

Level of Detail (LOD) expressions

Answer

Parameters

Question 4

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 progressive reduction as data moves through stages of a process.

Answer

Treemap

Answer

Waterfall chart

Answer

Stacked bar chart

Question 5

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. Scatter plots are ideal for visualizing the correlation between two continuous variables.

Answer

Line chart

Answer

Box plot

Answer

Bar chart

Question 6

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 effectively shows how each incremental positive or negative value contributes to a final total, making it ideal for profit/loss breakdowns.

Answer

Pie chart

Answer

Stacked bar chart

Answer

Area chart

Question 7

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?

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 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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