Correct Answer: D

The average time for conversion is the average number of days it takes to convert a lead into a customer. This is an important question to consider when evaluating sales performance, because it indicates the efficiency and effectiveness of the sales process. A shorter time for conversion means that the sales team can close more deals in less time, and thus increase the revenue and profitability of the company. A longer time for conversion may indicate that there are bottlenecks, challenges, or inefficiencies in the sales process that need to be addressed.

Correct Answer: C

According to the IIBA's Guide to Business Data Analytics, one of the steps in the data analysis process is to use the results to influence business decision making. This involves evaluating the feasibility, viability, and desirability of the potential options or solutions that are derived from the data analysis, and recommending the best option or solution that aligns with the business goals and objectives1. To evaluate the feasibility, viability, and desirability of the options or solutions, the data analysis team should consider the value to be delivered to specific parts of the organization and the impact of change for each one. The value to be delivered refers to the benefits, outcomes, or improvements that the option or solution will provide to the stakeholders, customers, or processes of the organization. The impact of change refers to the costs, risks, or challenges that the option or solution will entail for the implementation, adoption, or maintenance of the organization. By assessing the value and the impact of each option or solution, the data analysis team can compare and contrast the trade-offs, pros and cons, and strengths and weaknesses of each option or solution, and select the one that maximizes the value and minimizes the impact for the organization2.

The other options are not correct criteria for reaching a final recommendation. The functional unit with the most staff, the manager who wants the change the most, and the senior management are not relevant factors for evaluating the options or solutions, as they do not reflect the value or the impact of the options or solutions. The functional unit with the most staff may not be the most affected or the most important part of the organization for the data analysis project. The manager who wants the change the most may not have the authority, influence, or expertise to make the best decision for the organization. The senior management may not be the only or the final decision makers for the data analysis project, as they may delegate, consult, or collaborate with other stakeholders or experts.

Correct Answer: B

Linear bias is a type of cognitive bias that assumes a linear relationship between two variables, when in fact the relationship may be more complex or nonlinear. In this case, the analytics team assumed that the higher the discount, the higher the sales and profit, without considering other factors that may affect customer behavior, such as price elasticity, perceived quality, or competition. By changing their recommendation, the team can avoid making a suboptimal decision that may result in lower profit or customer satisfaction.

Correct Answer: B

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.

Correct Answer: D

Descriptive analytics is the type of analytics that summarizes and visualizes data to provide an overview of what has happened or is happening. Descriptive analytics uses techniques such as statistics, charts, graphs, and dashboards to display data in an understandable and meaningful way. Descriptive analytics can help analysts explore data, identify patterns, and communicate insights. Calculating theaverage, median, and mode values for a dataset is an example of descriptive analytics, as it provides a measure of central tendency for the data distribution.