Chapter 11: Business Intelligence and Knowledge mgt

45. A dynamic _____ application responds to commands by composing tables "on the fly."

online analytical processing (OLAP)

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

SQL Server

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

False

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

CRM systems

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

Dashboards

59. What are the objectives of data mining?

Data mining has four main objectives: Sequence or path analysis: Finding patterns where one event leads to another, later event. Classification: Finding whether certain facts fall into predefined groups. Clustering: Finding groups of related facts not previously known. Forecasting: Discovering patterns in data that can lead to reasonable predictions.

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

False

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

False

26. 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 . a. XML b. FTP protocols c. SQL queries d. SGML

SQL queries

51. ------ is a process by which one starts with a table that shows broad information and successively retrieves tables of more specific information.

drilling down

50. An organization can learn much about its customers, sellers, and itself by mining data warehouses and using OLAP software, but such techniques still do not satisfy another important challenge: how to manage _____.

knowledge

54. Knowledge management tools build _____ and help employees access them.

knowledge bases

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

knowledge management

56. ______ tools help extract useful knowledge from millions of web documents.

knowledge management

53. The research company IDC argues that almost half of the work that do in organizations has already been done, at least partially.

knowledge workers

44. ------ is a data-mining application that understands what products or services are commonly purchased together, and on what days of the week.

market basket analysis

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

mine

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

online resources

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

transactional database

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

true

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

true

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

true

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

true

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

true

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

true

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

true

8. Online analytical processing (OLAP) is increasingly used by corporations to gain efficiencies. a. True b. False

true

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

20,000

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

auto categorization

58. Practically all search engine sites, such as Google and Yahoo!, use _____ software, and continue to improve the software to provide more precise and faster responses to queries.

autocategorization

30. A major effort of most businesses, especially retail businesses, in using customer relationship management (CRM) systems is to collect _____ about customers. a. artificial intelligence b. business intelligence c. personal information d. knowledge management parameters

business intelligence

43. One objective of data mining is _____, the finding of groups of related facts not previously known.

clustering

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

dashboard

49. Business intelligence _____ help executives quickly receive metrics, ratios, and trends in mostly graphic format.

dashboards

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

data mining

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

data mining

41. ______ is the process of selecting, exploring, and modeling large amounts of data to discover previously unknown relationships that can support decision making.

data mining

42. While data has traditionally been used to see whether this or that pattern exists, _____ allows you to ask what patterns exist.

data mining

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

knowledge

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

Business Intelligence

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

Knowledge management

57. ____ automates the classification of data into categories for future retrieval.

Autocategorization

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

OLAP

47. _____ Applications can easily answer questions such as, "Where are my weakest performing sales offices?" and "What products are selling well?"

Online analytical processing (OLAP)

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

data warehouses

52. Knowledge management attempts to transfer individual knowledge into .

databases

24. 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 . a. house databases b. information silos c. relational applications d. dimensional databases

dimensional databases

46. In ------ , the raw data is organized in tables that show information in summaries and ratios so that the inquirer does not have to wait for processing raw data.

dimensional databases

20. 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 . a. trend analysis b. customer churn c. consumer clustering d. direct marketing

direct marketing

55. Some software companies, such as Tacit Systems, Hivemine, and Safeharbor Knowledge Solutions have developed ____ , tools that facilitate knowledge sharing through intranets.

employee knowledge networks

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

false

15. Information technology impedes the turning of knowledge into routine. a. True b. False

false

4. 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

5. Trend analysis refers to the identification of characteristics of transactions that are most likely to be fraudulent. a. True b. False

false

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

forecasting

33. 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. a. data marts b. clickstream software c. programming languages d. interfaces

interfaces

48. Intelligent _____ allow employees to enter questions in free form or close to free form.

interfaces

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

semantic layer

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

spyware