- (Topic 2)
The research study is complete, the data has been analyzed and the team has created the necessary high impact visuals.The business analysis professional urges the team to:
Correct Answer:D
Developing the narrative is the process of creating a clear, concise, and compelling story that communicates the key insights, findings, and recommendations from the data analysis to the stakeholders1. Developing the narrative is an important step after completing the research study, the data analysis, and the high impact visuals, as it helps to bridge the gap between the data and the decision-making, to engage and persuade the audience, and to drive action and change2. Developing the narrative involves defining the purpose, audience, and message of the story, choosing the best format and medium to deliver the story, and using effective storytelling techniques, such as structure, context, emotion, and call to action3.
Presenting the results to stakeholders is the process of delivering the data story to the intended audience, using the appropriate communication channels, methods, and tools4. Presenting the results to stakeholders is a subsequent step after developing the narrative, as it requires a well-crafted and well-prepared data story to be effective and impactful. Presenting the results to stakeholders involves planning and rehearsing the presentation, adapting to the feedback and questions, and evaluating the outcomes and impacts of the presentation5.
Validating regression analysis is the process of checking the assumptions, accuracy, and suitability of a statistical model that estimates the relationship between one or more independent variables and a dependent variable. Validating regression analysis is a part of the data analysis step, not a step after completing the data analysis. Validating regression analysis involves testing the significance, fit, and residuals of the model, and comparing the model with alternative models or methods.
Curating the data is the process of organizing, annotating, and preserving the data for future use, reuse, or sharing. Curating the data is a part of the data management step, not a step after completing the data analysis. Curating the data involves applying the data policies, standards, and best practices of the organization, and ensuring the quality, integrity, security, and accessibility of the data.
References:1: Guide to Business Data Analytics, IIBA, 2020, p. 572: Introduction to Business Data Analytics: An Organizational View, IIBA, 2019, p. 153: Data Storytelling: The Definitive Guide, Tableau, 4: Guide to Business Data Analytics, IIBA, 2020, p. 585: Introduction to Business Data Analytics: A Practitioner View, IIBA, 2019, p. 27. : Guide to Business Data Analytics, IIBA, 2020, p. 55. : Data Analysis: The Definitive Guide, Tableau,. : Guide to Business Data Analytics, IIBA, 2020, p. 45. : Data Management: The Definitive Guide, Tableau, . : Data Storytelling: The Definitive Guide, Tableau, . : Guide to Business Data Analytics, IIBA, 2020, p. 57. : Introduction to Business Data Analytics: An Organizational View, IIBA, 2019, p. 15. : Data Storytelling: The Definitive Guide, Tableau, .
: Guide to Business Data Analytics, IIBA, 2020, p. 58. : Introduction to Business Data Analytics: A Practitioner View, IIBA, 2019, p. 27. : Guide to Business Data Analytics, IIBA, 2020, p. 55. : Data Analysis: The Definitive Guide, Tableau, . : Guide to Business Data Analytics, IIBA, 2020, p. 45. : Data Management: The Definitive Guide, Tableau, .
- (Topic 1)
With the recent departure of two of its employees, an IT helpdesk team is now understaffed and finding it difficult to keep up with the current workload. The number of tickets being received has increased as well as the number of days to resolve the tickets. The IT manager has set up a meeting with the IT director to request funding for two new helpdesk agents. To prepare for the meeting, the manager is interested in showing the tickets processed against ticket volume over the past year. What type of chart should the manager use to effectively show the change in processing rate over time?
Correct Answer:C
A line chart is the type of chart that the manager should use to effectively show the change in processing rate over time, because it is a technique that displays data as a series of points connected by straight lines. A line chart can help the manager visualize the trends and patterns in the ticket volume and processing rate over the past year, and highlight the widening gap between them. A line chart can also show the seasonal variations and fluctuations in the data, and compare the performance of different categories or groups. Options A, B, and D are not suitable for showing the change in processing rate over time, because they are techniques that display data as proportions (A), comparisons (B), or accumulations (D) of different categories or groups at a single point in time or over a fixed period. References:
•Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 4: Interpret and Report Results
•Understanding the Guide to Business Data Analytics, page 18
•16 Best Types of Charts and Graphs for Data Visualization [+ Guide]
- (Topic 1)
An organization's customers are categorized based on the amount of purchases completed over the last 12 months. The analytics team would like to ensure the accuracy of their survey results and decide to randomly select 500 customers to participate in a survey from this large pool of customers. This is an example of:
Correct Answer:A
Stratified sampling is a technique that divides the population into homogeneous subgroups (strata) based on a relevant characteristic, such as the amount of purchases, and then randomly selects a proportional number of elements from each subgroup to form the sample. Stratified sampling ensures that the sample is representative of the population and reduces the sampling error and bias12. References: 1: Guide to Business Data Analytics, IIBA, 2020, p. 312: Statistics for Business and Economics, David R. Anderson et al., 2014, p. 262.
- (Topic 1)
A lab is conducting a study on protein interactions. They have used the data to create a graph visualization. In graph visualization, what would a layout be?
Correct Answer:C
A layout is a way of arranging the nodes and links of a graph visualization to convey meaningful information about the data. A layout is determined by a dedicated algorithm that calculates the node positions based on certain criteria, such as minimizing edge crossings, maximizing node spacing, or emphasizing clusters12. A layout can also be influenced by user interaction, such as zooming, panning, or dragging3. References: 1: Guide to Business Data Analytics, IIBA, 2020, p. 642: Graph Drawing: Algorithms for the Visualization of Graphs, Giuseppe Di Battista et al., 1999, p. 33: Interactive Data Visualization: Foundations, Techniques, and Applications, Matthew O. Ward et al., 2015, p. 227.
- (Topic 2)
The finance manager has reported that customers are taking much longer to remit payments this year than last. They would like help in finding a solution to address the situation. One suggestion was to offer a 10% discount to entice customers to pay their invoices in full within the first 30 days. Before offering the discount, the finance manager would like the analytics team to do some research to determine if there is value in addressing the accounts receivable problem. Which of the following is a valid question to ask in this situation?
Correct Answer:A
According to the Guide to Business Data Analytics, one of the steps in conducting business data analytics is to identify the research questions that will guide the analysis and help answer the business problem or opportunity. The research questions should be relevant, specific, measurable, achievable, and testable. In this situation, the business problem is the delay in customer payments and the potential solution is to offer a discount. A valid question to ask in this situation is whether discounts have been offered before, and if so, what was the effect on customer behavior and profitability. This question is relevant because it can help assess the feasibility and effectiveness of the proposed solution. It is also specific, measurable, achievable, and testable, as it can be answered by collecting and analyzing historical data on customer payments and discounts.
References: Guide to Business Data Analytics, page 47-48; CBDA Exam Blueprint, page 7; [Introduction to Business Data Analytics: A Practitioner View], page 15.
- (Topic 1)
A call center has requested to review their sales conversion data for the month. The analyst working on this request is trying to identify the chart that will effectively present the data, which includes: the number of leads, the number of calls made, the number of calls completed, the number of customers interested and the number of sales. What chart should the analyst use to show the values across each stage of the pipeline?
Correct Answer:B
A funnel chart is a type of chart that shows the values of different stages of a process, such as a sales pipeline, where each stage represents a subset of the previous one. A funnel chart is useful for showing the conversion rate, the drop-off rate, and the potential revenue or profit at each stage12. A funnel chart would be an effective way to present the data requested by the call center, as it would show the number of leads, calls, customers, and sales, as well as the percentage of change between each stage. References: 1: Guide to Business Data Analytics, IIBA, 2020, p. 662: Data Visualization: A Practical Introduction, Kieran Healy, 2018, p. 233.