- (Topic 2)
An analytics team is discussing ways to improve company performance. Before identifying a set of research questions to analyze, they identify the need to understand the current company strategy and performance. The business analyst suggests using the Balanced Scorecard technique to guide this discussion. In which dimension of the matrix would the team be discussing metrics for changing and improving?
Correct Answer:
A
According to the Introduction to Business Data Analytics: An Organizational View, the Balanced Scorecard technique is a strategic management tool that helps organizations align their vision, mission, and goals with their performance measures. The Balanced Scorecard consists of four dimensions: financial, customer, internal business process, and learning and growth. Each dimension has a set of objectives, measures, targets, and initiatives that reflect the organization??s strategy and value proposition. The learning and growth dimension focuses on the metrics for changing and improving the organization??scapabilities, such as employee skills, knowledge, innovation, and culture. The learning and growth dimension supports the other three dimensions by providing the necessary resources and competencies to achieve the desired outcomes.
References: Introduction to Business Data Analytics: An Organizational View, page 9- 10; CBDA Exam Blueprint, page 7; [Balanced Scorecard Basics - Balanced Scorecard Institute]
- (Topic 2)
Which attribute in the Customerissues entity would be categorized as unstructured data?
•CustomerlD
•ConcernCategory
•ConcernSubCategory
•AgentID
•ComplaintNotes
•lssueResolved(Y/N)
Correct Answer:
A
Unstructured data is data that does not have a predefined format, structure, or schema, and that cannot be easily stored, processed, or analyzed by traditional databases or tools1. Unstructured data may include text, images, audio, video, or other types of data that are rich in information but complex and diverse in nature2. In the Customerissues entity, the ComplaintNotes attribute would be categorized as unstructured data, as it may contain free-form text that captures the details, sentiments, or emotions of the customers?? complaints, and that may vary in length, language, tone, or style. The ComplaintNotes attribute would require special techniques, such as natural language processing, text mining, or sentiment analysis, to extract meaningful insights from the unstructured data3.
The other attributes in the Customerissues entity would be categorized as structured data, as they have a predefined format, structure, or schema, and that can be easily stored, processed, or analyzed by traditional databases or tools4. Structured data may include numbers, dates, codes, categories, or other types of data that are simple and consistent in nature5. In the Customerissues entity, the CustomerlD, ConcernCategory, ConcernSubCategory, AgentID, and lssueResolved(Y/N) attributes would be categorized as structured data, as they may contain numeric, alphanumeric, or binary values that represent the identifiers, classifications, or statuses of the customers?? issues, and that may have fixed lengths, ranges, or domains.
References:1: Guide to Business Data Analytics, IIBA, 2020, p. 412: Introduction to Business Data Analytics: A Practitioner View, IIBA, 2019, p. 83: Data Analysis: The Definitive Guide, Tableau, 4: Guide to Business Data Analytics, IIBA, 2020, p. 415: Introduction to Business Data Analytics: A Practitioner View, IIBA, 2019, p. 8. : Data Analysis: The Definitive Guide, Tableau, . : Guide to Business Data Analytics, IIBA, 2020, p. 41. : Introduction to Business Data Analytics: A Practitioner View, IIBA, 2019, p. 8.
- (Topic 1)
Which attributes from the Order entity will need to be normalized to avoid redundancies?
. Orderld
. OrderDate
. Itemld
. ItemName
. Quantity
. ItemPrice
Correct Answer:
B
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
- (Topic 1)
A company wants to gauge the thoughts of their employees towards a new company product. On the 25th of March the interviewer makes a list of all employees who were at work on that day and then chooses a subset of those employees to interview. Which term describes the list of all employees present on March 25th?
Correct Answer:
C
The sampling frame is the term that describes the list of all employees present on March 25th, because it is a technique that defines the set of elements from which a sample is drawn. The sampling frame should ideally match the population of interest, which is the group of elements that the researcher wants to study or make inferences about. In this case, the population of interest is the employees of the company, and the sampling frame is the subset of employees who were at work on a specific day. The survey sample is the technique that selects a portion of the sampling frame to participate in the survey. The sample weights are the technique that assigns different values or importance to each element in the sample, based on their representation in the population. 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 14
- (Topic 2)
From a prior analytics study, a telecommunications company has concluded that due to the maturity of the market the cost of obtaining new customers is on the rise. As a result, the company wants to increase their efforts on retaining customers. One of the key performance indicators that will help them track their progress in this area is the rate at
which customers leave/unsubscribe from their services over a given time period.Which performance indicator is this referring to?
Correct Answer:
C
According to the Introduction to Business Data Analytics: A Practitioner View, churn rate is a measure of customer attrition, or the percentage of customers who stop using a product or service over a given time period. Churn rate is an important indicator of customer satisfaction, loyalty, and retention. A high churn rate implies that customers are dissatisfied or have found better alternatives, which can negatively affect the revenue and growth of a business. A low churn rate implies that customers are satisfied and loyal, which can positively affect the revenue and growth of a business. In this situation, the telecommunications company wants to increase their efforts on retaining customers, so they need to track their churn rate and try to reduce it.
References: Introduction to Business Data Analytics: A Practitioner View, page 17; CBDA Exam Blueprint, page 7; [Churn Rate Definition - Investopedia]
