Visualization and Reporting

A data analyst has built a dashboard for a retail chain that shows sales by product category. During user testing, store managers report that they cannot tell which categories are the top performers because the bars are arranged in the order the categories appear in the database, and the y-axis starts at zero with a very high maximum that compresses all bars. Which change should the analyst make to improve the chart's communicative value?

A business analyst creates a one-time report to analyze customer churn for a special project. Which report type is being used?

A data analyst wants to show the relative proportions of defects by type in a manufacturing process. There are 6 defect types. Which chart is most appropriate?

An analyst wants to show the trend of monthly sales over the past two years. Which chart type is most appropriate?

A company uses a dashboard to monitor server uptime. The data is collected every minute, but the dashboard only refreshes every hour. Users see gaps in the line chart. What is the most likely cause, and how should it be fixed?

A retail analyst must build a single dashboard that executives will view on a large conference-room display and regional managers will open on tablets in the field. The executive layout uses a dense 4x3 grid of small KPI tiles. Which design approach best preserves readability across both viewing contexts?

A data analyst is creating a dashboard for a retail company. The dashboard should provide insights into sales performance across multiple dimensions. Which TWO chart types are best suited for showing the contribution of each product category to total sales?

Which chart type is best for comparing the distribution of a continuous variable across different categories?

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?

A data analyst is creating a report that compares the performance of five different marketing campaigns over the past year. The analyst wants to show both the total revenue generated by each campaign and the proportion of total revenue that each campaign represents. Which combination of visualizations is most effective for this purpose?

A data analyst needs to visualize the relationship between advertising spend and sales revenue for 50 products. Which chart type is most appropriate?

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:

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?

A data analyst has built a dashboard tracking monthly active users (MAU) for a mobile app over the past two years. The executive sponsor complains that the line chart is hard to read because the y-axis starts at zero, making month-to-month variation look small. The analyst wants to emphasize the trend and small fluctuations while still being honest about the data. Which change to the y-axis is most appropriate?

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

A senior data analyst is advising a team on dashboard design principles. Which THREE of the following are recommended best practices? (Choose three.)

Which TWO visualization types are suitable for showing the distribution of a single continuous variable?

A data analyst needs to design a report for two audiences: executives want a high-level trend, and operational managers need current inventory levels. Which approach best satisfies both?

A data analyst needs to visualize the relationship between two continuous variables, such as sales revenue and advertising spend, to identify potential correlation. Which chart type is most appropriate?

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?

Which TWO are common mistakes when creating data visualizations?

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?

A data analyst wants to show the correlation between advertising spend and website traffic. Which chart type should they use?

A business analyst wants to compare the proportion of total sales contributed by each product category in the current year. Which visualization is most suitable?

A data analyst wants to show the sales trend for a product over the past 12 months. Which chart type is most appropriate?

A company is implementing a centralized reporting layer to replace departmental spreadsheets. Which TWO benefits are most directly achieved?

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?

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?

A data analyst is troubleshooting a map visualization that shows null values for some regions. Which TWO actions should the analyst take to resolve the issue?

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?

A time series dataset has several missing months of data. Which chart type will present the most honest picture of the trend?

A data analyst is building a report that will be distributed as a PDF to stakeholders who will view it on various devices, including smartphones. The report includes several charts with small text labels and thin lines. Which action should the analyst take to ensure the charts remain legible on smaller screens?

Which TWO of the following chart types are appropriate for showing the distribution of a continuous variable? (Choose 2.)

A data analyst is building a dashboard that includes a filter for 'Region'. The dashboard also contains a table showing sales by product category. The analyst wants to ensure that when a user selects a region from the filter, the table updates to show only sales for that region. Which feature should the analyst configure?

A data analyst is creating a report that shows the percentage of total sales contributed by each product category. The categories are: Electronics (45%), Clothing (30%), Home Goods (15%), and Toys (10%). Which chart type is most effective for displaying this information?

