ch 11

OLAP applications can process records per second. a. 10,000 b. 20,000 c. 30,000 d. 40,000

20,000

Both data-mining and OLAP software are often integrated into for the purpose of collecting business intelligence about customers. SCM systems b. ERP systems c. CRM systems d. HRM systems

CRM Customer relationship management

describes the role of IT in an organization. IT vision b. IT tactical plans c. IT strategy outlines d. IT mission statement

IT mission statement

enables managers to see summaries and ratios of the intersection of any two dimensions in a database. CRM b. SCM c. OLAP d. CAD`

OLAP

Since OLAP applications are designed to process large amounts of records and produce summaries, they are usually significantly faster than relational applications such as those using . XML b. FTP protocols c. SQL queries d. SGML

SQL Queries

BI software has become so popular in large companies that Microsoft decided to integrate such software into its popular database management system, . SQL Server b. MySQL c. DB2 d. DBMS

SQL Server

key performance indicators

a business' strategic initiatives evaluated to determine the costs, savings, and benefits to be derived from their implementation

total cost of ownership (TCO)

a financial estimate for business leaders to objectively and accurately evaluate the direct and indirect costs of a new organizational project

systems analysis

a five-step process Investigation Technical feasibility study Economic feasibility study Operational feasibility study Requirements definition

data warehouse

a large database containing historical transactions and other data

feasibility studies

a larger analysis conducted after preliminary results indicate an IS is warranted

employee knowledge network

a tool that facilitates knowledge sharing through intranets

online analytical processing OLAP

a type of application used to exploit data warehouses Provides extremely fast response times Allows a user to view multiple combinations of two dimensions by rotating virtual "cubes" of information used to gain efficiencies

agile methods

alternative development methods Treat software development as series of contacts with users Goal: fast software development Improve software after user requests for modifications received

dashboard

an interface between BI tools and the user Resembles a car dashboard Contains visual images to quickly represent specific business metrics of interest to management Helps management monitor revenue and sales, monitor inventory levels, and pinpoint trends and changes over time

To group knowledge into manageable data, companies use software. clickstream b. autocategorization c. data mining d. OLAP

autocategorization

autocategorization

automates classification of data into categories for future retrieval Used by companies to manage data Used by most search engines Constantly improved to yield more precise and faster results

phased conversion

breaks the new IS into modules and integrates one at a time Reduces risk but delays some benefits

A major effort of most businesses, especially retail businesses, in using customer relationship management (CRM) systems is to collect about customers. © 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. Chapter 11: Business Intelligence and Knowledge Management artificial intelligence b. business intelligence c. personal information d. knowledge management parameters

business intelligence

The meaningful information gleaned from data warehouses using software tools is referred to as . raw data b. business intelligence c. unstructured data d. performance indicators`

business intelligence

is a structured, disciplined approach that facilitates the adoption of new or modified systems by various groups and individuals within an organization. Prototyping b. Data mining c. Change management d. Knowledge extraction

change management

mission statement

communicates the most important overarching goal of an organization

The popular name of an interface for business intelligence tools is . whiteboard b. command line interface c. dashboard d. graphic user interface

dashboard

______are often designed to quickly present predefined business metrics, such as occupancy ratios in hotels and hospitals, or inventory turns in retail. Performance indicators b. Dashboards c. Toolboxes d. Shared whiteboards

dashboards

dimensional database

data is organized into tables showing information summaries

In banking, is employed to find profitable customers and patterns of fraud. resource recovery b. information integration c. web scraping d. data mining

data mining

Some companies use techniques to try to predict what customers are likely to purchase in the future. data-mining b. web scraping c. knowledge extraction d. information integration

data mining

Organizations must use software tools to process data into meaningful information to make useful. data warehouses b. information silos c. decision systems d. expert systems

data warehouses

unified modeling language

de facto standard for visualizing, specifying, and documenting software Helps developers communicate and logically validate desired features Is independent of programming languages Provides standard symbols and notations for depicting object-oriented elements

implementation

delivery of a new system Steps include: Conversion Training Training may or may not precede conversion

data flow diagram (DFD)

describes the flow of data in a business operation using four symbols External entities: individuals and groups external to the system (customers, employees, etc.) Processes: an event or events that affect data Data store: any form of data at rest Direction of data flow: indicates how data moves

system requirements

detail the functions and features expected from the new system

return on investment

difference between the stream of benefits and the stream of costs over the life of the system

OLAP applications are usually installed on a special server that communicates with both the user's computer and the server or servers that contain a data warehouse or . house databases b. information silos c. relational applications d. dimensional databases

dimensional databases

The data-mining application that identifies which prospective clients should be included in a mailing or email list to obtain the highest response rate is known as . trend analysis b. customer churn c. consumer clustering d. direct marketing

direct marketing

Companies find that the data that they collect directly from consumers provides a full picture of customer needs. True False

false

Consumer clustering refers to the prediction of what each individual accessing a website is most likely to be interested in seeing.

false

Cut-over conversion reduces risks because it confines any problems to fewer units. True False

false

Direct marketing is a data-mining application that identifies the reasons customers switch to competitors and predicts which customers are likely to do so.

false

If the return on investment (ROI) of an economic analysis is negative, the system is economically feasible, or cost justified. True False

false

In Extreme Programming (XP), the initial software is developed over a period of several months with intense research and preparation. True False

false

Information technology impedes the turning of knowledge into routine.

