MIS Final

What is a social​ graph? A. an online graph that shows which persons have multiple accounts on more than one social media site B. A mapping of all significant online social relationships C. A mapping of online​ social/retail relationships D. A mapping of all significant online retail relationships E. An online graph of online social media as the relationships intermingle.

B. A mapping of all significant online social relationships

In an enterprise​ system, the integrated software modules that focus on procurement and inventory management are related to​ ________. A. human resources B. sales and marketing C. manufacturing and production D. instructional technology E. finance and accounting

C. manufacturing and production

A​ ________ is a component in the computer system data hierarchy that consists of multiple records of the same type. A. byte B. record C. file D. field E. bit

C. file

A​ ________ provides the link from one table to another​ table's primary key. A. data key B. referential key C. foreign key D. primary key E. surrogate key

C. foreign key

The iPhone voice Siri is a type of​ ________. A. instructional scope B. intelligent scope C. intelligent agent D. bot E. intelligent arm

C. intelligent agent

record

A group of related fields in a database, such as all the contact information for an individual.

A​ ________ is a component in the computer system data hierarchy that includes content such as Student ID​ 100, Course IS​ 101, and Grade A. A. file B. record C. field D. byte E. bit

C. field

According to the​ E-Commerce Presence​ Map, activities such as conversation and engagement are considered​ a(n) ________ type of presence. A. website B. email C. social media D. database development E. offline media

C. social media

​E-commerce has become more​ ________. A. secure, private, and less expensive B. mobile, private, and global C. social, mobile, and local D. stable, mobile, and less expensive E. individual, static, and global

C. social, mobile, and local

​Microsoft's DBMS that includes​ built-in report generation and reporting is called​ ________. A. DB2 B. MySQL C. SQL Server D. Access E. Spreadsheets

D. Access

What are the two most important management challenges in building a successful​ e-commerce presence? A. Deciding which technology to employ and integrated security and training B. Deciding which technology to employ and developing a social media presence C. Developing a social media presence and a news feed D. Developing a clear understanding of your business objectives and knowing how to choose the right technology to achieve those objectives E. Developing a clear understanding of your​ competitor's strategy and knowing how to choose the right OS

D. Developing a clear understanding of your business objectives and knowing how to choose the right technology to achieve those objectives

senior managers

unstructured decisions

Database Management System (DBMS)

-Interfaces between applications and physical data files -Separates logical and physical views of data -Solves problems of traditional file environment controls redundancy, eliminates inconsistency, uncouples programs and data, enables organization to centrally manage data and data security

Another name for a database field is​ a(n) ________. A. attribute B. database C. record D. tuple E. row

A. attribute

3 types of ecommerce

b2c amazon b2b elemica c2c

predictive analytics

variety of data, techniques to predict future trends and behavior patterns statistical analysis, data mining, historical data, assumptions

cloud database

A database accessible to clients from the cloud and delivered to users on demand via the Internet appeal to small businesses, amazon relational database service, microsoft sql azure private clouds

blockchain

A distributed and decentralized ledger that records and verifies transactions and ownership, making it difficult to tamper with or shut down. maintains a growing list of records and transactions shared by all encryptions used to identify participants and transactions financial transactions, supply chain, medical records bitcoin and other cryptocurrencies

Which of the following is a distributed database technology that enables firms and organizations to create and verify transactions on a network nearly instantaneously without a central​ authority? A. Blockchain B. NoSQL C. MySQL D. DB2 E. Cloud Spinner

A. Blockchain

What revenue model offers basic services or content for​ free, while charging a premium for advanced or special​ features? A. Free/freemium revenue model B. Subscription revenue model C. Sales revenue model D. Affiliate revenue model E. Transaction fee revenue model

A. Free/freemium revenue model

For handling unstructured and​ semi-structured data in vast​ quantities, as well as structured​ data, organizations are using​ _____________. A. Hadoop B. DataNet C. MySQL D. Access E. Datapalooza

A. Hadoop

Making a decision is a multistep process. Which list below contains the four different stages in decision​ making? A. Intelligence, design,​ choice, and implementation B. Intelligence, data,​ information, and choice C. Data, information,​ choice, and implementation D. Intelligence, structure,​ information, and choice E. Data, design,​ choice, and implementation

