Visualising Data

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?

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?

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

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?

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

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?

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?

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 chart type is best for showing the number of website visitors at each stage of a conversion funnel, from initial visit to purchase?

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 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 working in Looker Studio and wants to add a metric that counts the number of unique customers per month. In the context of Looker Studio, which type of field is this metric?

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 creating a dashboard to monitor e-commerce performance. The dashboard will be used by both executives (strategic view) and operations managers (detailed view). The analyst plans to use interactive filters. Which THREE design principles or features are most important to apply for effective dashboard design?

An analyst is creating a dashboard in Power BI to track sales performance. They want to ensure that when a user selects a specific product category on a slicer, all other visuals on the page filter to show data only for that category. Which TWO actions should the analyst take?

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

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

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?

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

A data analyst needs to show the cumulative revenue over time, with emphasis on the total magnitude. 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?

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?

A marketing manager wants to visualize the conversion funnel from website visits to final purchase. 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?

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

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 and wants to maximize the data-ink ratio. Which action supports this principle?

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

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 senior data analyst is advising a team on dashboard design principles. Which THREE of the following are recommended best practices? (Choose three.)

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

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?

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 wants to show the correlation between advertising spend and website traffic. Which chart type should they use?

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 chart type is best for comparing the distribution of a continuous variable across different categories?

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 wants to ensure the most important KPI is prominently displayed at the top left. Which design principle is being applied?

An analyst needs to display the number of website visitors per age group (e.g., 18-25, 26-35, 36-45). Which chart type is most appropriate?

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 is presenting a story about declining sales. The narrative arc should include which three elements in order?

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

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

A sales analyst is building a Power BI report to analyze quarterly performance. Which THREE are appropriate uses of DAX or Power Query? (Select three.)

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

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

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

In Power BI, a data analyst needs to create a measure that calculates total sales for the current year. Which DAX function should be used?

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

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?

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 dashboard should be designed so that the most important metric is prominently displayed. This is an example of which design principle?

A data analyst wants to visualize the number of website visitors by traffic source (e.g., organic, paid social, email) and also show the proportion of each source within the total. Which chart type is best?

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?

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?

Which of the following is a key performance indicator (KPI) tied to a strategic objective, as opposed to a metric?

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?

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

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

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

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

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

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?

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?

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?

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

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

In a Power BI report, a data analyst needs to create a measure that calculates the sum of sales only for products that have a profit margin greater than 10%. Which DAX function should be used to filter the calculation?

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 in Looker Studio and needs to combine data from two different data sources using a common field. Which feature should be used?

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 needs to visualize the distribution of salaries across departments and also compare the median and identify outliers. Which chart type is most suitable?

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

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

A data analyst is creating a report in Power BI and needs to calculate the total sales for the current year and the previous year. Which TWO DAX functions can be used to retrieve the previous year's sales?

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

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?

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

A data analyst is building a report in Power BI and needs to create a measure that calculates the total sales for the current year, but only for products that have at least one sale in the previous year. Which DAX function combination is most appropriate?

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?

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 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 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 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 for a sales team. Which TWO of the following are key performance indicators (KPIs) rather than operational metrics?

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?

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?

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

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?

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

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

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

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?

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 data analyst is building a dashboard in Tableau and wants to allow users to select a specific product category and have all charts on the dashboard filter to that category. Which Tableau feature should be used?

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 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 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 building a narrative around a quarterly sales decline. The story should follow a narrative arc. Which THREE elements should be included in the story?

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

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 dashboard designer is building a sales performance dashboard for executives. According to dashboard design principles, which TWO practices should be applied? (Choose two.)

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

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 marketing analyst wants to visualize the conversion funnel from website visitors to paying customers. Which TWO chart types are suitable for showing this pipeline? (Choose two.)

An analyst is creating a Tableau dashboard for a logistics company. They need to allow users to filter data by region and time period, and also want to show a tooltip with detailed shipment information. Which THREE Tableau features should be used? (Choose three.)

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