Pass the IIBA Business Data Analytics CBDA Questions and answers with ExamsMirror

Descriptive and predictive analytics are types of analytics that can help with creating SMART objectives. SMART stands for Specific, Measurable, Achievable, Relevant, and Time-bound, which are criteria for setting effective and realistic goals1. Descriptive analytics is the type of analytics that summarizes what has happened in the past using data, such as historical trends, patterns, or performance2. Descriptive analytics can help with creating SMART objectives by providing a baseline, benchmark, or context for the current situation and the desired outcomes. Predictive analytics is the type of analytics that forecasts what is likely to happen in the future using data, such as statistical models, machine learning, or artificial intelligence3. Predictive analytics can help with creating SMART objectives by providing a projection, estimation, or scenario for the future situation and the expected results.

Diagnostic and prescriptive analytics are other types of analytics that are not as helpful with creating SMART objectives. Diagnostic analytics is the type of analytics that explains why something has happened in the past using data, such as root cause analysis, correlation analysis, or hypothesis testing. Diagnostic analytics can help with understanding the causes and effects of past events, but it does not provide guidance or direction for setting future goals. Prescriptive analytics is the type of analytics that recommends what should be done in the future using data, such as optimization, simulation, or decision analysis. Prescriptive analytics can help with suggesting the best actions or alternatives for achieving future goals, but it does not define or measure the goals themselves.

References:1: Introduction to Business Data Analytics: An Organizational View, IIBA, 2019, p. 122: Guide to Business Data Analytics, IIBA, 2020, p. 533: Guide to Business Data Analytics, IIBA, 2020, p. 54. : Guide to Business Data Analytics, IIBA, 2020, p. 54. : Guide to Business Data Analytics, IIBA, 2020, p. 55.

Database normalization is the process of organizing the data in a database to reduce redundancy and improve integrity, consistency, and performance1. Database normalization rules are based on the concept of normal forms, which are levels of database design that meet certain criteria2. One of the most common normal forms is the third normal form (3NF), which states that a table should not have any transitive dependencies, meaning that a non-key attribute should not depend on another non-key attribute3. In the CustomerOrder entity, the set of attributes that will need to be normalized to avoid redundancies are ProductName and ProductQuantity, as they are non-key attributes that depend on another non-key attribute, Orderld. This means that the same product information may be repeated for different orders, which could lead to data inconsistency, duplication, or update anomalies. To normalize this set of attributes, a separate table should be created for the OrderDetails entity, which would have Orderld, ProductName, and ProductQuantity as its attributes, and Orderld and ProductName as its composite primary key.

The other sets of attributes do not need to be normalized to avoid redundancies, as they do not violate the 3NF. CustomerPhone and ProductName are non-key attributes that depend on the primary key, Customerld and Orderld respectively, which is allowed by the 3NF. Orderld and ProductName are part of the composite primary key of the OrderDetails entity, which is also allowed by the 3NF. Customerld and OrderDate are both primary keys of the Customer and Order entities respectively, which are also allowed by the 3NF.

References:1: Guide to Business Data Analytics, IIBA, 2020, p. 442: Introduction to Business Data Analytics: A Practitioner View, IIBA, 2019, p. 93: Database Normalization: The Definitive Guide, Tableau, . : Database Normalization: The Definitive Guide, Tableau, . : Guide to Business Data Analytics, IIBA, 2020, p. 44. : Introduction to Business Data Analytics: A Practitioner View, IIBA, 2019, p. 9. : Database Normalization: The Definitive Guide, Tableau, . : Database Normalization: The Definitive Guide, Tableau, .

SMART is an acronym that stands for Specific, Measurable, Achievable, Relevant, and Time-bound, which are criteria for setting effective and realistic goals1. From a SMART target perspective, what is missing in this scenario is the time-frame by which the target must be met. A time-bound target specifies the deadline or the duration for achieving the target, which helps to create a sense of urgency, motivation, and accountability2. Without a time-frame, the target is vague and indefinite, and it is difficult to monitor and evaluate the progress and the results. For example, a time-bound target could be to improve the average transaction time per order by 10% within the next six months.

