IIBA
CBDA
Q1:
A marketing department has established an analytics team. The analytics practice is stand-alone and analysts have limited insights into corporate strategy. Which is an expected result for analytics practices operating at the business unit level?
○
A
Analytics work will be driven by the organization's business plan○
B
Insights derived from data analysis will be used to guide strategic decisions○
C
The analytics team may conduct analysis that is of minimal value to the organization○
D
The organization will use analytics as a means to obtain a competitive advantageExplanation:
According to the IIBA Guide to Business Data Analytics, analytics practices operating at the business unit level are characterized by a lack of alignment with the organization's strategic objectives, a limited scope of analysis, and a siloed approach to data and insights1. This can result in analytics work that is not relevant, timely, or impactful for the organization as a whole, and that may not address the most critical business problems or opportunities.Therefore, the analytics team may conduct analysis that is of minimal value to the organization, or even detrimental if it leads to suboptimal decisions or actions.
IIBA
CBDA
Q2:
What is the relationship between a Customer entity and an Order entity, where a customer entry will be present in the Customer entity regardless of whether an order was made?
○
A
zero-to-one○
B
many-to-many○
C
zero-to-many○
D
one-to-oneExplanation:
A zero-to-many relationship between two entities means that one instance of the first entity can be associated with zero or more instances of the second entity, and one instance of the second entity can be associated with only one instance of the first entity1. In this case, a customer entry will be present in the Customer entity regardless of whether an order was made, which means that a customer can have zero or more orders, but an order can only belong to one customer.Therefore, the relationship between Customer and Order is zero-to-many.
IIBA
CBDA
Q3:
A large bank has recently revamped their website, adding additional features such as financial investment opportunities, spending activity, and supporting reports. Which question will add value when evaluating how the website is being used?
○
A
What is the customer satisfaction rating across the branches?○
B
What are the top keywords used in searches made within the website?○
C
What is the customer retention rate since the website launch?○
D
How many articles were published since the website launch?Explanation:
Customer retention rate is a measure of how many customers continue to use a product or service over a given period of time. It is an important indicator of customer loyalty, satisfaction, and value. Customer retention rate can help the bank evaluate how the website is being used by comparing the number of customers who visited the website before and after the launch of the new features. A high customer retention rate would suggest that the new features are attractive, useful, and engaging for the customers, while a low customer retention rate would indicate that the new features are not meeting the customers' needs or expectations. Customer retention rate can also help the bank identify the segments of customers who are more or less likely to use the website, and tailor their marketing and communication strategies accordingly.Reference:
Certification in Business Data Analytics (IIBA - CBDA), IIBA, accessed on January 20, 2024.
Business Data Analytics Certification - CBDA Competencies | IIBA, IIBA, accessed on January 20, 2024.
Guide to Business Data Analytics, IIBA, 2020, p. 23-24.
What is Customer Retention Rate? | HubSpot, HubSpot, accessed on January 20, 2024.
IIBA
CBDA
Q4:
A private school has decided to include bullet charts in students' end of year performance report. It will depict the student's score against the highest score achieved in that grade, and the qualitative category that the student's score falls under. Should a column chart be used instead?
○
A
Both charts are insufficient in meeting the requirements of a student score card○
B
Both charts can be used as a column chart is a comparable alternative to a bullet chart○
C
Yes, a column chart would be a better option to depict all three criteria in one chart○
D
No, a bullet chart is a good option as it will depict all three criteria in one chart
IIBA
CBDA
Q5:
DIAGRAM TAKEN
Customer Satisfaction
120%
100%
80%
○
A
The 2018 customer satisfaction rate is at 90%. between good and excellent, and exceeded its target of 70%○
B
The 2018 customer satisfaction rate is at 90%. between good and excellent○
C
The 2018 customer satisfaction rate was fair, at 70%, and did not reach its target of 90%○
D
The 2018 customer satisfaction rate is at 90%. between good and excellent, while the 2017 customer satisfaction rate was at 70%Explanation:
A bullet chart is a type of bar chart that shows progress towards a goal or performance against a reference line1.It consists of a bar representing the featured measure, a reference line denoting a target or threshold, and a background with qualitative ranges (such as poor, fair, good, excellent)2. In this case, the featured measure is the customer satisfaction rate for 2018, the reference line is the target of 70%, and the background ranges are 0-50% (poor), 50-70% (fair), 70-90% (good), and 90-120% (excellent). The chart also shows a thin black bar representing the customer satisfaction rate for 2017, which can be used for comparison. From the chart, we can see that the 2018 customer satisfaction rate is at 90%, which falls in the excellent range and exceeds the target of 70%. We can also see that the 2017 customer satisfaction rate was at 70%, which falls in the good range and meets the target.Therefore, the correct answer is D, as it summarizes both the 2018 and 2017 customer satisfaction rates and their relation to the target and the ranges.