A. Intelligence, design,​ choice, and implementation

What makes a Blockchain system possible and attractive to business​ firms? A. Its encryption and authentication processes make it highly secure for storing many kinds of data. B. Blockchain is easily implemented across larger enterprises. C. It is free open source software​ (OSS), which means that the copyright holder grants users rights and privileges. D. Blockchain makes it easier for competitors to​ collude, ultimately to the detriment of consumers. E. Blockchain systems always include remote maintenance and support capabilities.

A. Its encryption and authentication processes make it highly secure for storing many kinds of data.

An emerging​ non-relational database management system is called​ ________. A. NoSQL B. an​ information-base C. XBRL D. a relational database E. Oracle

A. NoSQL

What are knowledge work​ systems? A. Specialized systems for discovering and creating new knowledge. B. Specialized systems running a working AI to automate the business processes. C. Specialized systems for working knowledge. D. Specialized systems running a working AI to create new more efficient business processes. E. Specialized systems running a working AI to derive knowledge from the Internet.

A. Specialized systems for discovering and creating new knowledge.

​A(n) ________ is an Internet business model in which information content is sold and distributed. A. content provider B. community provider C. market creator D. e-tailer E. portal

A. content provider

An example of​ ________ includes someone taking out a loan and then being sold a checking account as well. A. cross-selling B. production selling C. knowledge selling D. cross-join E. function selling

A. cross-selling

what is the problem with dominos master data one pizza at a time

very large volumes of data data fragmented into multiple systems and files

The​ sales, manufacturing, and inventory systems at a bicycle manufacturer use different codes to represent bicycle frame sizes. For​ example, in the sales​ system, a large bike frame is coded with​ "L", while the inventory system codes a large bike frame with​ "LG". This situation illustrates​ ________. A. data inconsistency B. duplicate data C. coarse data D. re-indexed data E. non-indexed data

A. data inconsistency

A​ ________ is software that enables an organization to centralize​ data, manage them​ efficiently, and provide access to the stored data by application programs. A. database management system​ (DBMS) B. word processor C. systems process D. system network E. spreadsheet

A. database management system​ (DBMS)

About 80 percent of online B2B​ e-commerce is still based on proprietary systems for​ ____________. A. electronic data interchange​ (EDI) B. digital data interchange​ (DDI) C. electronic information interchange​ (EII) D. digital information interchange​ (DII) E. binary data interchange​ (BDI)

A. electronic data interchange​ (EDI)

In an enterprise​ system, the integrated software modules that focus on payroll and benefits accounting are related to​ ________. A. human resources B. finance and accounting C. manufacturing and production D. instructional technology E. sales and marketing

A. human resources

Knowledge management​ ________ the ability of the organization to learn from its environment. A. increases B. interferes with C. distorts D. hampers E. skews

A. increases

Information systems tools such as telepresence​ systems, social​ networks, and Twitter can be used to support a​ manager's __________ role. A. interpersonal B. nerve center C. judgmental D. informational E. decisional

A. interpersonal

The formal process to remove data problems such as repeating groups is called​ ________. A. normalization B. DBMS C. primary key D. data network E. ER Diagramming

A. normalization

Business intelligence users can be grouped into two​ types: _______ who comprise​ _______ of​ employees, and​ _______ who comprise​ ________ of employees. A. power​ users; 20%; casual​ users; 80% B. advanced​ users; 20%; normal​ users; 80% C. power​ users; 80%; casual​ users; 20% D. advanced​ users; 80%; normal​ users; 20% E. power​ users; 50%; casual​ users; 50%

A. power​ users; 20%; casual​ users; 80%

A supply chain management system using​ a(n) ________ model bases production schedules on forecasts. A. push-based B. information C. analytical D. pull-based E. data

A. push-based

The primary benefit of disintermediation to the consumer is​ ________. A. removing layers and reducing costs B. adding distribution layers to the customer C. adding retailers for the customer D. complicating distribution layers to the customer E. adding distributors for the customer

A. removing layers and reducing costs

