MIS 309 CH 9 EXAM 2

Which of the following statements is TRUE of source data for a business intelligence (BI) system?

It refers to data that the organization purchases from data vendors.

________ analysis is a way of analyzing and ranking customers according to their purchasing patterns.

RFM

________ is a BI application that inputs data from one or more sources and applies reporting operations to that data to produce business intelligence.

A reporting application

Define business intelligence (BI) and BI systems.

Business intelligence (BI) systems are information systems that process operational, social, and other data to identify patterns, relationships, and trends for use by business professionals and other knowledge workers.

Which of the following statements is TRUE about data marts?

Data marts address the needs of a particular department or functional area of a business.

T/F: A data mart is larger than a data warehouse.

FALSE

T/F: Data mart is another term used for a data warehouse.

FALSE

T/F: It is better to have data with too coarse a granularity than too fine.

FALSE

________ is a term that refers to the level of detail represented by the data.

Granularity

T/F: Business intelligence (BI) systems have five standard components called hardware, software, data, procedures and people.

TRUE

T/F: Data warehouses may include data that is purchased from outside sources.

TRUE

T/F: Granularity is a term that refers to the level of detail represented by the data.

TRUE

T/F: Operational data is structured for fast and reliable transaction processing.

TRUE

T/F: Push publishing can deliver results according to a schedule or as a result of an event or particular data condition.

TRUE

T/F: The three primary activities in the business intelligence (BI) process are to acquire data, perform analysis, and publish results.

TRUE

________ is defined as information containing patterns, relationships, and trends of various forms of data.

business intelligence

Capturing customers' clicking behavior is referred to as ________.

clickstream data

Which of the following phenomena states that the more attributes there are, the easier it is to build a model that fits the sample data?

curse of dimensionality

________ is the process of obtaining, cleaning, organizing, relating, and cataloging source data.

data acquisition

Which of the following is a fundamental category of business intelligence (BI) analysis?

data mining

A particular BI analysis might require data from an ERP system, an e-commerce system, and a social networking application, but such a data collection will likely have relationships that are not represented in primary key/foreign key relationships. This is an example of ________.

data not integrated

A ________ takes data from the data manufacturers, cleans and processes the data, and locates the data on the shelves.

data warehouse

In large organizations, a group of people manage and run a(n) ________, which is a facility for managing an organization's BI data.

data warehouse

Problematic operational data is termed as ________.

dirty data

When an area code changes the phone number for a given customer before the change will not match the customer's number afterward. This is an example of ________.

inconsistent data

A data ________ is a data collection, smaller than the data warehouse that addresses the needs of a particular department or functional area of the business.

mart

________ refers to the source, format, assumptions and constraints, and other facts about the data.

metadata

________ requires the user to request business intelligence (BI) results.

pull publishing

________ delivers business intelligence to users without any request from the users.

push publishing