false

It is often considered simple to integrate disparate legacy systems of several companies. True False

false

Knowledge management software makes storage and organization of unstructured data more of a challenge. True False

false

Online analytical processing (OLAP) applications are powerful tools created specifically for shift employees. True False

false

State charts represent highly active states that are triggered by completion of the actions of other states. True False

false

The IT mission includes the ideal combination of hardware, software, and networking to support the corporation. True False

false

The systems analysis phase is a three-step process. True False

false

Trend analysis refers to the identification of characteristics of transactions that are most likely to be fraudulent.

false

prototyping

fast development of an application based on initial user requirements

One objective of data mining is _____, the discovering of patterns in data that can lead to reasonable predictions. seeding b. producing c. forecasting d. recovering

forecasting

systems development life cycle

framework Also known as "waterfall" development Major sequential phases of SDLC Analysis Design Implementation Support

knowledge management

gathering, organizing, sharing, analyzing, and disseminating knowledge to improve an organization's performance. knowing where to find information about the subject

organizational culture

general tone of the corporate environment Must determine the new system's compatibility with the organizational culture

fraud detection

identify characteristics of transactions that are most likely to be fraudulent

consumer clustering

identify the common characteristics of customers who tend to buy the same products and services rom your compnay

customer churn

identify the reason customers switch to competitors; predict which customers are likely to switch

direct marketing

identify which prospective clients should be included in a mailing or email list to obtain the highest response rate

cut-over conversion

immediately replaces all modules Risky but may be inexpensive

systems design

includes three steps for devising the means to meet all the requirements Description of the components Construction Testing

application systems support

includes two responsibilities Maintenance: post-implementation debugging, updates, and adding postponed features User help

business intelligence(business analytics)

information gleaned with information analysis tools

To make the use of BI tools convenient for executives, companies that develop BI tools create that help the executives to quickly grasp business situations. data marts b. clickstream software c. programming languages d. interfaces

interfaces

Information that can be gleaned from stored data is . knowledge b. experience c. intelligence d. wisdom

knowledge

The purpose of is mainly to learn where to find information about a given subject. knowledge management b. data mining c. business analytics d. business intelligence

knowledge management

______is the attempt by organizations to put procedures and technologies in place to transfer individual knowledge into databases. Data mining b. Knowledge management c. Knowledge extraction d. Data warehousing

knowledge management

Data warehouses could be regarded as a type of , where new useful information is the precious find. vault b. mine c. reservoir d. wheel

mine

A is a paragraph that communicates the most important overarching goal of the organization for the next few years. mission statement b. corporate value c. financial statement d. scenario plan

mission statement

Some companies require workers to create reports of their finding to transfer knowledge into manageable . folders b. dictionaries c. online resources d. indexes

online resources

iinteractive marketing

predict what each individual accessing a website is most likely to be interested in seeing

knowledge workers

research, prepare, and provide information There is much overlap in the work they do

trend analysis

reveal the difference between a typical customer this month and a typical customer last month

The part of the BI software application that parses the questions entered by employees is known as the . semantic layer b. data link layer c. network layer d. session layer

semantic(language) layer

cost/ benefit analysis

spreadsheet showing all costs and benefits of the proposed system

Companies such as Razorfish, DoubleClick, and Engage Software use to collect consumer data. riskware b. malware c. middleware d. spyware

spyware

conversion

switching from the old system to the new system Can be a very difficult time

outsourcing

the formal business relationship to transfer internal business processes and functions to a third-party business

parallel conversion

the old system is used simultaneously with the new system at first

Data mining

the process of selecting, exploring, and modeling large amounts of data Used to discover relationships that can support decision making

Drilling down

the process of starting with broad information and then retrieving more specific information as numbers or percentages

clickstream software

tracks and stores data about every visit to a website

OLAP might process data from a . non-relational database b. cloud database c. navigational database d. transactional database

transactional

A small ad hoc team usually performs a quick preliminary investigation to determine the need for a new system. True False

true

Agile methods make extensive use of iterative programming. True False

true

Agile methods treat software development as a series of contacts with users. True False

true

By compiling billions of consumer clickstreams and creating behavioral models, companies can determine individual consumers' interests from the sites they visited. True False

true

Consumers' opinions on products and services posted online are sources of knowledge from the web. True False

true

Data-mining software searches through large amounts of data for meaningful patterns of information. True False

true

Expertise in narrow domains can be programmed in expert systems. True False

true

It is difficult, if not impossible, to devise a way to measure software development competence. True False

true

Knowledge management is the attempt by organizations to put procedures and technologies in place to filter and separate the most relevant knowledge. True False

true

Loyalty programs, such as frequent flier and consumer clubs, help organizations amass a steady flow of data about their customers.

true

One objective of data mining is classification: Finding whether certain facts fall into predefined groups. True False

true

Online analytical processing (OLAP) is increasingly used by corporations to gain efficiencies.

true

Organizational culture includes issues such as tendency to share or not to share information among units and people, willingness to team-play, and the proclivity of employees to experiment with new ideas and technologies. True False

true

SDLC stands for systems development life cycle. True False

true

The systematic approach of the SDLC is recommended if the system is complex and consists of many modules. True False

true

When planning, it is important to align IT strategies with the overall strategies of the organization. True False

true

While data flow diagrams are easy to learn and use, they cannot describe a system completely. True False

true

market basket analysis

what products are purchased together