In an enterprise​ system, the integrated software modules that focus on quotes and order processing are related to​ ________. A. sales and marketing B. human resources C. manufacturing and production D. instructional technology E. finance and accounting

A. sales and marketing

The strategy used by an expert system to search the rule base to arrive at a conclusion is called​ ________. A. the inference engine B. information chaining C. backward chaining D. genetic algorithm E. neural network

A. the inference engine

The most popular type of database today for PCs as well as for larger computers and mainframes is​ ___________ database. A. the relational B. noSQL C. iRelational D. M204​ (Model 204) E. Linux's Apache

A. the relational

ecommerce revenue models

Advertising Sales Subscription Free/Freemium Transaction fee Affiliate

business intelligence infrastructure

Array of tools for obtaining information from separate systems and from big data data warehouse, data marts, hadoop

Studies of actual managerial performance indicate that managers perform work at a pace of​ _______ different activities each day. A. 16 B. 600 C. 1600 D. 60 E. 160

B. 600

What is structured​ knowledge? A. Explicit knowledge that exists in SQL format. B. Explicit knowledge that exists in formal​ documents, as well as in formal rules. C. Any knowledge that is in a structured format recognized by computer. D. Tacit knowledge that exists in SQL format. E. Tacit knowledge that exists in formal documents.

B. Explicit knowledge that exists in formal​ documents, as well as in formal rules.

What type of service can tell you the price of a house you are looking at or about special exhibits at a museum you are​ passing? A. 411 B. Geoinformation services C. Info-rama D. Data2info services E. E-info

B. Geoinformation services

What is the fastest growing form of​ e-commerce, with some areas expanding at a rate of 20 percent or more per​ year, and which is estimated to grow to​ $500 billion by​ 2022? A. Social commerce B. M-commerce C. B2B commerce D. I-commerce E. C2C commerce

B. M-commerce

Which of the following options is NOT a unique feature of​ e-commerce technology? A. The consumer is a participant in the process of delivering products or services. B. Our geographic boundaries now determine our network experience. C. Marketing messages are more​ personalized, and products are customized. D. The information density has increased. E. There is one set of technical standards across the globe.

B. Our geographic boundaries now determine our network experience.

Which list below contains the analytic functionalities that BI systems​ deliver? A. BI systems do not contain any analytic​ functions, they are purely static database manipulation tools. B. Production​ reports, parameterized​ reports, dashboards/scorecards, ad hoc​ query/search/report creation, and drill down. C. Competitor production​ reports, parameterized​ reports, scorecards, and ad hoc​ query/search/report creation. D. Sales and SQL​ reports, dashboards/scorecards, report​ creation, and drill down. E. Push​ reporting, data​ loading, online analytical​ processing, and​ dashboards/scorecards.

B. Production​ reports, parameterized​ reports, dashboards/scorecards, ad hoc​ query/search/report creation, and drill down.

Which item below would be considered direct​ goods? A. Paper for office use B. Sheet steel used for auto body construction C. Maintenance supplies D. Items bought directly from the manufacturer E. Items bought directly from the supplier

B. Sheet steel used for auto body construction

SQL stands for​ ________. A. Structured Questioning Language B. Structured Query Language C. Streamlined Question Language D. Structured Question Language E. Special Question Language

B. Structured Query Language

Enterprise applications have drawbacks mainly because they​ ________. A. use both DDL and DML database statements B. are very expensive to purchase and implement C. require an Intranet D. use databases E. require the Internet

B. are very expensive to purchase and implement

A​ ________ is the smallest component in the computer system data hierarchy. A. record B. bit C. byte D. file E. field

B. bit

When demand for a product mistakenly gets distorted as it passes across the supply​ chain, it is called a​ ________. A. process error B. bullwhip effect C. process distortion D. bulltrap effect E. bull distortion

B. bullwhip effect

A social commerce feature that provides consumers the ability to share their shopping experiences with others is called​ _________. A. social search B. collaborative shopping C. timelines D. crowdshopping E. crownsourcing

B. collaborative shopping

​A(n) ________ is an Internet business model that provides an online meeting place where people with similar interests can communicate and share information. A. portal B. community provider C. content provider D. e-tailer E. market creator

B. community provider

