Mixed Deck — All CBDA Topics Flashcards

What is 'overfitting' in the context of predictive modeling for business data analysts?

Answer: Building a model that performs well on training data but poorly on new, unseen data

An overfit model has learned the noise in the training data rather than the underlying pattern, causing poor generalization.

When a CBDA analyst uses 'small multiples,' they are applying which visualization technique?

Answer: Creating several small charts with the same scale to compare across a variable

Small multiples repeat the same chart structure for different subgroups, enabling side-by-side comparison.

What is the PRIMARY benefit of standardizing system architecture & design practices in Certified Business Data Analyst?

Answer: Consistency, easier maintenance, and improved collaboration among team members

Standardization promotes consistency across the organization, simplifies maintenance, and enables better collaboration between team members.

Which of the following helps in validating a predictive model?

Answer: Cross-validation

Cross-validation is a robust technique used to validate the performance of a predictive model and assess how well it generalizes to an independent dataset. It involves partitioning the data into multiple subsets, training the model on a portion, and testing it on the remaining portion, repeating this process multiple times. This method helps to reduce overfitting and provides a more reliable estimate of the model's predictive accuracy.

Which of the following is a key principle of effective data storytelling for business analysts?

Answer: Lead with a clear insight and support it with evidence

Effective data storytelling begins with the key insight, then uses evidence to support and contextualize it.

What is the purpose of a data disposal policy?

Answer: To establish rules for securely and permanently removing data that has reached the end of its retention period

A data disposal policy ensures that data no longer needed for business, legal, or compliance purposes is destroyed securely and in a documented manner to prevent unauthorized access.

A CBDA analyst notices that a bar chart misleads viewers by starting the Y-axis at 500 instead of 0. This is an example of which problem?

Answer: Truncated axis distortion

A truncated Y-axis exaggerates differences between bars, misleading the audience about the true magnitude of change.

In the context of data management, what is 'schema-on-read'?

Answer: Applying the data structure interpretation when data is queried rather than when it is stored

Schema-on-read defers applying a structure to data until it is accessed, commonly used in data lakes where raw data is stored without enforcing a schema upfront.

Which of the following characteristics is LEAST essential for a good research question in a business data analytics context?

Answer: Original

While originality can be valuable, it is not the most critical aspect of a research question in a business context. Questions must be feasible (answerable with available data and resources), relevant to business objectives, and specific enough to guide analysis. A business may need to re-ask a question that has been answered before (e.g., quarterly performance analysis) to track changes over time, making originality less of a priority than direct business value.

Which factor BEST indicates mastery of implementation & configuration in Certified Business Data Analyst?

Answer: The ability to adapt knowledge and skills to varying contexts while maintaining standards

True mastery is demonstrated by the ability to apply knowledge flexibly across different contexts while consistently maintaining quality standards.

Which role is typically responsible for overseeing data governance policies?

Answer: Data stewards

Data stewards are individuals or groups responsible for the quality, integrity, and proper use of specific data assets within an organization. They implement and enforce data governance policies, ensuring data accuracy, consistency, and compliance with regulations. Their role is crucial for maintaining trustworthy data throughout its lifecycle.

What is an important consideration when preparing data for analysis?

Answer: Clean, consistent, and relevant data improves the accuracy of analysis

Data preparation, including cleaning, transformation, and validation, is crucial because the quality of input data directly impacts the reliability of analytical results. Inaccurate, inconsistent, or irrelevant data can lead to flawed insights and poor business decisions. Ensuring data quality before analysis is fundamental for trustworthy outcomes.

In Certified Business Data Analyst, how does implementation & configuration contribute to professional credibility?

Answer: By demonstrating competence, maintaining standards, and delivering consistent results

Professional credibility is built through demonstrated competence, consistent adherence to standards, and reliable delivery of quality results.

A data analyst presents a chart showing a strong positive correlation between ice cream sales and sunglasses sales. A stakeholder concludes that the company should bundle these items to increase sales. What is the MOST likely error in the stakeholder's conclusion?

Answer: The stakeholder is confusing correlation with causation.

This is a classic example of confusing correlation with causation. While the two variables move together, one does not cause the other. A hidden third variable, such as sunny weather, is the likely cause for the increase in both ice cream and sunglasses sales. Reporting results requires guiding stakeholders to avoid such logical fallacies.

Which chart type is BEST suited for showing the distribution of a single continuous variable in a business data report?

Answer: Histogram

A histogram displays the frequency distribution of a continuous variable by grouping values into bins.

What is the primary purpose of a data retention policy?

Answer: To define how long data must be kept and when it should be deleted or archived

A data retention policy specifies the duration for which data must be retained based on legal, regulatory, and business requirements, and outlines when it should be purged or archived.

What is a common goal of segmentation in predictive modeling?

Answer: To divide data into meaningful categories

Segmentation in predictive modeling involves partitioning a dataset into distinct groups or segments based on shared characteristics. This process allows for more targeted analysis and model building, as different segments may exhibit different behaviors or patterns. By understanding these distinct groups, models can be tailored to provide more accurate and relevant predictions for each segment.

An analyst is preparing to communicate the results of a complex analysis to a non-technical audience. Which technique is LEAST likely to be effective?

Answer: Providing an exhaustive list of all statistical tests performed and their p-values.

A non-technical audience is primarily concerned with the business implications of the analysis, not the technical details. Overwhelming them with statistical jargon, test results, and p-values is likely to cause confusion and disengagement, obscuring the key message. The focus should be on clarity and actionable insights.

Data lineage tracking is most useful for which of the following purposes?

Answer: Tracing the origin, movement, and transformation of data throughout its lifecycle

Data lineage provides visibility into how data flows from source to destination and what transformations occur along the way, supporting debugging, compliance, and trust.

In a business intelligence context, what is a KPI sparkline?

Answer: A small, simple inline chart showing trend context alongside a KPI metric

Sparklines are compact, word-sized trend charts placed next to metric values to show directional context without taking up space.