A data analyst is creating a weekly KPI email for executives. Which TWO attributes are most important for this type of report?

A data analyst has built a dashboard that tracks monthly website traffic. The dashboard currently uses a line chart to show the trend of total visits over time. The marketing team now wants to see how each of four traffic sources (organic, paid, social, referral) contributes to the total each month, while still being able to see the overall trend. Which chart type best meets this requirement?

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?

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?

A data analyst is tasked with visualizing the distribution of customer ages across different regions. The dataset contains outliers. Which chart type best displays the distribution and highlights outliers?

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?

An analyst creates a pie chart showing market share of four companies: A (45%), B (30%), C (15%), D (10%). A stakeholder complains that it is difficult to compare C and D. Which alternative chart should the analyst recommend?

A dashboard designer is building a sales performance dashboard for executives. According to dashboard design principles, which TWO practices should be applied? (Choose two.)

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?

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?

A data analyst is creating a dashboard for a hospital's emergency department. The dashboard must display the current wait time, the number of patients waiting, and the average wait time over the past 24 hours. The analyst wants to ensure that the most critical information is immediately visible to the charge nurse. Which design principle should the analyst apply?

Which TWO actions are best practices for creating effective data visualizations?

A data analyst needs to visualize the relationship between two continuous variables: advertising spend (in dollars) and monthly sales (in units). Which chart type is most appropriate?

A marketing manager wants to visualize the conversion funnel from website visits to final purchase. Which chart type is most appropriate?

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?

Which THREE of the following are common mistakes when creating data visualizations? (Choose 3.)

Which TWO color choices are appropriate for a categorical data visualization? (Select two.)

A company needs to visualize monthly sales revenue for the past five years to identify seasonal trends. Which chart type is most appropriate?

An organization is implementing a centralized reporting layer to replace multiple departmental spreadsheets. Which governance principle does this support?

A sales report shows a 10% increase in revenue, but the analyst knows the data has limitations. Which TWO elements should be included to communicate uncertainty? (Select TWO.)

A data analyst publishes a quarterly financial report in which the same revenue figure is printed on a summary page, a regional breakdown page, and an appendix table. The three values currently come from three separately written queries. Which practice most directly reduces the risk of the pages disagreeing?

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?

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

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?

Which report type is best suited for monitoring the real-time status of manufacturing equipment on the factory floor?

A data analyst receives a request from a sales manager for a one-time report on Q4 performance by product line. The report is not expected to be repeated. Which type of report should the analyst create?

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.)

A marketing analyst needs to answer a one-time question about campaign performance for a specific week. Which report type is appropriate?

A data analyst is designing a dashboard for executives. Which best practice should be followed regarding the placement of key performance indicators (KPIs)?

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.)

A data analyst is designing a self-service reporting platform for business users. Which TWO practices will help ensure data consistency and trust? (Select TWO.)

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?

A data analyst creates a dashboard showing average order value by region. The chart indicates that one region has an unusually high average. Investigation reveals that the region has very few orders, but one large purchase inflates the average. Which data transformation should the analyst apply to improve the visualization?

A data analyst is designing a dashboard that will be viewed on both desktop monitors and mobile devices. The dashboard contains several charts and KPI cards. Which design approach best ensures usability across these devices?

A data analyst is building a report that will be distributed as a PDF to stakeholders. The report includes a bar chart showing sales by region. The analyst wants to ensure that the chart is accessible to color-blind readers. Which action should the analyst take?

A retail company with 500 stores across North America wants to visualize its sales performance. The dataset includes store ID, region (Northeast, Southeast, Midwest, West), product category (Electronics, Clothing, Home Goods), monthly sales (in dollars), and date (from January 2018 to December 2023). The data has missing values for about 5% of store-month combinations, and a few stores have reported sales that are 10 times higher than the average for their region due to grand opening events. The goal is to create a dashboard that shows monthly sales trends for each region and product category, and allows users to identify which categories are driving growth. Which approach should the analyst take?