A DBMS has a​ data________ capability that is used to specify the structure of the content of the database. A. index B. definition C. manipulation language D. projection E. dictionary

B. definition

Downloading a movie from the Internet is an example of​ ________. A. delayed gratification B. digital goods C. the traditional marketplace D. information asymmetry E. market segmentation

B. digital goods

​A(n) ________ database makes it possible to store information across millions of machines in hundreds of data centers around the​ globe, with special​ time-keeping tools to synchronize the data and ensure the data are always consistent. A. relational B. distributed C. SQL D. NoSQL E. simple

B. distributed

If a website changes its prices based on the demand characteristics​ (e.g., concert​ tickets), this would be an example of​ ________. A. webpricing B. dynamic pricing C. bit pricing D. organizational pricing E. digital pricing

B. dynamic pricing

​A(n) ________ makes values from a central database available for applications that support all an​ organization's internal business activities. A. customer service application​ (CSA) B. enterprise resource planning​ (ERP) system C. human resource system​ (HRS) D. quality control application​ (QCA) E. data display system​ (DDS)

B. enterprise resource planning​ (ERP) system

SAP is an important vendor of​ ________. A. word processing software B. enterprise software C. database software D. spreadsheet software E. data mining software

B. enterprise software

The term data​ ________ is used to describe the​ organization's rules for​ sharing, disseminating,​ acquiring, standardizing,​ classifying, and inventorying information. A. dumping B. governance C. oversight D. cleansing E. wrangling

B. governance

To transform information into​ ________, a firm must expend additional resources to discover​ patterns, rules, and contexts. A. feedback B. knowledge C. content D. clients E. data

B. knowledge

According to the​ E-Commerce Presence​ Map, activities such as education and branding are considered​ a(n) ________ type of presence. A. database development B. offline media C. website D. email E. social media

B. offline media

If a company produces a​ custom-made automobile only after a customer has placed an​ order, it is an example of​ a(n) ________ production model. A. push-based B. pull-based C. data D. analytical E. information

B. pull-based

Which list below contains the correct four kinds of​ e-commerce presence? A. websites, email,​ texting, and offline media B. websites, email, social​ media, and offline media C. B2B, C2C,​ B2G, and B2C D. websites, email, social​ media, and texting E. Texting, email, social​ media, and print media

B. websites, email, social​ media, and offline media

A supply chain management system using​ a(n) ________ model bases production schedules on actual customer orders. A. data B. ​pull-based C. analytical D. push-based E. information

B. ​pull-based

​________ targeting techniques increase the effectiveness of​ banners, rich​ media, and video ads. A. Business function B. Data worker C. Behavioral D. Operations E. Production worker

C. Behavioral

How do information systems support the activities in a supply​ chain? A. By increasing sales B. By improving security C. By reducing inventory levels D. By promoting ownership E. By differentiating the products or services

C. By reducing inventory levels

The form of​ e-commerce whose platform enables people to sell goods and services directly to each other is called​ ________. A. B2B B. G2G C. C2C D. M2M

C. C2C

What is​ GDSS? A. Global​ digital-support system B. Global digital services system C. Group​ decision-support system D. Global​ decision-support system E. Global digital satellite system

C. Group​ decision-support system

What type of analytics uses statistical​ analysis, data mining​ techniques, historical​ data, and assumptions about future conditions to predict future trends and behavior​ patterns? A. Post-transactional B. AI C. Predictive D. Long tail E. Pre-transactional

C. Predictive

What types of decisions are​ repetitive, routine, and involve a definite procedure for​ handling? A. Semistructured decisions B. Repetitive decisions C. Structured decisions D. Unstructured decisions E. Informal decisions

C. Structured decisions

Analytical CRM includes applications that​ ________. A. analyze cloud computing procedures B. analyze operations data for ordering decisions C. analyze customer data for improving business performance D. analyze accounting procedures E. analyze social media procedures

C. analyze customer data for improving business performance

Some ERP vendors include​ in-memory-computing technology that provides​ ________ tools for ad hoc​ analysis, what-if scenario​ analysis, and machine learning that analyzes very large data sets. A. database security B. database triggering C. business intelligence D. Internet of Things​ (IoT) E. metadata storage

