Helping Hand Questions for CBDA

The attributes ItemName and ItemPrice need to be normalized to avoid redundancies because they depend on the attribute ItemId, which is not part of the primary key of the Order entity. This is a case of partial dependency, which violates the second normal form (2NF) of database normalization. To achieve 2NF, the Order entity should be split into two entities: Order and Item, where Item contains the attributes ItemId, ItemName, and ItemPrice, and Order contains the attributes OrderId, OrderDate, ItemId, and Quantity. This way, the ItemName and ItemPrice are stored only once for each ItemId, and the Order entity references them through a foreign key12 References: 1: Balancing Data Integrity and Performance: Normalization vs … 2: Normalization Process in DBMS - GeeksforGeeks

Providing ‘one source of the truth’ means ensuring that there is a single, consistent, and authoritative source of data that can be used for analytics and decision making across the organization. This objective can be achieved by enforcing master data management principles and practices, which involve defining, governing, and maintaining the quality and integrity of the core data entities that are shared by multiple systems and processes. Master data management helps to eliminate data silos, reduce data duplication and inconsistency, and improve data accuracy and reliability12 References: 1: What is Master Data Management (MDM)? - Informatica 2: Master Data Management - IIBA BABOK Guide v3

A qualitative open-ended question is a question that allows the respondent to express their thoughts, feelings, or opinions in their own words, without being constrained by predefined options or categories. A qualitative open-ended question can help the interviewer explore the underlying reasons, motivations, or perceptions of the respondent. Option A is a qualitative open-ended question, because it asks the respondent to explain how call volume affects their job satisfaction and well-being, which may vary from person to person and require elaboration. Options B, C, and D are not qualitative open-ended questions, because they ask the respondent to choose between two alternatives (B and D) or provide a numerical value ©, which are quantitative and closed-ended responses. References:

•Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 2: Source Data

•Understanding the Guide to Business Data Analytics, page 14

•CERTIFICATION IN BUSINESS DATA ANALYTICS HANDBOOK - IIBA®, page 8, CBDA Exam Sample Questions and Self-Assessment, Question 9

The analytics team overlooked the fact that communicating information is not a one-way or one-time process, but rather a bi-directional and iterative one. This means that the team should not only present their recommendations, but also solicit feedback, address concerns, clarify doubts, and confirm understanding from the stakeholders. By doing so, the team can ensure that the stakeholders are fully engaged, informed, and aligned with the recommendations, and that any potential barriers or risks are identified and mitigated before moving forward. References:

•Understanding the Guide to Business Data Analytics, page 9

•Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 4: Interpret and Report Results

•CERTIFICATION IN BUSINESS DATA ANALYTICS HANDBOOK - IIBA®, page 5, Step 3 – Schedule and Take The Exam