A financial report must be retained for seven years to comply with regulatory requirements. This is an example of which data governance principle?

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?

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?

A company's sales report shows revenue of $1.2M, but the calculation method is unclear. What data governance artifact would clarify the definition?

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?

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?

Which chart type is best for visualizing the correlation between two continuous variables?

A data analyst notices that the sales numbers in a report differ from the numbers in the finance department's spreadsheet. This discrepancy is most likely due to a lack of:

The exhibit shows a SQL query result intended for a bar chart of revenue by region. However, the chart shows only the top 10 regions, but the query returns all regions. What is the most likely cause?

A manager in operations needs a real-time dashboard showing production line status, including machine uptime and error counts. Which type of report is most appropriate?

A data analyst must build a one-page dashboard for a hospital's bed-management team. The team needs to know, at a glance, how many beds are free right now, how that compares with the same hour yesterday, and whether the trend is worsening. Which combination of visual elements is MOST appropriate for the top band of this dashboard?

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?

A data analyst needs to communicate the findings of a marketing campaign analysis to the Vice President of Marketing. The VP typically only reads the first paragraph and wants the key takeaway immediately. Which format should the analyst use?

An organization wants to ensure that all reports use the same definitions for metrics like 'Active Customer' to avoid confusion. Which data governance element should be implemented?

A healthcare analyst is creating a report on patient outcomes. To comply with privacy regulations, which action should be taken before publishing?

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?

An executive dashboard needs to display key performance indicators (KPIs) such as sales growth and customer satisfaction. Which design principle is most important?

Which chart type is best for showing the sales pipeline from leads to closed deals, illustrating how many prospects drop off at each stage?

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?

A business analyst needs to explain to a sales director that the reported revenue has a 95% confidence interval of ±2%. Which concept is being communicated?

A dashboard should be designed so that the most important metric is prominently displayed. This is an example of which design principle?

A company needs to visualize the trend of monthly sales revenue over the past two years. Which chart type is most appropriate?

Which TWO chart types are best suited for visualizing the distribution of a single continuous variable? (Select two.)

A dashboard designer needs to ensure that color choices are accessible to users with color vision deficiencies. Which practice should be followed?

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.)

A data analyst needs to present the correlation between advertising spend and website traffic. Which chart type is most appropriate?

A company wants to show the number of products sold across different categories: Electronics, Clothing, Home Goods, and Books. Which chart type is most appropriate?

A data analyst is creating a dashboard for a sales team. Which TWO actions adhere to dashboard design best practices?

A data analyst creates a bubble chart showing country GDP (x-axis), life expectancy (y-axis), and population (bubble size). However, large bubbles overlap and obscure many data points. Which corrective action should the analyst take?

A data analyst is building a dashboard that includes a KPI card showing the current customer satisfaction (CSAT) score. The target is 90%. The analyst wants the card to immediately convey whether the current score is meeting, approaching, or below target. Which design approach best achieves this?

Match each data analysis tool to its primary function.

A data analyst is creating a report that will be printed in black and white for a quarterly business review. The report includes a bar chart comparing revenue across five product categories. To ensure the chart is interpretable without color, which design element should the analyst prioritize?

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?

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?

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

You are a data analyst for an e-commerce company. Your team has built a dashboard to monitor daily sales performance across five regions: North, South, East, West, and Central. The dashboard includes a bar chart showing total sales per region, a line chart showing daily sales trend over the past 30 days, and a pie chart showing sales distribution by product category (Clothing, Electronics, Home, Books, Sports). Recently, stakeholders have complained that the pie chart is hard to interpret because the Sports category has very small sales and is barely visible. Also, the bar chart uses a rainbow color scheme that makes it difficult to compare bar heights because the colors are not ordered by magnitude. The line chart is fine. You need to redesign the dashboard to address these issues. Which combination of changes is most appropriate?