C. business intelligence

Customer relationship management primarily includes​ ________. A. human resources data B. operations data C. capturing and integrating customer data D. capturing and integrating systems data E. manufacturing data

C. capturing and integrating customer data

Determining the revenue produced by a customer and comparing the revenue to the expenses of acquiring and taking care of the customer is called​ ________. A. enterprise system value B. intranet value C. customer lifetime value D. sales value E. Internet value

C. customer lifetime value

Some say that a​ firm's most valuable asset is its​ ________. A. supply chain B. enterprise employee networks C. customer relationships D. enterprise resource planning information system E. operations and manufacturing

C. customer relationships

​A(n) ________ is an Internet business model that sells products directly to consumers or to individual businesses. A. market creator B. portal C. e-tailer D. content provider E. community provider

C. e-tailer

Neural networks are used for​ ________. A. data conversion into information B. programming AI for knowledge management systems C. knowledge discovery D. tacit knowledge E. analyzing relationships on social media

C. knowledge discovery

The fastest growing type of B2C​ e-commerce is​ ________. A. intranet B. brick and mortar C. mobile D. auctions E. client/server

C. mobile

​A(n) ________ is an Internet business model that provides an initial point of entry to the web along with specialized content and other services. A. content provider B. e-tailer C. portal D. community provider E. market creator

C. portal

Another term for a key field is a​ ________. A. null key B. foreign key C. primary key D. surrogate key E. data key

C. primary key

Another term for a database row is​ a(n) ________. A. attribute B. field C. record D. spreadsheet E. database

C. record

Microsoft SQL Server is a​ ________ for large mainframes and midrange computers. A. distributed database B. MongoDB C. relational DBMS D. SimpleDB E. NoSQL

C. relational DBMS

Customer relationship management applications that track social networking data are related to the​ ________ aspect of customer relationships. A. sales B. processing C. service D. business intelligence E. marketing

C. service

Incorporating applications that allow customers to chat with one another about company products is an example of​ ________. A. instructional CRM B. computer science CRM C. social CRM D. accounting CRM E. operations CRM

C. social CRM

Which of the following is NOT a challenge to the implementation of an​ ERP? A. Estimated amount of time needed for implementation B. Estimated costs of implementation C. Changes in the project scope and customization D. Dramatic reductions in inventory costs and order to delivery time E. Required business process management and organizational learning

D. Dramatic reductions in inventory costs and order to delivery time

​________ enables the​ computer-to-computer exchange between two organizations of standard transactions such as​ invoices, shipment​ schedules, or purchase orders. A. Cloud computing B. XML C. XBRL D. EDI E. Social media

D. EDI

Which of the following is NOT a requirement of a knowledge work​ system? A. Modeling and simulation software B. Strong links to external knowledge base C. Graphical software for visualization D. Inference engine E. Powerful hardware platform

D. Inference engine

The SQL​ ________ statement allows you to combine two different tables. A. GROUP BY B. SELECT C. COMBINE D. JOIN E. ORDER BY

D. JOIN

​________ is another name for​ e-hubs. A. EDI B. Central processing C. XMAL D. Net marketplaces E. Digital goods

D. Net marketplaces

Organizational learning is the result of knowledge​ ________. A. dissemination B. storage C. scenarios D. application E. acquisition

D. application

To describe datasets with volumes so huge that they are beyond the ability of typical DBMS to​ capture, store, and​ analyze, the term​ __________ is used. A. cloud data B. large data C. relational data D. big data E. terra data

D. big data

According to your​ text, Elemica's website for buying and selling chemicals is an example of​ ________ electronic commerce. A. government-to-business (G2B) B. business-to-consumer (B2C) C. government-to-consumer (G2C) D. business-to-business (B2B) E. consumer-to-consumer (C2C)

D. business-to-business (B2B)

Data​ cleansing, also known as​ _________, consists of activities for detecting and correcting data in a database that are​ incorrect, incomplete, improperly​ formatted, or redundant. A. datalizing B. compiling C. first normal form D. data scrubbing E. normalizing

D. data scrubbing

