75 of 113 questions · Page 1/2 · Dap Visualising Data topic · Answers revealed
An analyst wants to show the trend of monthly sales over the past two years. Which chart type is most appropriate?
Line charts clearly display trends over time.
Why this answer
A line chart is best for showing trends over time.
A data analyst wants to visualize the number of website visitors by traffic source (e.g., organic, paid social, email) and also show the proportion of each source within the total. Which chart type is best?
Stacked bar charts show both category totals and subcategory proportions.
Why this answer
A stacked bar chart is best because it allows the data analyst to display both the absolute number of visitors per traffic source and the proportional contribution of each source to the total across categories (e.g., time periods). Each bar represents the total visitors, and segments within the bar show the breakdown by source, making it easy to compare both individual source counts and their relative shares.
Exam trap
The trap here is that candidates often choose a pie chart because it shows proportions, but fail to recognize that the question requires displaying both absolute visitor counts and proportions, which a pie chart cannot do for multiple categories or time periods.
How to eliminate wrong answers
Option B (Histogram) is wrong because histograms display the distribution of a single continuous variable by binning data into intervals, not categorical comparisons of traffic sources. Option C (Pie chart) is wrong because while it shows proportions of a whole, it cannot effectively display absolute visitor counts for multiple categories or allow easy comparison across different time periods. Option D (Line chart) is wrong because line charts are designed to show trends over continuous time intervals, not categorical breakdowns of proportions within a total.
Which chart type is best for comparing the distribution of a continuous variable across different categories?
Box plots effectively compare distributions across categories.
Why this answer
Box plots provide a summary of distribution including median, quartiles, and outliers, making them ideal for comparing distributions across groups.
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?
Histograms display frequency distributions of continuous variables.
Why this answer
A histogram is used to display the distribution of a continuous variable by grouping data into bins.
A data analyst needs to show the cumulative revenue over time, with emphasis on the total magnitude. Which chart type is most appropriate?
Area charts are ideal for cumulative trends over time.
Why this answer
Area charts display cumulative values over time, filling the area under the line to emphasize magnitude.
A data analyst needs to visualize the relationship between advertising spend and sales revenue for 50 products. Which chart type is most appropriate?
Scatter plots show correlation between two variables.
Why this answer
A scatter plot is the most appropriate chart type for visualizing the relationship between two continuous variables—advertising spend and sales revenue—across 50 products. It allows the data analyst to assess correlation, trends, and potential outliers by plotting each product as a point on a Cartesian plane, with advertising spend on the x-axis and sales revenue on the y-axis.
Exam trap
The trap here is that candidates often confuse a bar chart or histogram with a scatter plot when the question involves two numeric variables, but a bar chart is designed for categorical comparisons and a histogram for single-variable distributions, not for bivariate relationships.
How to eliminate wrong answers
Option A is wrong because a histogram is used to display the distribution of a single continuous variable by grouping data into bins, not to show the relationship between two variables. Option B is wrong because a bar chart compares categorical data or discrete values, not the continuous relationship between two numeric variables like advertising spend and sales revenue. Option C is wrong because a pie chart shows proportions of a whole for categorical data, making it unsuitable for visualizing the correlation between two continuous variables.
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:
Minimal non-data ink increases the data-ink ratio.
Why this answer
Maximizing data-ink ratio means removing non-data ink (chartjunk) and redundant labels, focusing on the data itself.
An analyst needs to display the number of website visitors per age group (e.g., 18-25, 26-35, 36-45). Which chart type is most appropriate?
Histograms are designed for binned continuous data.
Why this answer
A histogram displays the distribution of a continuous variable (age) across bins (age groups).
In Power BI, a data analyst needs to create a measure that calculates total sales for the current year. Which DAX function should be used?
TOTALYTD calculates year-to-date total.
Why this answer
TOTALYTD is a time intelligence function that calculates a running total for the year-to-date.
In Tableau, which of the following is used to create a calculated field that aggregates data at a different level of detail than the view?
LOD expressions enable computations at different granularities.
Why this answer
LOD (Level of Detail) expressions allow you to compute aggregates at a granularity different from the view.
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?
Correct. Reduces confusion and improves readability.
Why this answer
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.
When designing a dashboard for executives, which principle is most important to follow to ensure key information is immediately visible?
Visual hierarchy directs attention to the most critical data first.
Why this answer
Visual hierarchy ensures the most important metric is prominently placed and sized to draw attention first.
A senior data analyst is advising a team on dashboard design principles. Which THREE of the following are recommended best practices? (Choose three.)
Consistency helps users quickly interpret data.
Why this answer
Maximizing data-ink ratio, using consistent color coding, and providing clear labels and titles are established best practices. Using many colors for variety is not recommended, nor is including every possible data point to avoid clutter.
In a Power BI report, a data analyst needs to create a measure that calculates the sum of sales only for products that have a profit margin greater than 10%. Which DAX function should be used to filter the calculation?
CALCULATE changes filter context and can be used with a filter expression to sum only qualifying products.
Why this answer
CALCULATE modifies the filter context and can be combined with FILTER to apply specific conditions. SUMX iterates over a table but without CALCULATE it cannot apply the filter context properly in this scenario.
A data analyst is presenting a story about why customer churn increased last quarter. They start by showing the current churn rate, then identify a key event (a pricing change), and finally show the impact of a proposed retention campaign. This structure follows which narrative arc?
This matches the described structure.
Why this answer
The situation-complication-resolution arc sets up the current state, introduces a problem, and then presents a solution.
In Tableau, an analyst wants to create a parameter that allows users to select a threshold for highlighting products with sales above that value. The parameter is used in a calculated field that returns TRUE if sales exceed the parameter value. Which type of calculated field is this?
The calculation returns a Boolean value (TRUE/FALSE).
Why this answer
A Boolean calculated field returns TRUE or FALSE based on a condition.
A data analyst wants to show the correlation between advertising spend and website traffic. Which chart type should they use?
Scatter plots display the correlation between two variables.
Why this answer
Scatter plots are designed to show the relationship between two numerical variables.
A data analyst wants to show the sales trend for a product over the past 12 months. Which chart type is most appropriate?
Line charts effectively show trends over time.
Why this answer
A line chart is the most appropriate choice because it explicitly shows data points over a continuous time interval, making it ideal for visualizing the sales trend over 12 months. The x-axis represents time (months), and the y-axis represents sales values, allowing the audience to easily see upward, downward, or cyclical patterns. This aligns with the core principle of time-series visualization, where line charts excel at highlighting trends and changes over sequential periods.
Exam trap
The trap here is that candidates often confuse a histogram with a line chart because both use bars or lines to represent data, but a histogram is strictly for frequency distributions of continuous data, not for time-series trends.
How to eliminate wrong answers
Option B (Bar chart) is wrong because bar charts are better suited for comparing discrete categories or individual values, not for showing a continuous trend over time; they can obscure the sequential flow and make it harder to detect gradual changes. Option C (Pie chart) is wrong because pie charts display parts of a whole (proportions) at a single point in time, and they cannot represent a trend or time series across 12 months. Option D (Histogram) is wrong because histograms show the distribution of a continuous variable by binning data into intervals, not the progression of a single metric over time; using a histogram for a time series would misrepresent the data's temporal order.
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?
Funnel charts visualize sequential stages and the decreasing value at each step, ideal for conversion funnels.
Why this answer
A funnel chart is specifically designed to show progressive reduction as data moves through stages of a process.
A sales manager wants to display the contribution of each product category to total revenue, with a maximum of six categories. Which chart type is most suitable?
Pie charts effectively show proportions with few categories.
Why this answer
A pie or donut chart is ideal for part-to-whole relationships with a limited number of categories (5-7 slices).
An analyst creates a bar chart showing average sales by region. They want to ensure that the y-axis starts at zero to avoid misleading interpretation. This practice aligns with which dashboard design principle?
Starting axes at zero avoids misleading precision in bar lengths.
Why this answer
Starting the y-axis at zero is a fundamental practice to ensure that the visual representation of data (bar heights) accurately reflects the actual values, preventing exaggeration or minimization of differences. This principle directly supports 'Appropriate Precision' by maintaining the integrity of the data visualization and avoiding misleading interpretations, which is a key consideration in dashboard design.
Exam trap
Cisco often tests the distinction between design principles that affect visual perception (like axis scaling) versus those that affect layout or aesthetics, so the trap here is confusing 'Appropriate Precision' (a data integrity principle) with 'Visual Hierarchy' (a layout principle) or 'Data-Ink Ratio' (a minimalist design principle).
How to eliminate wrong answers
Option B (Visual hierarchy) is wrong because visual hierarchy refers to the arrangement of elements to guide the viewer's eye by importance (e.g., size, color, position), not to the technical scaling of axes. Option C (Clear labels and titles) is wrong because while labels and titles are crucial for context, they do not address the specific mathematical requirement of axis scaling to prevent distortion. Option D (Data-ink ratio) is wrong because data-ink ratio focuses on minimizing non-data ink (e.g., gridlines, borders) to maximize clarity, not on the starting point of the y-axis.
A data analyst is creating a dashboard for a retail company. Which TWO of the following are considered Key Performance Indicators (KPIs) tied to strategic objectives?
Revenue growth is a strategic KPI.
Why this answer
KPIs are tied to strategic goals; revenue growth and customer retention align with high-level business strategy.
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?
Correct. Annotations provide context for key events.
Why this answer
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.
Exam trap
The trap here is that candidates may choose to smooth or remove the anomaly (options B or D) to make the chart look cleaner, failing to recognize that ethical data storytelling requires explaining, not hiding, significant events.
How to eliminate wrong answers
Option B is wrong because removing the March data point distorts the dataset, hiding a legitimate event and potentially leading to incorrect trend analysis or forecasting. Option C is wrong because using a different chart type to hide the drop is deceptive and violates ethical data presentation standards, as it obscures a significant anomaly rather than explaining it. Option D is wrong because a moving average smooths out short-term fluctuations, which would mask the sharp drop and prevent the audience from recognizing the one-time disruption, defeating the purpose of anomaly explanation.
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?
Visual hierarchy arranges elements to guide the user to the most important information first.
Why this answer
Visual hierarchy ensures that the most important metrics (like underperforming regions) are prominently displayed, drawing the user's attention first.
A dashboard designer is building a sales performance dashboard for executives. According to dashboard design principles, which TWO practices should be applied? (Choose two.)
Correct. Consistent color coding helps interpretation.
Why this answer
Visual hierarchy emphasizes the most important metric, and clear labels ensure readability. Chartjunk should be minimized, not maximized.
A data analyst is presenting a story to executives about a decline in sales. The analyst wants to show the key events that led to the decline, such as a product recall and a competitor's launch. Which storytelling technique should be used?
Annotations on a line chart effectively highlight key events and their impact on trends.
Why this answer
Annotating key events on a time-series chart directly links events to data changes, helping executives understand causes.
A data analyst wants to show the proportion of total sales for each product category. There are 4 categories. Which chart type is most appropriate?
Pie charts effectively show proportions for a small number of categories.
Why this answer
Pie charts are suitable for showing part-to-whole relationships when there are a limited number of categories (5-7 or fewer).
A marketing manager wants to visualize the conversion funnel from website visits to final purchase. Which chart type is most appropriate?
Funnel charts are ideal for visualizing conversion funnels.
Why this answer
Funnel charts are specifically designed to show stages in a pipeline or conversion process, with decreasing values as prospects move through the funnel.
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?
Correct. Histograms show the distribution of a continuous variable.
Why this answer
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.
A data analyst needs to visualize the distribution of customer ages in a dataset containing 10,000 records. The analyst wants to see the shape of the distribution and identify any outliers. Which chart type is most appropriate?
Histograms display distribution of continuous data and can show outliers.
Why this answer
A histogram shows the distribution of a continuous variable and can reveal shape and outliers when bins are appropriately sized.
An analyst is creating a Tableau dashboard for a logistics company. They need to allow users to filter data by region and time period, and also want to show a tooltip with detailed shipment information. Which THREE Tableau features should be used? (Choose three.)
Correct. Tooltips can show detailed information on hover.
Why this answer
Parameters allow user input for filtering, dashboard actions enable interactions across sheets, and tooltips display details on hover. Calculated fields are for custom calculations, and marks are for visual encoding.
Which chart type is best for displaying the distribution of a continuous variable, such as the age distribution of customers?
Histograms show the distribution of a continuous variable by binning data.
Why this answer
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.
Exam trap
Cisco often tests the distinction between a histogram and a bar chart, where candidates mistakenly choose a bar chart (not listed here) or a box plot because they confuse 'distribution' with 'summary statistics' or 'categorical comparison'.
How to eliminate wrong answers
Option A is wrong because a box plot summarizes the distribution using five-number summary statistics (min, Q1, median, Q3, max) and highlights outliers, but it does not show the detailed shape or modality of the distribution as a histogram does. Option B is wrong because a line chart is designed to show trends over time or ordered categories by connecting data points, not to display the frequency distribution of a single continuous variable. Option D is wrong because a pie chart is used to show proportions of a whole for categorical data, and it cannot represent the distribution of a continuous variable like age.
In Looker Studio, a data analyst has two data sources: one with customer IDs and transactions, and another with customer demographics. They need to create a chart that includes fields from both sources. Which feature should they use?
Blending merges data from different sources based on a key.
Why this answer
Data blending in Looker Studio allows you to combine data from two or more separate data sources based on a common key (e.g., customer ID). This enables you to create a chart that uses fields from both the transactions source and the demographics source without needing to merge the data at the database level. Without blending, a single chart can only reference fields from one data source at a time.
Exam trap
The trap here is that candidates often confuse data blending with calculated fields, thinking a formula can reference fields from another source, but Looker Studio restricts calculated fields to operate only within a single data source.
How to eliminate wrong answers
Option B is wrong because calculated fields create new fields within a single data source using formulas, but they cannot pull in fields from a second, unrelated data source. Option C is wrong because community connectors are used to connect to external data sources (e.g., APIs), not to combine data from two already-connected sources within a report. Option D is wrong because dashboard filters control which data is displayed across charts, but they do not merge or join fields from different data sources into a single chart.
A business analyst is asked to distinguish between KPIs and metrics for a new dashboard. According to CompTIA Data+, which TWO statements correctly differentiate KPIs from metrics? (Choose two.)
Correct. KPIs measure progress toward strategic goals.
Why this answer
KPIs are tied to strategic objectives and are often leading or lagging indicators. Metrics are operational measurements that may support KPIs but are not necessarily strategic.
A data analyst wants to visualize the distribution of customer ages, including quartiles and potential outliers, for a dataset with 10,000 records. Which TWO chart types are appropriate? (Choose two.)
Box plots display median, quartiles, and outliers.
Why this answer
Box plots explicitly show quartiles and outliers. Histograms show distribution shape and can reveal outliers, but they don't directly show quartiles. However, both can be used to understand distribution and identify outliers.
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?
Waterfall charts illustrate incremental changes leading to a final total.
Why this answer
A waterfall chart shows how an initial value is affected by a series of positive and negative changes, making it ideal for financial breakdowns.
A dashboard designer wants to ensure that the most important metric, such as total revenue, is prominently displayed at the top left. Which dashboard design principle is being applied?
Visual hierarchy emphasizes the most important information first.
Why this answer
Visual hierarchy arranges elements by importance, typically with key metrics at the top or top-left.
A BI analyst is creating a report in Power BI and needs to calculate the total sales for the current year compared to the previous year. Which DAX function should be used to calculate the previous year's sales?
SAMEPERIODLASTYEAR returns dates from the previous year for the same period.
Why this answer
SAMEPERIODLASTYEAR returns a set of dates in the previous year for the same period, which is ideal for year-over-year comparisons.
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?
Customer retention is a key strategic metric.
Why this answer
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.
Exam trap
The trap here is that candidates often confuse operational metrics (like average time to close a deal) with KPIs because they both appear in sales dashboards, but KPIs must directly measure strategic outcomes rather than process efficiency.
In Looker Studio, you have a data source with daily sales and a separate data source with marketing spend. You want to create a chart that shows sales and marketing spend on the same axis, but the two sources are not joined natively. Which feature should you use to combine them?
Blending allows combining multiple data sources in a single chart.
Why this answer
Data blending in Looker Studio allows you to combine data from multiple sources based on a common dimension without requiring a native join.
A data analyst is creating a dashboard in Looker Studio and needs to combine data from two different data sources using a common field. Which feature should be used?
Blending is used to combine data from multiple sources in Looker Studio.
Why this answer
Blending in Looker Studio allows combining data from different sources based on a common dimension, similar to a left join.
Which chart type is best for visualizing the correlation between two continuous variables?
Scatter plots are designed to show correlation between two continuous variables.
Why this answer
Scatter plots show the relationship between two continuous variables, making them ideal for visualizing correlation.
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?
Correct. LOD expressions can compute per-customer counts and then be used in a filter.
Why this answer
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.
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?
Correct. COUNT_DISTINCT is a metric.
Why this answer
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.
Exam trap
The trap here is that candidates often confuse a dimension with a metric because they think 'customer' is a category (dimension), but the question specifically asks for a count of unique customers, which requires an aggregation, making it a metric.
How to eliminate wrong answers
Option A is wrong because a dimension is a field used to categorize, group, or filter data (e.g., customer name or month), not to perform aggregations like counting unique customers. Option B is wrong because a parameter is a user-defined input value that can be used to filter or modify queries dynamically, but it does not itself perform any aggregation or count. Option D is wrong because a blend is a technique to combine data from multiple sources or tables, not a field type that can directly count unique customers per month.
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?
Correct. Bar charts are best for comparing values across categories.
Why this answer
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.
A data analyst is building a dashboard in Tableau and wants to allow users to select a specific product category and have all charts on the dashboard filter to that category. Which Tableau feature should be used?
Dashboard actions enable cross-sheet filtering.
Why this answer
Dashboard actions in Tableau enable interactivity such as filtering across sheets based on user clicks.
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?
CALCULATE modifies the filter context, and FILTER combined with SAMEPERIODLASTYEAR identifies products with prior year sales.
Why this answer
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.
Which chart type is best for showing the sales pipeline from leads to closed deals, illustrating how many prospects drop off at each stage?
Funnel charts visualize pipeline stages and conversion.
Why this answer
A funnel chart is specifically designed to show conversion or drop-off rates in a pipeline.
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?
This computes total sales per region ignoring other dimensions.
Why this answer
A Level of Detail (LOD) expression with FIXED can compute a value at the region level, ignoring other dimensions like year.
A dashboard should be designed so that the most important metric is prominently displayed. This is an example of which design principle?
Visual hierarchy arranges elements by importance.
Why this answer
Visual hierarchy is the design principle that dictates arranging elements to guide the viewer's eye to the most important information first. By making the key metric the most prominent element (e.g., larger, bolder, or top-left), the dashboard ensures immediate comprehension of the primary data point, which is critical for operational decision-making.
Exam trap
Cisco often tests visual hierarchy by presenting it alongside data-ink ratio, as candidates may confuse 'making a metric prominent' with 'reducing non-data ink,' but the former is about emphasis while the latter is about eliminating visual clutter.
How to eliminate wrong answers
Option A is wrong because the data-ink ratio focuses on minimizing non-data ink (e.g., gridlines, borders) to maximize the proportion of ink used for actual data, not on emphasizing a specific metric. Option B is wrong because consistent color coding ensures that the same color represents the same category across visualizations, aiding comparison, but it does not inherently prioritize one metric over others. Option C is wrong because appropriate precision refers to displaying data with the correct level of detail (e.g., rounding to whole numbers when decimals are unnecessary), not to the visual prominence of a metric.
A data analyst is designing a dashboard for executives to monitor company performance. Which THREE practices should the analyst follow to ensure effective storytelling with data? (Select three.)
Annotations highlight important points in the story.
Why this answer
Effective data storytelling includes a narrative arc, choosing the right chart, and annotating key events.
A data analyst is creating a dashboard for a sales team. Which TWO actions adhere to dashboard design best practices?
Consistent color coding helps users quickly interpret charts and maintain visual coherence, which is a best practice.
Why this answer
Using consistent color coding and placing the most important metric prominently are best practices. Using many bright colors and 3D effects are not.
Which of the following is a key performance indicator (KPI) tied to a strategic objective, as opposed to a metric?
CSAT can be a KPI if tied to strategic objective of improving customer experience.
Why this answer
Option B is correct because a key performance indicator (KPI) is a measurable value that demonstrates how effectively a company is achieving a key strategic objective. Here, 'Customer satisfaction score (CSAT) as a strategic goal' explicitly ties the metric to a strategic objective (e.g., improving customer loyalty), whereas a plain metric like 'average handle time' is an operational measure without a direct strategic link. In data visualization, KPIs are often displayed on dashboards with targets and thresholds to track progress toward high-level business goals.
Exam trap
The trap here is that candidates confuse any measurable value (metric) with a key performance indicator (KPI), failing to recognize that a KPI must be explicitly tied to a strategic objective, not just any operational or technical measurement.
How to eliminate wrong answers
Option A is wrong because average handle time is an operational metric that measures efficiency in a call center, not a KPI tied to a strategic objective; it lacks a direct connection to a broader business goal. Option C is wrong because number of daily logins is a vanity metric that tracks user activity but does not inherently reflect progress toward a strategic objective like revenue growth or customer retention. Option D is wrong because server uptime percentage is a technical metric for system reliability, not a KPI linked to a strategic objective unless explicitly framed as part of a service-level agreement (SLA) goal tied to business continuity.
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?
Waterfall charts illustrate the step-by-step progression from starting to ending value, perfect for financial breakdowns.
Why this answer
A waterfall chart effectively shows how each incremental positive or negative value contributes to a final total, making it ideal for profit/loss breakdowns.
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?
Correct. TOTALYTD computes the year-to-date total.
Why this answer
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).
Which of the following is a key difference between a Key Performance Indicator (KPI) and a metric?
Correct. KPIs are a subset of metrics that are critical to strategic success.
Why this answer
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.
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?
Correct. An area chart, especially stacked, shows cumulative trends over time.
Why this answer
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.
Exam trap
The trap here is that candidates often confuse a stacked bar chart with an area chart, thinking that stacking bars shows cumulative effect, but the area chart's continuous fill better represents the cumulative flow over time, which is the key requirement in the question.
How to eliminate wrong answers
Option A is wrong because a line chart only shows the trend of individual data points over time without any visual stacking or cumulative effect, so it cannot highlight the total contribution of each month stacked on top of previous months. Option B is wrong because a stacked bar chart shows parts of a whole at discrete time points but does not inherently emphasize the cumulative effect over time as a continuous flow, and it is less effective for showing the progression of cumulative totals across many months. Option D is wrong because a waterfall chart is designed to show incremental changes (additions and subtractions) from a starting value to an ending value, not to display a continuous cumulative stack of monthly contributions over a five-year period.
An analyst is creating a report in Power BI and needs to calculate year-to-date total sales compared to the same period last year. Which TWO DAX functions should be used? (Choose two.)
Correct. SAMEPERIODLASTYEAR shifts dates back one year.
Why this answer
TOTALYTD computes year-to-date, and SAMEPERIODLASTYEAR shifts context to the prior year. CALCULATE modifies filter context, often used with time intelligence.
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?
Scatter plots show correlation, and color adds a third dimension.
Why this answer
A scatter plot with color-coded categories effectively shows relationships between two continuous variables and a third categorical dimension.
In a Power BI report, a user wants to create a measure that calculates total sales for the current year up to today. Which DAX function should they use?
TOTALYTD calculates year-to-date values correctly.
Why this answer
TOTALYTD is a time intelligence function that calculates year-to-date values.
Which TWO are examples of leading indicators in a business context? (Select two.)
Engagement often predicts future retention and sales.
Why this answer
Leading indicators predict future performance; number of qualified leads and customer engagement score forecast future sales.
A data analyst needs to display the distribution of customer ages in a dataset containing 10,000 records. Which TWO chart types are appropriate? (Choose two.)
Correct. Box plots show distribution, median, quartiles, and outliers.
Why this answer
Histograms show distribution of a continuous variable, and box plots show distribution with quartiles and outliers. Pie charts and bar charts are not for distribution.
A dashboard designer wants to maximize the data-ink ratio. Which action should they take?
Removing non-data ink improves the data-ink ratio.
Why this answer
Data-ink ratio is maximized by removing non-data ink (chartjunk) like unnecessary gridlines and borders.
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?
Correct. Total revenue is a direct measure of the strategic goal.
Why this answer
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.
Exam trap
The trap here is that candidates often confuse input metrics (like number of new leads) or efficiency metrics (like average deal size) with KPIs, failing to recognize that KPIs must directly measure progress toward the specific strategic goal, which in this case is increasing revenue.
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?
Correct. This ensures the slicer filters the desired visuals, especially if interactions were previously changed.
Why this answer
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.
A data analyst needs to visualize the distribution of salaries across departments and also compare the median and identify outliers. Which chart type is most suitable?
Box plots show median, quartiles, and outliers, and are great for comparing across groups.
Why this answer
Box plots display median, quartiles, and outliers, making them ideal for comparing distributions across categories.
A dashboard designer wants to ensure the most important KPI is prominently displayed at the top left. Which design principle is being applied?
Visual hierarchy organizes elements by importance.
Why this answer
Visual hierarchy arranges elements by importance, typically placing the most critical information where the eye naturally starts (top left in Western cultures).
Which chart type is best for showing the distribution of a continuous variable, such as customer ages?
Histograms display the distribution of a continuous variable.
Why this answer
A histogram is the correct choice because it groups continuous data (like customer ages) into bins along a continuous x-axis, displaying the frequency distribution through bar heights. This directly shows the shape, spread, and central tendency of the variable, which is the core requirement for visualizing a continuous distribution.
Exam trap
The trap here is that candidates often confuse a histogram with a bar chart, thinking both use bars for 'counts,' but fail to recognize that histograms require continuous numeric bins with no gaps, while bar charts use categorical labels with gaps.
How to eliminate wrong answers
Option A is wrong because a bar chart is designed for categorical (discrete) data, where each bar represents a distinct category with gaps between bars; using it for continuous ages would incorrectly treat age values as separate categories, losing the distribution's continuity. Option B is wrong because a pie chart shows proportions of a whole for categorical data, not the distribution of a continuous variable; it cannot convey the spread, skew, or modality of ages. Option C is wrong because a box plot summarizes distribution through quartiles and outliers but does not show the detailed shape (e.g., multimodality) that a histogram reveals; it is better for comparing distributions than for displaying the full distribution of a single continuous variable.
A marketing analyst wants to visualize the conversion funnel from website visitors to paying customers. Which TWO chart types are suitable for showing this pipeline? (Choose two.)
Correct. Funnel charts are purpose-built for conversion pipelines.
Why this answer
Funnel charts are designed for pipeline/conversion. Waterfall charts show incremental changes, which can also represent funnel stages. Scatter plots and bar charts are not ideal for funnel visualization.
A data analyst is building a narrative around a quarterly sales decline. The story should follow a narrative arc. Which THREE elements should be included in the story?
Resolution shows how the issue was addressed.
Why this answer
A narrative arc in data storytelling typically includes situation (context), complication (problem), and resolution (recommendation or action).
An analyst needs to show the part-to-whole relationship of market share among four competitors. Which chart type is most appropriate, considering best practices?
Pie charts effectively show proportions with a limited number of categories.
Why this answer
A pie or donut chart is suitable for part-to-whole with few categories (5-7 slices max). Here, four competitors fit well.
In Power BI, a developer needs to create a measure that calculates total sales for the same period last year. Which DAX function should be used?
This function returns the same date range from the previous year.
Why this answer
SAMEPERIODLASTYEAR is a time intelligence function that returns dates from the previous year.
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?
Table calculations can compute running total and date comparison (e.g., PREVIOUS_VALUE) easily.
Why this answer
Tableau's table calculations can compute running totals and year-over-year comparisons without modifying the data source.
A data analyst wants to visualize the monthly sales trend for the past year. Which chart type is most appropriate?
Line charts effectively display trends over time.
Why this answer
Line charts are best for showing trends over time.
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?
Small multiples facilitate comparison while maintaining clarity.
Why this answer
Small multiples (trellis charts) allow comparison of multiple time series in a compact, consistent layout, making it easy to spot trends across regions.
Ready to test yourself?
Try a timed practice session using only Dap Visualising Data questions.