1.7 BI Technology

What general type of DSS would iinclude file drawer systems, data warehouses, on-line analytical processing (OLAP) systems, and Executive Information Systems?

• Communications-Driven DSS
• Data-Driven DSS
• Document-Driven DSS
• Knowledge-Driven DSS

What should be a major characteristic of a DSS?

• Includes a spreadsheet model

• Responds quickly to the changing needs of decision makers.

• Automates decision making.

• None

The decision-making level of an organization that is most concerned with daily operations is the:

• operational level.
• Database.
• Mathematical models and analytical tools.
• User interface.

Business Intelligence and data warehousing is used for ________.

• Forecasting.

• Data Mining.

• Analysis of large volumes of product sales data.

• All of the above.

BI can catalyze a business’s success in terms of _____________

• Distinguish the products and services that drive revenues

• Rank customers and locations based on profitability

• Ranks customers and locations based on probability

• All of the mentioned

Point out the wrong statement.

• Data is factual information for analysis

• Customer relationship management (CRM) entails all aspects of interaction that a company has with its customer

• BI is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data

• None of the mentioned

Business intelligence (BI) is a broad category of application programs which includes _____________

• Decision support

• Data mining

• OLAP

• All of the mentioned

________________ in business intelligence allows huge data and reports to be read in a single graphical interface

• Reports

• OLAP

• Dashboard

• Warehouse

Data warehouse contains_____________data that is never found in the operational environment.

• normalized.

• informational.

• summary.

• denormalized.

An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.

• OLAP

• Database

• OLTP

• None