Question : 51) Which among the following software tools commonly used as : 1283748

51) Which among the following software tools is commonly used as the front end for data retrieval and analysis in most business intelligence tools?

A) MS Outlook

B) MS Excel

C) MS Word

D) MS Powerpoint

52) James Wood, who works in the marketing department of the Whistlewoods hotel, has been given the responsibility of identifying patterns in the preferences of guests who have repeatedly visited the hotel in the past ten years. Which of the following would best help him categorize the massive amounts of data to reveal preferences of guests, such as type of suite, room service, etc.?

A) online analytical processing

B) goal seeking analysis

C) forecasting analysis

D) what-if analysis

53) Which of the following is a statistical technique that reveals customer behavior patterns as they purchase multiple items?

A) risk analysis

B) competitor analysis

C) predictive analysis

D) market basket analysis

54) ________ is a statistical technique that reveals customer behavior patterns as they purchase multiple items.

A) What-if analysis

B) Competitor analysis

C) Market basket analysis

D) Goal seeking analysis

55) Which of the following is a function of market basket analysis?

A) understanding behavior patterns of customers as they buy multiple items

B) helping retailers group customers from a certain geographical area

C) understanding strengths and weaknesses of competitors in the market

D) improving quality of a product after analyzing a competitor’s high-in-demand product

56) Shirley Yearwood is an analyst at a retail outlet and is required to assess customer data to understand buying patterns of customers when they purchase multiple items. What analysis process will best help her to analyze purchasing habits of customers who bought gum boots along with umbrellas, ties along with shirts, and hair clips along with headbands among other related products?

A) online analytical processing

B) market basket analysis

C) what-if analysis

D) goal seeking analysis

57) Which of the following is an accurate definition of text mining?

A) a discovery process which derives low-quality data from text

B) a discovery process in which unstructured text information is the source of business intelligence

C) a discovery process in which users can change many variables to reach a maximum or minimum target

D) a discovery process which relies heavily on sociograms, pie charts, and spin networks

58) ________ is a discovery process which relies on semantic structures, linguistic relationships, and common phrases to extract meaningful information.

A) Market basket analysis

B) What-if analysis

C) Text mining

D) Goal seeking analysis

59) Which of the following is a function of what-if analysis?

A) establishing relationships between many variables and changing some of the variables to see how the others are affected

B) establishing relationships between different variables by keeping them constant

C) encompassing a variety of statistical techniques that analyze current and historical facts to make predictions about future events

D) establishing a target value for a particular metric and telling the program which variable to change to try to reach the goal

60) ________ is a simulation model, often constructed using Excel, which calculates the relationships between many variables; users can change some variables to see how others are affected.

A) Goal seeking analysis

B) What-if analysis

C) Market basket analysis

D) Data aggregation