A data analyst frequently receives ad hoc requests for the same type of analysis. Which TWO approaches could reduce the number of ad hoc requests?

An executive dashboard must display high-level KPIs such as current revenue, profit margin, and customer count. Which visualization type is most appropriate for each KPI?

A data analyst is creating a self-service reporting environment. Which data governance practice ensures users see only data relevant to their department?

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.)

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?

A data analyst creates a weekly KPI dashboard for executives. The analyst notes that the data is updated as of the previous day. Which report quality element should be included?

Which THREE actions improve the accessibility of data visualizations for users with visual impairments? (Select exactly three.)

An analyst creates a stacked bar chart showing quarterly sales by product category. The chart becomes hard to read because some categories have very small contributions. Which redesign is most effective?

An IT operations team monitors 200 servers. Each server reports CPU utilization (0-100%) every five minutes for the past year. The team wants to visualize the data to identify servers that are consistently over 80% utilization and detect any unusual spikes. They have a large dataset with 100,000+ records per server. The current visualization is a single scatter plot with CPU utilization on the y-axis, time on the x-axis, and each server as a different colored point. The chart is extremely cluttered, with points overlapping and colors indistinguishable. What should the team do to improve the visualization?

A data analyst is creating a dashboard to monitor key performance indicators (KPIs) for a retail company. The dashboard will be used by store managers to quickly assess daily performance. Which TWO design elements are most important to include? (Choose two.)

A data analyst is documenting a report for external stakeholders. Which THREE elements should be included to ensure report quality and transparency?

A dashboard shows sales by region using a map with color intensity. Users complain that two regions with very different sales appear nearly the same color. What is the most likely cause?

A data analyst is creating a report that includes customer names and addresses. To comply with privacy regulations, which TWO actions should the analyst take?

Which TWO actions will improve the readability of a bar chart showing quarterly sales across five regions?

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?

Which TWO are examples of leading indicators in a business context? (Select two.)

Which TWO of the following are best practices for designing an accessible data visualization? (Choose 2.)

A data analyst is creating a report to compare the total sales revenue for five different product categories over the last four quarters. The analyst wants to show both the overall total and how each category contributes to that total for each quarter. Which chart type is most appropriate?

A heat map of store sales by region shows very low correlation between advertising spend and revenue, but a scatter plot of the same data shows a strong positive relationship. What is the most likely cause?

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.)

A retail analyst is preparing a one-page executive dashboard. The CEO wants to see month-over-month revenue growth, while the operations director wants to monitor daily order volume. The analyst decides to use a bullet chart for the revenue growth and a line chart for daily order volume. Which design principle is best demonstrated by this choice?

A dashboard designer wants to maximize the data-ink ratio. Which action should they take?

A data analyst needs to visualize sales per capita across U.S. states. States with small populations but high sales (e.g., Delaware) appear too prominent on a choropleth map. Which technique best addresses this issue?

A data analyst is preparing a monthly performance report for a hospital network. The report will be distributed as a static PDF and must let department heads compare readmission rates across eight hospitals for the current month. The analyst wants the visual to remain accurate if the PDF is printed in grayscale. Which TWO design choices should the analyst make? (Choose two.)

A data analyst is building a report that will be refreshed weekly and distributed as a PDF to stakeholders. The report includes a table of sales by region and a bar chart of top products. Stakeholders have requested that the report be accessible on mobile devices. Which adjustment should the analyst make to ensure the report is mobile-friendly?

A data analyst is finalizing a recurring monthly operations report that will be exported to PDF and emailed to regional directors who read it on tablets. The analyst must choose design practices that keep the report readable and trustworthy in that fixed, non-interactive format. (Choose two.)

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?

A data analyst is preparing a report on customer satisfaction scores for the past quarter. The scores are measured on a scale from 1 to 5, and the analyst wants to show the distribution of scores, including the median and any outliers. Which visualization is most appropriate for this purpose?