​A(n) ________ is a collection of data organized to serve many applications efficiently. A. information system B. word processor C. email server D. database E. hard drive

D. database

The fastest growing form of retail trade in the United​ States, Europe, and Asia is​ ________. A. customer relationship churning B. consumer-to-business (C2B) commerce C. supplier partnerships D. e-commerce E. product services

D. e-commerce

According to the​ E-Commerce Presence​ Map, activities including newsletters are​ a(n) ________ type of presence. A. website B. offline media C. database development D. email E. social media

D. email

The global positioning system​ (GPS) enables​ ________-based services for consumers via their smartphones. A. sales B. financial C. manufacturing D. location E. procurement

D. location

The fact that universal technical standards for the Internet and electronic commerce exist lowers​ ________ costs, making it cheaper for merchants to sell their goods. A. product development B. product information C. supplier identification D. market entry E. customer search

D. market entry

Customer relationship management applications that track campaign data are related to the​ ________ aspect of customer relationships. A. service B. sales C. processing D. marketing E. business intelligence

D. marketing

A broad term to describe extending a marketplace beyond traditional boundaries is called​ ________. A. business intelligences B. market watch C. business processes D. marketspace E. market basket

D. marketspace

The​ ________ of the web makes it possible to deliver messages with​ text, audio, and video simultaneously to large numbers of people. A. global reach B. interactivity C. universal standards D. richness E. information density

D. richness

Customer relationship management applications that track Web sales and retail store sales are related to the​ ________ aspect of customer relationships. A. processing B. marketing C. service D. sales E. business intelligence

D. sales

The knowledge an employee has in his mind that has not been documented is called​ ________. A. tacit information B. explicit knowledge C. explicit intelligence D. tacit knowledge E. loose knowledge

D. tacit knowledge

capabilities of database management systems

Data definition Data dictionary querying and reporting - structured query language SQL generating reports - microsoft access

unstructured decision

Decision maker must provide judgment, evaluation, and insight to solve problem

non relational databases

Developed to handle large sets of data that are not easily organized into tables, columns, and rows more flexible data model, data sets stored across distributed machines, easier to scale, handle large volumes of unstructured and structured data

Knowledge workers perform three key roles that are critical to the organization and to the managers who work within the organization. Select the list below that contains these three roles. A. Mapping relationships within​ data, providing training modules for​ managers, insisting on static data. B. Keeping the organization current in​ knowledge, serving as external​ consultants, retrieving. C. Keeping the organization current in​ knowledge, serving as external​ consultants, organizing data. D. Providing training modules for​ managers, serving as external​ consultants, organizing data. E. Keeping the organization current in​ knowledge, serving as internal​ consultants, acting as change agents.

E. Keeping the organization current in​ knowledge, serving as internal​ consultants, acting as change agents.

What are​ MOOCs? A. Massive open office courses B. Modern online oration courses C. Modern online Oracle classes D. Mapped open online courses E. Massive open online courses

E. Massive open online courses

What is information​ density? A. Substitute information B. The conversion rate from data to information C. Market saturation with pricing information D. The difficulty in discerning accurate information from inaccurate information E. The total amount and quality of information available to all market​ participants, consumers, and merchants alike

E. The total amount and quality of information available to all market​ participants, consumers, and merchants alike

A​ ________ is a component in the computer system data hierarchy that represents an ASCII character like a​ letter, a​ number, or another symbol. A. record B. bit C. field D. file E. byte

E. byte

A record describes​ a(n) ________ which is a​ person, place,​ thing, or event on which we store and maintain information. Each characteristic or quality describing a particular​ ________ is called​ a(n) ________. A. file; file; field B. field; field; byte C. bit; bit; byte D. entity; entity; field E. entity; entity; attribute

E. entity; entity; attribute

In an enterprise​ system, the integrated software modules that focus on cash management and forecasting are related to​ ________. A. instructional technology B. sales and marketing C. human resources D. manufacturing and production E. finance and accounting

E. finance and accounting

The field that uniquely identifies a row in a relational database table is called a​ ________. A. data definition language B. null value C. foreign key D. column E. primary key

E. primary key