The other options are not correct explanations of what is missing. The target is attainable, as it is realistic and feasible, and it does not depend on factors that are beyond the control of the organization, such as weather conditions. The target is specific, as it provides a clear and precise description of what needs to be achieved, and it does not need to provide a target for each supplier, as that would make the target too complex and cumbersome. The target is relevant, as it is aligned with the goal of improving supplier relations, and it does not assume that supplier relations is only dependent on quality of deliveries, as transaction time is also an important factor that affects the efficiency, satisfaction, and trust of the suppliers.

References:1: Introduction to Business Data Analytics: An Organizational View, IIBA, 2019, p. 122: Introduction to Business Data Analytics: A Practitioner View, IIBA, 2019, p. 12. : Introduction to Business Data Analytics: An Organizational View, IIBA, 2019, p. 12. : Introduction to Business Data Analytics: A Practitioner View, IIBA, 2019, p. 12.

Storyboarding is a technique that helps the team to develop the appropriate messages to support their recommendations by creating a visual sequence of the main points, evidence, and actions. Storyboarding helps the team to organize their thoughts, identify gaps, and communicate their findings in a clear and compelling way12 References: 1: Developing Key Messages for EffectiveCommunication - MSKTC 2: 11 Ways Highly Successful Leaders Support Their Team - Redbooth

Exploratory analysis is the approach that the analytics team should use as the next step, because it is a technique that allows them to examine the quality, structure, and characteristics of the data, without making any assumptions or hypotheses. Exploratory analysis can help the team identify any issues or anomalies in the data, such as missing values, outliers, or errors, and decide how to handle them. Exploratory analysis can also help the team discover any patterns, trends, or relationships in the data, and generate new research questions or hypotheses for further analysis. References:

•Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 3: Analyze Data

•Understanding the Guide to Business Data Analytics, page 16

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

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

Descriptive analytics is a type of analytics that summarizes and visualizes the data to provide an overview of what has happened or is happening, such as the trend of winter-related accidents over the past three years, or the percentage of drivers using winter tires12. Diagnostic analytics is a type of analytics that explores and analyzes the data to understand why something has happened or is happening, such as the primary reasons for these accidents, or the factors that influence the drivers’ decisions13. To answer the question, both descriptive and diagnostic analytics would be needed to provide the relevant information and insights for the company. References: 1: Guide to Business Data Analytics, IIBA, 2020, p. 182: Business Analytics: Data Analysis & Decision Making, S. Christian Albright and Wayne L. Winston, 2015, p. 53: Data Science for Business, Foster Provost and Tom Fawcett, 2013, p. 13.

The relationship between a Customer entity and an Order entity, where a customer entry will be present in the Customer entity only if they have made an order, is a zero-to-one relationship. This means that for each record in the Order entity, there can be either zero or one record in the Customer entity that is related to it. This implies that the Order entity is optional for the Customer entity, and the Customer entity is mandatory for the Order entity12 References: 1: A Guide to the Entity Relationship Diagram (ERD) - Database Star 2: Developing an Application - Oracle

The information layer is the layer that connects the business processes to data analytics. It consists of the data models, data quality, data governance, and data security that enable the data to be accessed, analyzed, and transformed into insights. The information layer also supports the communication and collaboration among the stakeholders involved in the data analytics process. The other layers are the physical layer, which deals with the hardware and software components of the data infrastructure; the technical layer, which handles the data integration, data storage, data processing, and data analysis techniques; and the infrastructure layer, which provides the network, cloud, and security services for the data environment12 References: 1: Data and Analytics (D&A) - Gartner 2: Enterprise Data Analytics - SelectHub

The median is the type of statistics average that the analyst should use to best represent the results, because it is a measure of central tendency that divides the data set into two equal halves. The median is the middle value of the data set when it is arranged in ascending or descending order. The median is not affected by extreme outliers, unlike the mean, which is the arithmetic average of the data set. The median can give a more accurate representation of the typical score of the 8th grade students across the three schools. Options B, C, and D are not types of statistics average, but types of statistics measures that describe other aspects of the data set. The range is a measure of dispersion that shows the difference between the highest and the lowest values of the data set. The mean is a measure of central tendency that shows the sum of the values of the data set divided by the number of values. The mode is a measure of central tendency that shows the most frequent value of the data set. References:

•Business Analysis Certification in Data Analytics, CBDA | IIBA®, CBDA Competencies, Domain 3: Analyze Data

•Understanding the Guide to Business Data Analytics, page 17

•Business Data Analytics (IIBA®-CBDA Exam preparation) | Udemy, Section 3: Analyze Data, Lecture 13: Descriptive Statistics