A data analyst is designing a report that will be viewed on a large monitor in a conference room. The report includes a heatmap of customer satisfaction scores across different regions and time periods. The analyst notices that the color scale uses a rainbow gradient, and some viewers have difficulty distinguishing between adjacent colors. Which change should the analyst make to improve the readability of the heatmap?

A data analyst is preparing a report on monthly website traffic for the marketing team. The team wants to see how the total number of visits has changed over the past 12 months. Which chart type is most appropriate for this purpose?

A data analyst is building a dashboard that includes a map showing sales by state. The map uses a choropleth technique with a continuous color gradient from light blue (low sales) to dark blue (high sales). A stakeholder comments that it is difficult to compare sales between states because the colors look similar. Which adjustment would most improve the map's effectiveness for comparison?

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?

A dashboard designer wants to ensure the most important KPI is prominently displayed at the top left. Which design principle is being applied?

Which chart type is best for showing the distribution of a continuous variable, such as customer ages?

An analyst wants to show the distribution of test scores for 500 students. Which visualization type is best for understanding the shape of the distribution?

A data analyst is building a report that includes customer names and addresses. To comply with GDPR, what must the analyst do before publishing the report?

You are a data analyst for a logistics company. The company has a fleet of delivery trucks and tracks performance metrics including delivery time, fuel consumption, and distance traveled. Management wants a dashboard to monitor driver efficiency and identify underperforming drivers. You have access to a dataset with columns: DriverID, Date, RouteID, Distance (miles), FuelUsed (gallons), DeliveryTime (minutes). The dataset contains 10,000 records from the past year. You need to create a visualization that allows management to quickly compare the average fuel efficiency (miles per gallon) of drivers and also see how consistent each driver's efficiency is. Which of the following approaches is the best course of action?

A data visualization specialist needs to display the relationship between advertising spend and revenue for 50 product categories over 12 months. The data has many overlapping points. Which chart type best reveals the correlation and density?

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?

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?

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?

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 data analyst is preparing a quarterly business review report for a retail company. The report includes a bar chart showing sales by region. The analyst notices that the chart is very wide and the region labels are overlapping, making it hard to read. The analyst wants to improve readability without losing any regions. Which action is most appropriate?

A data analyst wants to visualize the monthly sales trend for the past year. Which chart type is most appropriate?

A data analyst is creating a dashboard to monitor website traffic. The dashboard will include metrics such as page views, unique visitors, and average session duration. The analyst wants to ensure the dashboard effectively communicates performance to the marketing team. Which TWO design elements should the analyst prioritize? (Choose two.)

An analyst creates a dashboard with multiple visualizations. Which feature allows users to change the data displayed across all charts simultaneously?

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?

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?

Which TWO of the following are leading indicators that can help predict future performance?

A data analyst is designing a report that will be printed in black and white for a monthly management meeting. The report includes a bar chart comparing sales across five regions. To ensure the chart is easily interpretable in grayscale, which design choice should the analyst make?

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?

Which TWO chart types are best suited to show the proportion of total sales contributed by each product category? (Select exactly two.)

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.)

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?

A sales dashboard shows a map with many overlapping markers in the same city, making it hard to read. What is the best improvement?

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

A data analyst is preparing a report on customer satisfaction scores. To comply with GDPR, which THREE actions must be taken? (Select THREE.)

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?

A data analyst needs to compare the salary distribution across five departments. Which visualization is most appropriate?

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?

A data analyst is creating a report to summarize customer satisfaction survey results. The survey asked customers to rate their satisfaction on a scale from 1 (very dissatisfied) to 5 (very satisfied). The analyst wants to show the number of respondents for each rating level. Which visualization is most appropriate?

A sales VP wants a quick summary of last month's revenue change and key drivers. Which report section is most relevant?

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?

A marketing team wants to explore the relationship between advertising spend (in dollars) and resulting revenue. Which chart type is most suitable?

A data analyst wants to show the relationship between advertising spend and sales revenue for 50 stores. Which chart type is most appropriate?