Managers often maintain​ a(n) ________ as a buffer for uncertainty and unforeseen events. A. just-in-case inventory B. database backup C. support chain D. inventory multiplier E. safety stock

E. safety stock

in information​ systems, SaaS stands for​ ________. A. social as a service B. security as a service C. systems security as a service D. systems as a service E. software as a service

E. software as a service

A​ ________ chain is a network of organizations for obtaining raw materials. A. database B. demand C. system network D. systems process E. supply

E. supply

Many companies use the web to make some internal databases available to customers or partners advantages include

Ease of use of browser software Web interface requires few or no changes to database Inexpensive to add web interface to system

hadoop

Enables distributed parallel processing of big data across inexpensive computers Key services Hadoop Distributed File System (HDFS): data storage MapReduce: breaks data into clusters for work Hbase: No SQL database Used by Yahoo, NextBio

data mining

Finds hidden patterns, relationships in datasets Example: customer buying patterns Infers rules to predict future behavior Types of information obtainable from data mining: Associations, Sequences, Classification, Clustering, Forecasting

global supply chain issues

Greater geographical distances Greater time differences Participants from different countries Different performance standards Different legal requirements internet helps manage global complexities: warehouse management, transportation management, logistics, outsourcing

business value of crm systems

Increased customer satisfaction Reduced direct-marketing costs More effective marketing Lower costs for customer acquisition/retention Increased sales revenue

bullwhip effect

Information about product demand gets distorted as it passes from one entity to next across supply chain

supply chain execution systems

Manage flow of products through distribution centers and warehouses

supply chain planning systems

Model existing supply chain Enable demand planning Optimize sourcing, manufacturing plans Establish inventory levels Identify transportation modes

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions

Multidimensional data analysis (OLAP) Data mining Text mining Web mining

churn rate

Number of customers who stop using or purchasing products or services from a company Indicator of growth or decline of firm's customer base

semistructured decision

Only part of problem has clear-cut answer provided by accepted procedure

new ways of b2b buying and selling

Private industrial networks, Net marketplaces (e-hubs), Exchanges

structured decision

Repetitive and routine; involve definite procedure for handling so they do not have to be treated each time as new

To implement enterprise software, firms:

Select functions of system they wish to use Map business processes to software processes Use software's configuration tables for customizing.

data warehouse

Stores current and historical data from many core operational transaction systems Consolidates and standardizes information for use across enterprise, but data cannot be altered Provides analysis and reporting tools

data marts

Subset of data warehouse Typically focus on single subject or line of business

Online Analytical Processing OLAP

Supports multidimensional data analysis Viewing data using multiple dimensions Each aspect of information (product, pricing, cost, region, time period) is different dimension Example: How many washers sold in the East in June compared to the sales forecast? OLAP enables rapid, online answers to ad hoc queries

why ecommerce is different

Ubiquity - popular and common Global reach Universal standards Richness interactivity information density personalization/customization social technology

analytical crm

based on data warehouses population by operational crm systems and customer touch points analyzes customer data

data quality assurance

before new database is in place, a firm must identify and correct faulty data and establish better routines for editing data once database in operation. data quality audit and data cleansing

push based model

build to stock schedules based on best guesses of demand

operational intelligence

business activity monitoring, collection and use of data generated by sensors iot - creating huge streams of data from web activities, sensors and other monitoring devices software for operational intelligence and analytics enable companies to analyze their big data

customer relationship management

capture and integrate customer data from all over the organization consolidate and analyze distribute information to various systems provide single enterprise view of customers

file

collection of related records

enterprise system/enterprise resource planning (ERP) systems

consist of a suite of integrated software modules and a common central database collects data from many divisions of firm for use in nearly all of firm's internal business activities information entered in one process is immediately available for other processes

business intelligence vendors

create business intelligence and analytics purchased by firms

operational crm

customer facing applications, sales force automation call center and customer service support, marketing automation

intelligent agens

deleting junk email, cheapest airfare built in knowledge base - siri chatbots

pull based models

demand driven web based, customer orders trigger events in supply chain

what are the solutions

develop enterprise data strategy, consolidate, standardize and cleanse data revise data access rules and procedures deploy talend, mdm software and hadoop

