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