An analyst is choosing a chart to show the correlation between two continuous variables. Which TWO chart types could be used? (Select two.)

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?

Refer to the exhibit. A stakeholder complains that the line chart exaggerates the changes in sales. What is the most likely cause?

A marketing team wants a single view comparing this quarter's campaign performance against the same quarter last year across five channels, with the ability to drill from channel totals down to individual campaign rows. Which visualization structure best supports both the comparison and the drill path?

In Looker Studio, what is the difference between dimensions and metrics?

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?

A sales analyst wants to show total sales by product category, with each category's contribution to the total. Which chart type is best?

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?

An analyst is presenting a recommendation to increase marketing spend. Which statement best follows the data-driven recommendation structure (evidence → insight → recommendation → expected impact)?

Which THREE are best practices for designing a dashboard for executive consumption?

A data analyst is designing a dashboard for a hospital's emergency department. The dashboard must display real-time patient wait times, current bed occupancy, and the number of patients waiting to be seen. The primary users are charge nurses and physicians who need to make quick staffing decisions. Which two design principles are most critical to ensure the dashboard is effective for this scenario? (Choose two.)

A junior analyst is asked to show how total monthly support ticket volume changed over the past 24 months so leadership can spot seasonal peaks. Which visualization is most appropriate?

A data analyst is tasked with creating a report that shows the proportion of total sales contributed by each product category. The analyst wants to use a chart that clearly displays the parts of a whole. Which chart type is most appropriate?

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 financial analyst is creating a quarterly report compliant with SOX. Which requirement is most critical for the report's audit trail?

Which TWO chart types are appropriate for visualizing the distribution of a continuous variable? (Select two.)

A data analyst is designing a dashboard and wants to maximize the data-ink ratio. Which action aligns with this principle?

A financial analyst publishes a monthly report where a gauge chart shows the current debt-to-equity ratio against a target band. Executives repeatedly misread the gauge, assuming the needle's position alone indicates good or bad performance without checking the target thresholds. Which change would BEST improve accurate interpretation?

A data analyst is presenting a story about declining sales. The narrative arc should include which three elements in order?

A data analyst is creating a dashboard and wants to maximize the data-ink ratio. Which action supports this principle?

Which THREE factors should be considered when choosing a chart type for a dataset?

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?

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?

A logistics company has data on delivery times (continuous) and distance traveled (continuous). They want to visualize the relationship between these two variables. Which chart type is most appropriate?

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?

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?

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?

An analyst is creating an executive summary for a quarterly business review. Which THREE components are essential for an effective executive summary?

An analyst recommends a pricing change based on data showing price elasticity. The recommendation includes expected revenue impact. What is this an example of?

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?

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.)

A data analyst is designing a dashboard for executives. Which best practice should be followed?

A data analyst is designing a dashboard for hospital administrators to monitor emergency department (ED) wait times. The dashboard will be viewed on large wall-mounted displays in the operations center and must be readable from a distance. The analyst wants to ensure the dashboard effectively communicates urgent situations. Which two design choices are most appropriate? (Choose two.)

Drag and drop the steps to resolve data integration conflicts in the correct order.

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?

A data analyst is designing a dashboard to monitor real-time website traffic. The dashboard will be used by the operations team to quickly identify anomalies and take immediate action. Which two design elements are most critical to include? (Choose two.)

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:

A dashboard designer is creating a KPI dashboard for executives. Which of the following is a leading indicator?

A data analyst at a subscription streaming service is designing a dashboard for the customer success team. The team needs to monitor, side by side, the current month's churn rate against the same month last year and against a target churn rate of 4.5%. The analyst wants viewers to instantly see whether the current rate is above or below target. Which design approach best supports this?

Which THREE are considered best practices in dashboard design? (Select three.)

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

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?

A data analyst is preparing a dashboard that will be embedded in a public-facing web page and refreshed nightly. The source system contains customer names and account numbers, but the dashboard only needs aggregated counts by region and product line. Which two practices should the analyst apply to reduce disclosure risk while keeping the dashboard functional? (Choose two.)

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?