how has ecommerce transformed marketing?

different ways to identify and communicate long tail marketing search, display ads, video, email behavioral

web mining

discovery and analysis of useful patterns and information from web. web content mining, web structure mining, web usage mining

attribute

each characteristic or quality of a particular entity

data governance

encompasses policies and procedures through which data can be manages as an organizational resource establishes rules for sharing, disseminating, acquiring standardizing classifying, and inventorying information

current generation enterprise application

enterprise solutions/suites cloud based versions mobile platforms social crm - social network technologies business intelligence - flexible reporting, ad hoc analysis, what ifs, digital dashboards, data visualization

enterprise application challenges

expensive to purchase and implement long development times technology, business processes, organization learning changes switching costs data standardization, management cleansing

text mining

extracts key elements from large unstructured text data sets. sentiment analysis software

primary key

field in table used for key fields

key field

fields used to uniquely identify each record

digital goods

goods that can be delivered over a digital network low cost of producing and delivery marketing remains industries are undergoing revolutionary changes

field

group of characters as words or numbers

database

group of related files serves many applications by centralizing data and controlling redundant date

business value of enterprise system

increase operational efficiency provide firm wide information to support decision making enable rapid responses to customer requests for information or products include analytical tools to evaluate overall organizational performance and improve decision making

what is business intelligence

infastructure for collecting, storing, analyzing data produced by business

why it investments do not always produce positive results

information quality - high quality decisions require high quality information management filters - managers have selective attention and variety of biases that reject information that does not conform to prior conceptions organizational intertia and politics - strong forces within organizations resist making decisions calling for major change

parter relationship management

integrating lead generation, pricing, promotions, order configurations and availability tools to assess partners' performances

decision making process

intelligence - discovering, identifying, understanding problems occurring in the organization design - identifying and exploring solutions choice - among solution alternative implementation - making chosen alternative work and continuing to monitor how a solution is working

key concepts in ecommerce

internet and digital markets have changes companies conduct business, costs reduces dynamic pricing

enterprise management framework

makes data more accurate and consistent enterprise wide, accelerates decision making and improves customer analysis illustrates the importance of data management for better decision making and customer analysis

ecommerce presence issues

management challenges - business objectives, right technology to achieve websites, email, social media, offline media presence milestone timeline presence

distributed databases

many organizations distribute their databases over multiple locations ex: google spanner

mcommerce is 45% of ecommerce main areas of growth

mass market retailing sales of digital content in app sales to mobile devices

big data analytics

massive data sets collected from social media, online and in store customer data.

challenge of big data

massive sets of unstructured/semi-structured data from web traffic, social media etc. volume too great for DBMS, exabytes of data reveal more patterns relationships and anomalies requires new tools and technologies to manage and analyze

mobile app payment systems

net field communication (NFC) apple pay qr code peer to peer paymment venmo

supply chain

network and processes for procuring materials, transforming materials into product, distributing products upstream supply chain downstream supply chain internal supply chain

entity

person place thing on which we store information

big data and iot drive precision agriculture problem and solutions

problem - explosive population growth, oppotunities for new technology solutions - identify technologies and decisions for improvement, iot wireless sensors, supercomputer processing, mobile devices

AI beats radiology problem + solution

problem: high level of information inaccuracy, opportunities from new technology solutions: monitor accuracy and costs, evaluate study results, collect data for system training, compare findings, ai pattern recognition system

ecommerce comes to the dashboard problem solutions

problem: opportunities presented by new technology solution: design business and revenue model, partner with software providers, ensure data privacy, dashboard display

Relational DBMS

represent data as two dimensional rows (tuples) - records for different entities fields (columns) - represents attribute for entity It can relate data stored in one table to data in another as long as the two tables share a common data element.

crm packages

sales force automation, customer service, marketing

employee relationship management

setting objectives, employee performance management, performance-based compensation, employee training

what is ai

software as smart as humans take data inputs, process them and product outputs to perform complex tasks for humans

operational managers, rank and file employees

structured decisions

middle managers

structured decisions, unstructured components

business analytics

tools and techniques for analyzing data OLAP statistics models data mining

3 types of decisions

unstructured, structured, semiscructured