Certification in Business Data Analytics (IIBA - CBDA) Questions and Answers
A government agency is conducting a study on the performance of 12th grade students' in mathematics across the country. In particular, they want to understand if there is a relationship between intelligence and scores, as well as the difference in performance between various locations. Which combination of inferential statistics procedures should be used?
Operation managers are concerned about the increasing attrition rates in the call center. A series of interviews is being conducted with call center agents to collect information to better understand the problem. Interviewees will ask open and closed ended questions that are both quantitative and qualitative. Which of the following is considered a qualitative open-ended question?
To gain traction on online sales, a retailer initiated a marketing campaign using banner ads. The company has requested their analytics team to evaluate the performance of the campaign. During the presentation, the analyst confirmed that the campaign did bring in a large number of net new customers to the website and met the target sales conversion rate. They also noted that there was a high number of repeat visitors not completing a sale. What decision would help the retailer improve sales conversion rates for repeat visitors?
A business analyst manager is planning budgets for the new year, and training opportunities for his team of business analysts. The manager sends out a survey to the team to obtain their top interests within the seven areas of training opportunities. The team results were compared against the manager's personal rating. What can be deduced from the following chart with regards to the
survey results?
An analytics team has been asked to answer the following question: "Given that you're a customer, would you work at our company?" The team is concerned about answering this question because it is:
Senior executives in a large organization receive numerous sales reports of every sale through a corporate dashboard on a weekly basis. The executives are considering budget increases for various functions but would like to know if they are obtaining good returns for current budget allocations. They ask the analytics team to research and answer: "How effective is our marketing
spend?" This question is:
The analytics team has established two equally strong potential recommendations which will deliver the desired outcomes with similar benefits to be derived from each one. On the surface there is no discernable difference in costs or schedule for either option. To help the analytics team reach a recommendation the business analysis professional recommends the team:
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:
The research question prompting the use of analytics is well-defined. The team obtains the results and determines that the source data did not provide reliable results. As a result of this finding, the team modifies the original question to one that can be answered by the data. What is a risk that could impact the value of this analysis?
The results for a certification exam were revealed in percentage and percentile. The results for one of the attendees was: 75%, 90th percentile. What is the value in sharing the percentile score?
A dataset contains 10 measures of workplace sustainability. The analytics team is in need of producing a single score of sustainability. Which of the following techniques if used would achieve this objective?
A consumer goods manufacturer has recently completed an analytics study to understand how to improve its operational excellence. From the top highlights, online sales outperformed other channels in sales growth and there was a direct relationship between positive customer reviews and increased internet sales. Which strategic business decision may be logically derived from
these results?
An analytics team employed at a leading credit card company is utilizing data analytics to identify unusual credit card purchases.
They have created the following visual. How many extreme outliers exists in this dataset?
The team has completed their analysis on a vast amount of collected data and agree on their recommendations for action.
However, they are having difficulty in developing the appropriate messages to support their recommendations. The business analysis professional suggests which technique to assist the team?
A job satisfaction survey is being developed. Half of the employees will be asked the question "Do you enjoy working in your workplace?" The other half will be asked "Do you like the current work benefits?". The business analyst raises concern over the survey. What is concerning to the business analyst?
An analyst has just completed building a data model that shows the table structures including table names, table relationships
with primary and foreign keys and column names with respective data types. What type of data model has the analyst just built?
A large car manufacturer is interested in comparing the number of sales for a specific model of electric car across all 50 US states.
The data analytics team sourced and acquired the data, and the business analyst created the model to compare sales across states.
In a meeting to review the results, the feedback received included several complaints concerning an inability to distinguish the number of sales per state. What model would result in such confusion?
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?
The analytics team is struggling with which recommendation to make. Their challenge is that they have five good options and this indecision is stopping them from moving forward. To help the team finalize their recommendation, the BA professional on the team recommends they complete:
An analyst is looking at a particular dataset that includes the scores across all 8th grade students, across three schools. The analyst is trying to determine which type of statistics average to use to best represent the results. On looking through the dataset, the analyst has identified a few extreme outliers. As a result, the analyst was led to use the following type of average:
The interplay between enterprise systems and data analytics can be envisioned at various layers. The layer that connects the business processes to data analytics is the:
The architecture team puts forth a solution architecture that integrates multiple data sources from within and outside the organization. The architecture provides the foundation to source a new analytics program. If one of the objectives of the analytics team was to provide 'one source of the truth', this objective would be referring to which of the following?
