75 of 240 questions · Page 3/4 · Visualization and Reporting · Answers revealed
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 scatter plot of advertising spend vs. revenue shows no clear correlation, but the analyst suspects a relationship exists. Which addition to the plot could help reveal a hidden trend?
A trendline helps model and visualize the underlying relationship.
Why this answer
Adding a trendline (e.g., linear regression) can reveal underlying patterns in noisy scatter plot data, making it easier to see correlations that are not immediately obvious from the raw points alone. Other options like changing to a bar chart, increasing marker size, or removing data points would not help reveal a hidden trend and may obscure the data.
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.
Which TWO are best practices for designing effective dashboards? (Select exactly two.)
A single page allows immediate overview.
Why this answer
Options D and E are correct. A single-page dashboard (D) allows users to see key information at a glance without scrolling, improving efficiency. A consistent color scheme (E) reduces cognitive load and makes the dashboard easier to interpret.
Option A (3D charts) is discouraged because 3D effects can distort data perception and add visual clutter. Option B (pie charts) can be used for parts of a whole, but it is not a universal best practice; they become hard to compare with many categories. Option C (including every metric) leads to information overload and reduces the dashboard's effectiveness.
A data analyst is reviewing the quality of a sales report before publishing. Which THREE elements should the analyst include to ensure report quality?
Indicates how current the data is.
Why this answer
Report quality includes documenting when data was last updated, any limitations or assumptions, and the source of the data to ensure transparency and reliability.
An analyst creates a dashboard with multiple visualizations. Which feature allows users to change the data displayed across all charts simultaneously?
Filters and slicers allow users to interactively change the data displayed on multiple charts.
Why this answer
A filter or slicer can be applied to multiple visualizations on a dashboard, allowing users to change the data displayed across all charts simultaneously. Option A (Linked chart) is not a standard feature for simultaneous filtering. Option B (Drill-down) enables exploring hierarchical data but does not affect multiple charts at once.
Option D (Data segmentation) typically refers to dividing data into groups, not a cross-chart filtering mechanism.
A sales manager receives a daily report at 8 AM via email showing yesterday's sales by region. This is an example of which report type?
Scheduled reports are automated and delivered on a fixed schedule.
Why this answer
The report is automatically delivered on a regular schedule, which defines a scheduled report.
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.
Which TWO of the following are leading indicators that can help predict future performance?
Increased traffic may lead to more sales.
Why this answer
Leading indicators predict future outcomes; website traffic and number of qualified leads are forward-looking.
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?
Product category is a dimension, average order value is a metric, and date range control allows filtering.
Why this answer
In Looker Studio, dimensions are fields like product category, metrics are aggregations like average order value, and date range controls provide filtering.
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?
Can show relationship between time of day and wait time.
Why this answer
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.
Which TWO chart types are best suited to show the proportion of total sales contributed by each product category? (Select exactly two.)
Stacked bars show composition across categories.
Why this answer
Options C and D are correct. Pie charts and stacked bar charts effectively show parts of a whole. Line charts show trends; scatter plots show relationships; histograms show distributions.
A data analyst is building a Power BI report to track KPIs for a retail chain. Which TWO of the following are considered leading indicators? (Choose two.)
High satisfaction often leads to repeat purchases and referrals.
Why this answer
Leading indicators predict future performance. Number of website visits and customer satisfaction score can foreshadow future sales, whereas total sales and profit margin are lagging indicators. Employee count is operational but not typically leading.
A marketing team wants to compare the growth rates of four product categories over the last quarter. Which chart type would best display this?
Bar charts effectively compare discrete values like growth percentages.
Why this answer
A bar chart is ideal for comparing discrete values across categories, such as the growth rates of four product categories. It allows for easy visual comparison of the heights of the bars. Option A (pie chart) is unsuitable for comparing growth rates as it shows proportions of a whole, not rates.
Option B (stacked bar chart) would show cumulative totals, not individual growth rates. Option C (line chart) is better for trends over time, not for comparing discrete categories.
When communicating uncertainty in a report, which of the following is the most appropriate way to convey the reliability of a survey result showing 75% customer satisfaction?
Provides a confidence interval, clearly expressing uncertainty.
Why this answer
Confidence intervals are standard for communicating uncertainty around a point estimate.
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?
Makes the dashboard easy to understand at a glance.
Why this answer
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.
A sales dashboard shows a map with many overlapping markers in the same city, making it hard to read. What is the best improvement?
Aggregating reduces density and choropleth shows region-level values.
Why this answer
Aggregating sales data by region and using a choropleth map eliminates visual clutter from overlapping markers by shading entire geographic areas based on a metric (e.g., total sales). This approach leverages spatial aggregation to provide a clear, high-level view of regional performance, which is the best practice when individual point markers become unreadable due to density.
Exam trap
The trap here is that candidates may choose tooltips (Option A) thinking interactivity solves the problem, but the question asks for the 'best improvement' to readability, and tooltips do not address the fundamental issue of overlapping markers obscuring the visualization.
How to eliminate wrong answers
Option A is wrong because tooltips only provide details on hover and do not solve the core problem of overlapping markers obscuring data; they add interactivity but do not reduce visual density. Option C is wrong because a bubble chart, while useful for comparing values, is not a map-based visualization and would lose the geographic context that the dashboard intends to convey. Option D is wrong because using different marker colors for each store does not address overlapping markers; it only adds visual differentiation without reducing clutter, and in dense areas, colored markers still overlap and remain unreadable.
Which chart type is best for showing the number of website visitors at each stage of a conversion funnel, from initial visit to purchase?
Correct. Funnel charts are ideal for conversion funnels.
Why this answer
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.
Exam trap
The trap here is that candidates often confuse a funnel chart with a waterfall chart because both show sequential steps, but a waterfall chart is for cumulative changes (additions/subtractions), not for displaying the count at each stage of a funnel.
How to eliminate wrong answers
Option A is wrong because a stacked bar chart is used to compare parts of a whole across categories, not to show the sequential reduction in a funnel; it would obscure the drop-off between stages. Option B is wrong because a treemap displays hierarchical data as nested rectangles based on proportion, which is not suitable for a linear, sequential process like a conversion funnel. Option D is wrong because a waterfall chart is designed to show the cumulative effect of sequential positive and negative values (e.g., financial statements), not the simple count of visitors at each stage of a funnel.
A data analyst is preparing a report on customer satisfaction scores. To comply with GDPR, which THREE actions must be taken? (Select THREE.)
Correct. Aggregates must be safe from re-identification.
Why this answer
GDPR requires anonymization of PII, ensuring aggregate data does not allow re-identification, and respecting data retention policies.
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?
This structure effectively sets the context, presents the problem, and offers a solution.
Why this answer
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.
Exam trap
The CompTIA Data+ exam often tests the distinction between narrative structures for different audiences; the trap here is that candidates mistake 'Background, Analysis, Recommendation' (a common technical report format) as appropriate for executives, when in fact it lacks the persuasive arc needed for strategic decision-making.
How to eliminate wrong answers
Option A is wrong because 'Problem, Hypothesis, Test' is a scientific method structure used for experimental validation, not for presenting a business narrative to executives. Option B is wrong because 'Background, Analysis, Recommendation' is a linear report format that lacks the dramatic tension needed to engage an executive audience on a problem like churn. Option D is wrong because 'Data, Visualization, Conclusion' is a data-centric sequence that prioritizes outputs over storytelling, failing to frame the business impact and resolution in a compelling way.
A data analyst needs to compare the salary distribution across five departments. Which visualization is most appropriate?
Box plots display distribution statistics for each group.
Why this answer
A side-by-side box plot (option B) is the most appropriate visualization for comparing salary distributions across multiple departments because it displays the median, quartiles, and potential outliers for each group simultaneously. This allows the analyst to assess central tendency, spread, and skewness across all five departments in a single, compact chart.
Exam trap
The trap here is that candidates often confuse 'comparing distributions' with 'showing trends' or 'showing relationships,' leading them to incorrectly select a line chart or scatter plot instead of recognizing that a box plot is purpose-built for distribution comparison across groups.
How to eliminate wrong answers
Option A is wrong because a line chart is designed to show trends over a continuous interval (e.g., time series) and is not suitable for comparing distributions of categorical groups like departments. Option C is wrong because a scatter plot visualizes the relationship between two continuous variables, not the distribution of a single variable across categories. Option D is wrong because a stacked bar chart is used to show the composition of parts to a whole across categories, not the distribution (e.g., quartiles, outliers) of a continuous variable like salary.
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?
Bar charts compare categories easily.
Why this answer
A bar chart is ideal for comparing discrete categories across a single metric like sales revenue.
A sales VP wants a quick summary of last month's revenue change and key drivers. Which report section is most relevant?
Correct. Executive summary gives headline and context.
Why this answer
Executive summaries provide high-level numbers and context for quick decision-making.
An analyst needs to create a report in Power BI that shows year-to-date sales compared to the same period last year, with the ability to drill down from year to quarter. Which DAX function combination is most appropriate for the year-to-date calculation?
These time intelligence functions compute YTD and compare to the same period last year.
Why this answer
TOTALYTD calculates year-to-date values, and SAMEPERIODLASTYEAR shifts the comparison to the prior year. Together they allow YTD vs prior YTD comparison.
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?
Correct. Visual hierarchy guides the viewer's eye to the most important metric first.
Why this answer
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.
A marketing team wants to explore the relationship between advertising spend (in dollars) and resulting revenue. Which chart type is most suitable?
Scatter plot displays relationship between two numerical variables.
Why this answer
Scatter plots reveal correlation and distribution of two continuous variables.
A data analyst wants to show the relationship between advertising spend and sales revenue for 50 stores. Which chart type is most appropriate?
Scatter plots show the relationship between two continuous variables.
Why this answer
A scatter plot is the most appropriate chart for showing the relationship between two continuous variables—advertising spend and sales revenue—across 50 stores. Each point on the plot represents one store, allowing the analyst to visually assess correlation, trends, or outliers. This aligns with the DA0-001 objective of selecting visualizations that best represent bivariate relationships.
Exam trap
The trap here is that candidates often confuse a line chart (which connects points in sequence) with a scatter plot (which treats points as independent observations), leading them to incorrectly choose a line chart when no temporal or ordered dimension exists.
How to eliminate wrong answers
Option A is wrong because a line chart is typically used to display trends over time or ordered categories, not to show the relationship between two independent continuous variables like advertising spend and sales revenue. Option C is wrong because a bar chart compares discrete categories or groups, not the correlation between two continuous metrics across 50 individual stores. Option D is wrong because a pie chart shows proportions of a whole for categorical data, which is irrelevant for analyzing the relationship between two numerical variables.
An analyst is choosing a chart to show the correlation between two continuous variables. Which TWO chart types could be used? (Select two.)
Bubble charts are scatter plots with a third variable; they also show correlation.
Why this answer
A bubble chart is an extension of a scatter plot that can show the correlation between two continuous variables on the x- and y-axes, while a third variable is represented by the size of the bubbles. For the specific purpose of showing correlation between exactly two continuous variables, the bubble chart is valid because the bubble size is optional and does not interfere with the primary x-y relationship. This makes it a correct choice for visualizing the relationship between two continuous variables.
Exam trap
A common misconception in data visualization is that a histogram can show relationships between two variables, but it only displays the frequency distribution of a single continuous variable. For the Data+ exam, remember that scatter plots and bubble charts are appropriate for showing correlation between two continuous variables.
A marketing team conducted a customer satisfaction survey for five different departments (Sales, Support, Billing, Shipping, Returns). The survey asked customers to rate their satisfaction on a scale of 1 (Very Dissatisfied) to 5 (Very Satisfied). The data is ordinal and the team wants to visualize the distribution of responses for each department to quickly see which department has the most 'Very Satisfied' customers and which has the most 'Very Dissatisfied'. They also want to compare the spread of responses across departments. Which chart type should they use?
Stacked bars show the full distribution of ordinal responses, highlighting proportions of top and bottom ratings.
Why this answer
The stacked bar chart, is correct because it displays the distribution of ordinal satisfaction ratings for each department, allowing easy comparison of counts for each rating category. With departments on the x-axis and stacked segments for ratings 1-5, the team can quickly identify which department has the most 'Very Satisfied' (rating 5) and 'Very Dissatisfied' (rating 1). The stacked bars also reveal the spread of responses across departments.
Option C (box plot) is less suitable because it assumes continuous interval data and does not show exact counts of each ordinal category. Option B (line chart) is for trends over a continuous axis, not categorical comparisons of distributions. Option D (scatter plot) is for relationships between two continuous variables, not for comparing response distributions.
Refer to the exhibit. A stakeholder complains that the line chart exaggerates the changes in sales. What is the most likely cause?
Starting at a non-zero value exaggerates differences.
Why this answer
Setting beginAtZero to false truncates the y-axis, making small changes appear larger.
In Looker Studio, what is the difference between dimensions and metrics?
This matches Looker Studio terminology.
Why this answer
In Looker Studio, dimensions are fields that contain categorical data (e.g., text, dates, or geographic names) used to group and segment data, while metrics are numerical fields (e.g., counts, sums, averages) that can be aggregated. Option D is correct because this distinction is fundamental to how Looker Studio processes and visualizes data: dimensions define the rows or categories in a chart, and metrics provide the quantitative values to be measured.
Exam trap
The trap here is that candidates often confuse the general data types (numeric vs. string) with the semantic roles in Looker Studio, leading them to choose option C, but the exam expects you to know that dimensions are always used for grouping (categorical) and metrics for aggregation (numerical) in the context of this tool.
How to eliminate wrong answers
Option A is wrong because it reverses the roles: dimensions are used for grouping and segmenting data, not aggregation, while metrics are the fields that are aggregated (e.g., SUM, COUNT, AVG). Option B is wrong because it incorrectly states that dimensions are numerical and metrics are categorical; in reality, dimensions are typically categorical (text, date, boolean) and metrics are numerical. Option C is wrong because while both can technically be categorical or numerical in raw data, Looker Studio enforces a strict semantic distinction: dimensions are treated as grouping keys (categorical) and metrics as aggregatable values (numerical), and mixing them leads to incorrect chart behavior.
A sales manager wants to see the conversion rates at each stage of the sales pipeline, from initial contact to closed deal. Which chart type is most appropriate?
Funnel charts visualize pipeline stages and conversion.
Why this answer
A funnel chart is designed to show progressive reductions as stages narrow.
A sales analyst wants to show total sales by product category, with each category's contribution to the total. Which chart type is best?
Stacked bars show total and composition.
Why this answer
A stacked bar chart shows both the total and the part-to-whole breakdown by category.
A dashboard designer wants to highlight the sales performance of individual sales representatives compared to team averages. Which chart type is most suitable for this comparison?
Bar chart allows easy comparison of each rep's sales to the average line.
Why this answer
A bar chart with an average line is ideal for comparing individual sales representatives' performance to the team average because each bar clearly shows the magnitude of each value, and the average line provides a reference for comparison. This makes it easy to see who is above or below average. In contrast, a scatter plot (A) is used for correlation between two variables, a pie chart (C) shows proportions of a whole, and a line chart (D) shows trends over time, none of which directly compare individual values to an average.
An analyst is presenting a recommendation to increase marketing spend. Which statement best follows the data-driven recommendation structure (evidence → insight → recommendation → expected impact)?
This includes evidence, insight, recommendation, and expected impact.
Why this answer
The correct structure provides evidence, insight derived from it, a recommendation, and the expected impact.
Which THREE are best practices for designing a dashboard for executive consumption?
Executives often view dashboards on tablets or phones.
Why this answer
Options B, D, and E are correct. For executive dashboards, mobile responsiveness (B) ensures accessibility on any device, interactive filters (D) allow executives to drill down into time periods and regions, and displaying critical KPIs at the top (E) highlights key insights. Option A is incorrect because executives need summarized, not raw, data.
Option C is incorrect because separate charts for each metric can create clutter; instead, use combined or summary visualizations.
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?
A scatter plot maps advertising spend on the x-axis and website visits on the y-axis, plotting each observation as an individual point to reveal the correlation between two continuous variables. This directly satisfies the stem’s constraint that both variables are continuous, as scatter plots are the standard chart type for visualising relationships between two quantitative measures.
Why this answer
Scatter plots are ideal for visualizing the correlation between two continuous variables.
A financial analyst is creating a quarterly report compliant with SOX. Which requirement is most critical for the report's audit trail?
Correct. SOX mandates audit trails for financial reports.
Why this answer
SOX requires audit trails to track changes and ensure data integrity for financial reports.
A sales analyst is building a report to analyze quarterly performance. Which THREE are appropriate uses of a formula language or a data transformation tool? (Select three.)
Power Query is ideal for data cleaning and transformation.
Why this answer
Data transformation tools are specifically designed for data cleaning and preparation tasks, such as removing duplicate rows from a data source before the data is loaded into the analysis model. This is a standard ETL operation that such tools handle efficiently using their deduplication features, which is not a function of a formula language.
Exam trap
Vendor-neutral exams often test the distinction between data transformation tools and data analysis functions, leading candidates to mistakenly think that analysis functions like iterative summations can perform data cleaning tasks, when in fact they are for analytical calculations within the data model.
Which TWO chart types are appropriate for visualizing the distribution of a continuous variable? (Select two.)
Box plots show quartiles, median, and outliers.
Why this answer
A box plot (B) is appropriate for visualizing the distribution of a continuous variable because it displays the median, quartiles, and potential outliers, providing a five-number summary of the data. A histogram (D) is also appropriate as it groups continuous data into bins and shows the frequency distribution, revealing the shape, central tendency, and spread of the variable.
Exam trap
The trap here is that candidates often confuse a bar chart with a histogram, thinking both can show distribution, but a bar chart is for categorical data while a histogram is specifically for continuous data with no gaps between bars.
A data analyst is designing a dashboard and wants to maximize the data-ink ratio. Which action aligns with this principle?
Removing unnecessary gridlines reduces non-data ink and improves the data-ink ratio.
Why this answer
Data-ink ratio focuses on removing non-data ink (chartjunk) and emphasizing data. Using minimal gridlines reduces non-data ink.
A data analyst is presenting a story about declining sales. The narrative arc should include which three elements in order?
This is the standard narrative arc.
Why this answer
A compelling data story about declining sales follows the classic narrative arc: Situation (establish context, e.g., 'Sales were steady in Q1'), Complication (introduce the conflict, e.g., 'Then a 20% drop occurred in Q2'), and Resolution (present the insight or action, e.g., 'We identified the cause and implemented a new pricing strategy'). This order mirrors the 'Situation-Complication-Resolution' framework used in data storytelling to guide the audience logically from context to problem to solution.
Exam trap
The trap here is that candidates often confuse the narrative order with a simple 'problem-solution' structure, mistakenly placing Complication first (Option D) or skipping the Situation entirely, but the exam requires the full Situation → Complication → Resolution sequence to ensure a complete and logical data story.
How to eliminate wrong answers
Option A is wrong because starting with Resolution (the solution) before establishing the Situation or Complication confuses the audience; they need context first to understand why the resolution matters. Option C is wrong because placing Resolution before Complication skips the core conflict that drives the narrative, making the story feel incomplete and the resolution unsupported. Option D is wrong because beginning with Complication without first setting the Situation leaves the audience without necessary background, making the problem seem arbitrary or disconnected from the data.
A data analyst is creating a dashboard and wants to maximize the data-ink ratio. Which action supports this principle?
This removes redundant ink and focuses on data.
Why this answer
Removing unnecessary gridlines and decorative elements reduces non-data ink, thereby increasing the data-ink ratio. The data-ink ratio is the proportion of ink used to display data versus total ink used in the chart.
A retail analyst wants to visualize monthly sales over the past year to identify seasonal patterns. Which chart type is best?
Line chart clearly shows trends and seasonal patterns over time.
Why this answer
A line chart is best for visualizing monthly sales over time because it explicitly shows trends and seasonal patterns across a continuous time axis. The sequential ordering of months allows the line to connect data points, making it easy to identify peaks, troughs, and recurring cycles. This aligns with the DA0-001 objective of selecting appropriate visualizations for time-series data.
Exam trap
The trap here is that candidates confuse a histogram with a line chart because both use bars or lines, but a histogram bins continuous data without regard to order, while a line chart requires a sequential axis like time to show trends.
How to eliminate wrong answers
Option A is wrong because a pie chart is designed to show parts of a whole at a single point in time, not trends across multiple time periods; it cannot convey seasonal patterns or month-over-month changes. Option B is wrong because a histogram displays the distribution of a continuous variable by binning values, but it does not preserve the temporal order of months, making it impossible to identify seasonal patterns. Option D is wrong because a box plot summarizes data distribution (median, quartiles, outliers) for one or more groups, but it lacks a time axis and cannot show the sequential progression of sales across months.
Which THREE factors should be considered when choosing a chart type for a dataset?
Data type determines suitable chart types.
Why this answer
The data type (categorical, numerical, time series) determines which chart types are semantically valid. For example, a line chart requires a continuous numerical or time-series axis, while a bar chart works with categorical data. Choosing a chart that mismatches the data type can misrepresent the underlying distribution or trends.
Exam trap
The trap here is that candidates often confuse aesthetic or software-specific features (like animation or branding) with the fundamental data characteristics that dictate chart appropriateness, leading them to select options that are about polish rather than analytical correctness.
A data scientist creates a box plot of employee salaries and notices many outliers above the upper whisker. What action should be taken to best understand the salary distribution?
Outliers should be investigated to ensure data quality and contextual understanding.
Why this answer
Investigating outliers is essential to understand the salary distribution. Outliers above the upper whisker may represent legitimate high salaries (e.g., executives) or data entry errors, and understanding their source guides appropriate analysis. Option A is wrong because a histogram does not inherently clarify the nature of outliers.
Option B is wrong because blindly removing outliers can distort the true distribution. Option C is wrong because trimming top salaries without investigation loses valuable information and biases the analysis.
The exhibit shows a JSON configuration for a line chart that displays average response time over time. However, the chart shows jagged lines with many spikes. Which configuration change would smooth the visualization?
Monotone interpolation produces a smoother curve through points.
Why this answer
Setting interpolation to 'monotone' or 'smooth' can reduce jaggedness. The aggregation is already applied in the query, so changing it to 'average' in the widget would double-aggregate. Changing chart type or data source is not necessary.
A retail company generates a daily PDF report showing the previous day's sales by region and product category. The report is automatically emailed to store managers at 6:00 AM. Which type of report is this?
This is correct because the report is automated and delivered regularly.
Why this answer
Scheduled reports are automated and delivered on a regular cadence. This daily sales report is scheduled and automatically delivered.
A financial analyst is preparing a report that must comply with the Sarbanes-Oxley (SOX) Act. What is the most critical requirement for this report?
SOX mandates audit trails for financial reporting to ensure accountability.
Why this answer
SOX requires audit trails to ensure the integrity and traceability of financial data for compliance.
A data analyst is presenting a recommendation to reduce inventory costs. The evidence shows that overstocking occurs in 30% of warehouses. Which of the following best structures the recommendation?
Follows evidence → insight → recommendation → expected impact.
Why this answer
A proper data-driven recommendation follows the sequence: evidence → insight → recommendation → expected impact.
The exhibit shows log entries. A data analyst wants to visualize the frequency of each error type over time. Which chart type is most appropriate?
Shows frequency trend over time.
Why this answer
A time series line chart counts events per time interval, best for showing frequency over time. Bar chart of counts is static. Pie of error types ignores time.
Scatter plot not suitable.
An analyst is creating an executive summary for a quarterly business review. Which THREE components are essential for an effective executive summary?
Guides decision-making.
Why this answer
An executive summary should start with a headline number, provide context, and include actionable recommendations.
An analyst recommends a pricing change based on data showing price elasticity. The recommendation includes expected revenue impact. What is this an example of?
Correct. It includes evidence and expected impact.
Why this answer
Data-driven recommendations follow the structure: evidence -> insight -> recommendation -> expected impact.
A data analyst wants to show the monthly sales trend for the past two years with an emphasis on cumulative growth. Which chart type is most appropriate?
Area charts highlight cumulative totals over time.
Why this answer
An area chart is the most appropriate choice because it combines a line chart's ability to show trends over time with a filled area beneath the line, which visually emphasizes cumulative growth. For monthly sales data over two years, the area fill makes it easy to see both the month-over-month trend and the total accumulated sales volume, which is exactly what the data analyst needs.
Exam trap
The trap here is that candidates often choose a line chart (Option D) because it shows trends, but they overlook that the area chart is specifically designed to emphasize cumulative growth through its filled region, which is the key requirement in the question.
How to eliminate wrong answers
Option A is wrong because a scatter plot is used to show the relationship between two numerical variables (e.g., correlation), not to display a single time series trend or cumulative growth. Option B is wrong because a bar chart is best for comparing discrete categories or individual values, but it does not inherently emphasize cumulative growth or continuous trend over time. Option D is wrong because while a line chart effectively shows trends over time, it lacks the filled area that visually emphasizes cumulative growth; the area chart is specifically designed to highlight the magnitude of change and accumulation.
A dashboard needs to show sales trends for each of five regions over the past year. The intended audience wants to compare trends easily. Which chart type is best?
Multiple line charts clearly show each region's trend over time.
Why this answer
A line chart with multiple lines allows the audience to easily compare trends across the five regions over time. Each region can be represented by a separate line, making it simple to see upward or downward trends and compare them side by side. In contrast, a pie chart shows parts of a whole and is not suitable for trend comparison; a stacked bar chart emphasizes composition rather than trends; and an area chart is similar to a line chart but can obscure overlapping trends due to stacking.
An operations manager needs to monitor manufacturing line status every 15 minutes to identify bottlenecks. Which type of report should be used?
Correct. Operational reports are designed for real-time operational monitoring.
Why this answer
Operational reports provide real-time or near-real-time data for monitoring ongoing operations.
A data analyst is preparing a presentation for the executive team to explain why quarterly revenue fell short of targets. They want to use storytelling with data. Which THREE elements should be included in the narrative arc? (Choose three.)
Correct. The resolution provides the path forward.
Why this answer
Situation sets context, complication introduces the problem, and resolution provides the solution. Data details are not part of the high-level narrative arc.
A data analyst is designing a dashboard for executives. Which best practice should be followed?
Clean design improves readability and decision-making.
Why this answer
Reducing clutter helps viewers focus on key insights without distraction.
A business user wants to explore sales data without relying on the data team. Which report type empowers the user to create their own analysis?
Correct. Self-service enables user-driven analysis.
Why this answer
Self-service reports allow users to query and analyze data independently using BI tools.
Drag and drop the steps to resolve data integration conflicts in the correct order.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Why this order
Conflict resolution starts with identification, analysis, standardization, transformation, and merging.
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?
Box plots show five-number summary and outliers.
Why this answer
A box plot displays the median, quartiles (Q1 and Q3), and outliers, making it ideal for identifying outliers in distribution.
An analyst creates a scatter plot with three variables: X, Y, and a third variable represented by the size of the markers. This chart is called a:
Bubble charts are scatter plots with a third dimension represented by bubble size.
Why this answer
A bubble chart is a variation of a scatter plot where a third numeric variable is encoded by the size (area) of the markers. This allows the visualization of three dimensions of data simultaneously on a two-dimensional plane, making it the correct choice for the described chart.
Exam trap
The trap here is that candidates confuse a bubble chart with a heat map because both can represent three variables, but the heat map uses color gradients on a grid, not marker size on a scatter plot.
How to eliminate wrong answers
Option A is wrong because a heat map uses color intensity to represent the magnitude of a third variable across two categorical axes, not marker size. Option B is wrong because a treemap uses nested rectangles (tiles) to display hierarchical data, with area encoding a quantitative value, and does not use X/Y coordinates or marker sizes. Option D is wrong because a waterfall chart shows cumulative effects of sequential positive or negative values, typically in a financial context, and does not involve scatter plot markers or a third variable encoded by size.
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?
Histograms show the distribution shape of continuous data.
Why this answer
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.
A dashboard designer is creating a KPI dashboard for executives. Which of the following is a leading indicator?
Leads are a leading indicator of future sales.
Why this answer
Number of qualified leads is a leading indicator as it predicts future sales, while revenue and customer churn are lagging indicators.
Which THREE are considered best practices in dashboard design? (Select three.)
Heat maps effectively show correlation matrices.
Why this answer
Heat maps effectively visualize correlation by using color intensity to represent the strength of relationships between two variables, making patterns and outliers immediately apparent. This aligns with best practices for dashboard design, which prioritize clarity and rapid insight over decorative elements.
Exam trap
CompTIA often tests the misconception that adding visual flair (like 3D effects) or exhaustive data improves a dashboard, when in reality these choices degrade readability and violate core principles of effective data visualization.
A data analyst wants to compare the revenue across five different product categories. Which chart type is best suited?
Bar charts are best for comparing categories.
Why this answer
Bar charts are ideal for comparing categories because they display discrete values side by side.
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?
DISTINCTCOUNT counts distinct values in a column, ignoring duplicates.
Why this answer
DISTINCTCOUNT is the DAX function specifically for counting unique values in a column.
In Tableau, a data analyst creates a calculated field to compute the average sales per customer. The analyst wants this calculation to remain constant regardless of the level of detail in the view. Which Tableau feature should be used?
LOD expressions control granularity independent of the view.
Why this answer
Level of Detail (LOD) expressions allow calculations to be performed at a specific granularity independent of the view. FIXED LOD can compute average sales per customer and remain constant.
Refer to the exhibit. What is the best corrective action to resolve this error?
Casting to numeric solves the type mismatch.
Why this answer
The error indicates a data type mismatch; converting the column to numeric in the ETL process ensures compatibility.
A data analyst is using Tableau to build a dashboard. Which THREE features are available in Tableau for creating interactive dashboards?
Actions enable interactivity like filtering or navigating between sheets.
Why this answer
Parameters, calculated fields, and dashboard actions are key Tableau features for interactivity. LOD expressions are also available but not required for interactivity per se. Power Query is a Power BI feature.
A hospital's analytics team has created a dashboard for tracking patient wait times across departments. The dashboard uses a stacked bar chart showing average wait time per department, with each bar segmented by severity level (Low, Medium, High). However, management complains that it is difficult to compare total wait times across departments or identify which department has the highest average wait time. The data itself is accurate and complete. The analyst needs to redesign the visualization to address these concerns. Which course of action should the analyst take?
This allows direct comparison of totals and individual segments across departments.
Why this answer
A grouped bar chart with each department showing separate bars for each severity level placed side-by-side enables direct comparison of total wait times across departments and easy identification of the department with the highest average wait time. Option A is incorrect because multiple line charts are designed for time-series data, not for comparing categorical totals across departments, and would clutter the view. Option B is incorrect because a heat map can show patterns but does not allow clear comparison of total wait times or identification of the highest average.
Option D is incorrect because a pie chart only shows proportions of a single category (e.g., total wait time per department) and loses severity-level information, making it impossible to compare total wait times meaningfully.
An analyst is creating a report that includes multiple charts. To ensure the audience quickly grasps the key insight, which principle of data storytelling should be applied?
A title that summarizes the finding helps the audience understand the message immediately.
Why this answer
Starting with a clear title that summarizes the takeaway guides the audience to the main insight. Using a legend only or placing the chart first does not provide context. Avoiding titles reduces clarity.
A data analyst is creating a report on customer satisfaction scores. The analyst wants to ensure that regional managers can only see data for their own region. Which security measure should be applied?
Row-level security filters data based on user attributes.
Why this answer
Row-level security restricts data visibility so that users see only the rows relevant to them, such as their region.
Match each data type to its example.
Drag a concept onto its matching description — or click a concept then click the description.
Country of origin (e.g., USA, Canada)
Customer satisfaction rating (1-5)
Temperature in Celsius
Annual income in dollars
Gender (Male, Female, Other)
Why these pairings
Nominal data are categories without order; ordinal data have ranked categories; interval data have equal intervals but no true zero; ratio data have equal intervals and a true zero. Common confusions include mistaking nominal for ordinal (e.g., gender) or interval for ratio (e.g., counts).
Ready to test yourself?
Try a timed practice session using only Visualization and Reporting questions.