Refer to the exhibit. What is the best corrective action to resolve this error?

A data analyst is using Tableau to build a dashboard. Which THREE features are available in Tableau for creating interactive dashboards?

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 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?

A data scientist has a dataset with 50 variables and wants to identify clusters of similar observations. Which visualization technique is most suitable for reducing dimensionality to 2D while preserving cluster structure?

An analyst creates a histogram of customer transaction amounts but observes that the distribution looks bimodal. Upon review, the analyst realizes that two different customer segments (retail and wholesale) were combined. Which action best addresses this?

A data analyst is building a self-service reporting environment. Which of the following is the primary benefit of this approach?

A retail analytics team publishes a dashboard showing average order value by store. A regional manager notices that the store with the highest average order value is also the store with the fewest orders, and questions whether that store is genuinely the best performer. Which dashboard design change would BEST let the manager judge that store fairly?

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

You are a data analyst at a logistics company. You have created a dashboard to monitor delivery performance. The dashboard includes a scatter plot showing delivery time (hours) vs. distance (miles) for each delivery, with points colored by delivery region (A, B, C, D, E). Users have reported that the scatter plot is cluttered because there are over 10,000 points, making it hard to see patterns. Additionally, the color legend for the five regions uses similar shades of blue, making it difficult to distinguish which region a point belongs to. You need to improve the scatter plot to reduce overplotting and improve region differentiation. Which approach is most effective?

An analyst creates a dashboard with a large amount of decorative graphics and background images. According to CompTIA Data+, which design principle is being violated?

A data analyst is building a dashboard for a regional sales director who needs to monitor daily performance across 12 territories. The director wants to instantly see which territories are below target, with the ability to click a territory to view its individual store details. The analyst decides to use a bullet chart for each territory. Which design choice best supports the director's need for immediate exception identification and drill-down?

A junior data analyst is asked to create a chart that shows total monthly revenue for the past 24 months so the finance team can see whether revenue is generally rising or falling over time. Which chart type is most appropriate?

A data analyst is designing a dashboard that will be displayed on a large monitor in a call center. The dashboard shows real-time metrics such as average handle time, call volume, and customer satisfaction. The analyst wants to ensure that the most critical metric—average handle time—is immediately noticeable when it exceeds a threshold. Which design technique best achieves this?

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

A retail company operates 50 stores across the country. The data analyst has been asked to create a dashboard to visualize monthly sales trends over the past two years and compare the performance of the top 5 stores. The dataset includes store name, date, and daily sales amount. Initial exploration reveals that some stores have missing sales data for certain months due to system outages, and there are occasional extreme values caused by promotional events (e.g., Black Friday sales are 10x normal). The analyst needs to choose an appropriate visualization approach that accurately represents the trends and comparisons while handling these data quality issues. What should the analyst do to best meet the requirements?

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

Drag and drop the steps to clean a dataset with missing values in the correct order.

A data analyst is designing a dashboard for executives. Which TWO practices improve dashboard effectiveness? (Select two.)

A data analyst has built a dashboard tracking daily website sessions. The product owner wants to know which acquisition channel contributed the largest share of sessions over the past quarter, and how those shares shifted month by month. Which chart type is MOST appropriate?

A data analyst needs to show the relationship between advertising spend (in dollars) and monthly sales revenue (in dollars) for the past 12 months. Which chart type is most appropriate?

A data analyst discovers that the sales data for the current quarter shows a 15% increase in revenue. However, the analyst notes that the data does not include returns from the last week due to a system lag. How should the analyst communicate this uncertainty?

A data analyst must build a monthly dashboard for the executive team. The dashboard will be viewed on large screens in the boardroom and must display the current month's revenue, profit margin, and customer acquisition cost at a glance. Which design approach best ensures the dashboard is immediately understandable?