Exam 2- Chapters 5 and 12 Flashcards
1
Q
T or F: The process of acquiring, keeping, and managing data is becoming increasingly difficult.
A
True
1
Q
All information technology applications require:
A
data
2
Q
Data should be of high quality, meaning it should be what 7 things?
A
- Accurate
- Complete
- Timely
- Consistent
- Accessible
- Relevant
- Concise
3
Q
What are the 8 difficulties of managing data?
A
- The amount of data is increasing with time.
- Data is frequently stored in numerous servers and locations
- Data are generated from multiple resources
- New data is constantly being developed, and this data must be managed; data also becomes less current over time
- Data are subject to data rot
- Data security, quality, and integrity are easily jeopardized.
- Federal regulations complicate data management and companies are drowning in data
- Big Data
4
Q
Inconsistent data prevents a company from what?
A
Developing a unified view of core business information
5
Q
a collection of data held by one group that is not easily accessible by other groups
A
data silo
6
Q
One major method to remove data silos is through ________ ________ _________.
A
cloud data management
7
Q
What are three issues with data silo’s?
A
- Hinder the process of gaining actionable insights from organizational data
- Create barriers to an overall view of the enterprise and its data
- Delay digital transformation efforts
8
Q
Data that are continuously generated by point-of-sale systems, clickstream data, social media, and sensors
A
Data streams
9
Q
Point of Sale systems collect data in _____ _____.
A
real time
10
Q
the information that is collected during the customer sales transaction (like name, product identification number, unit price of each item, etc.)
A
point-of-sale data
11
Q
What are the four types of data streams?
A
- Point-of-Sale Data
- Clickstream Data
- Social Media Data
- Sensor Data
12
Q
the data that visitors and customers produce when they visit a website and click on hyperlinks
A
clickstream data
13
Q
What type of data stream would this be: data that includes shares, likes and dislikes, ratings, reviews, recommendations, and comments.
A
social media data
14
Q
a system in which any object, natural or manmade, contains internal or external wireless sensor(s) that communicate with each other without human interaction. What type of data stream does this relate to?
A
The Internet of Things (IoT); sensor data
15
Q
monitors and reports data on physical and environmental conditions around it, such as temperature, sound, pressure, vibration, and movement
A
sensor data
16
Q
What can sensors do?
A
Control physical systems, such as opening and closing a valve and adjusting the fuel mixture in your car
17
Q
T or F: Being able to collect massive amounts of data from many different sources is a double-edged sword.
A
True
18
Q
problems with the media on which the data are stored
A
data rot
19
Q
What are the two aspects of data rot?
A
- Over time, temp, humidity, and exposure to light can cause physical problems with storage media and make it difficult to access data
- Finding the machines needed to access the data can be difficult
20
Q
What three things are critical for data, yet easily jeopardized?
A
Security, quality, and integrity
21
Q
Today capturing data is (hard/easy) and storing that data is relatively (expensive/inexpensive).
A
easy; inexpensive
22
Q
An increasing number of companies are turning to ________ to help them make sense of their data.
A
Enigma
23
Q
a data management and business intelligence company that specializes in data integration and analytics.
A
Enigma
24
Enigma notes that it has always been difficult for banks to share data, principally due to ________ ______.
privacy concerns
25
a set of programs that provide users with tools to create and manage a database
database management system (DMS)
26
the process of accepting liability under an insurance policy, thus guaranteeing payment in case loss or damage occurs
underwriting
27
T or F: Databases and database management systems are essential to all areas of business, so they must be carefully managed.
True
28
Why do we focus on the RELATIONAL database model?
Because it is popular and easy to use
29
Database models, like the hierarchical and network models, are the responsibility of the _____ _____ and are NOT used by ___________ ________.
MIS function; organizational employees
30
What are two examples of relational databases?
1. Microsoft Access
2. Oracle
31
The relational database model is based on the concept of _____-________ tables.
two-dimensional
32
A relational database is usually designed with which of the following:
1. a big table that contains all of the records and attributes
2. a number of related tables
2. a number of related tables
33
Relational database rows contain ____ and columns contain _____.
records; attributes
34
A key to designing an effective database is the _____ ______.
data model
35
a diagram that represents entities in the database and their relationships
data model
36
a person, place, a thing, or an event-- such as a customer, an employee, or a product-- about which an organization maintains information.
entity
37
Entities can typically be identified in the user's _____ _____. A ______ generally describes an entity.
work environment; record
38
each row in a relational table, which is a specific, unique representation of the entity
instance of an entity
39
A student in a universities student database would be an ______. A particular student would be an ______ of the student entity.
entity; instance
40
each characteristic or quality of a particular entity
attribute
41
T or F: an example of an entity attribute of a customer would be customer name
True
42
T or F: entity attribute of a product could be product color
True
43
one field that uniquely identifies a record so that it can be retrieved, updated and sorted
primary key
44
What's an example of a primary key?
a unique student id number
45
another field that has some identifying information but typically does not identify the record with complete accuracy
secondary key
46
What's an example of a secondary key?
a students major
47
a field (or group of fields) in one table that uniquely identifies a row of another table; used to establish and enforce a link between two tables
foreign key
48
highly organized data in fixed fields in a data repository such as a relational database
structured data
49
data that do not reside in a traditional relational database
unstructured data
50
What are three examples of unstructured data?
1. E-mail messages
2. Videos/images
3. Powerpoint presentations
51
80-90% of data in an organization are (structured/unstructured)
unstructured
52
T or F: Databases typically process data in real time
True
53
Do users have access to databases?
If not, where can users access data for decision making?
NO; data warehouses
54
The world generates over ___ ______ of data each year.
one zetabyte
55
The amount of data produced worldwide is increasing by ___% each year.
50%
56
Most stored information in the world today (98%) is (digital/non-digital)
digital
57
a collection of data that is so large and complex that it is difficult to manage using traditional database management systems
Big Data
58
large amounts of traditional data
big data
59
Why does Big Data systems perform well?
Bc they contain huge amounts of data on which to base their predictions
60
diverse, high-volume, high-velocity information assets that require new forms of processing in order to enhance decision-making, lead to insights, and optimize business processes
Big Data
61
Big Data generally consists of what four things?
1. Traditional enterprise data
2. Machine-generated/sensor data
3. Social data
4. Images
62
Big Data has three distinct characteristics:
1. Volume
2. Velocity
3. Variety
63
Velocity in big data refers to the fact that the rate of which data flows into an organization is rapidly (increasing/decreasing).
increasing
64
Why is velocity critical?
It increases the speed of the feedback loop between a company, its customers, its suppliers, and its business partners
65
Big Data formats change (slowly/rapidly).
rapidly
66
What are the three issues with Big Data?
1. Big data can come from untrusted sources
2. Big Data is dirty
3. Big Data changes, especially in data streams
67
refers to inaccurate, incomplete, incorrect, duplicate, or erroneous data
dirty data
68
What three things have made processing Big Data today affordable for most organizations?
1. Hardware
2. Cloud computing
3. Open-source software
69
What is the first step for many organizations toward managing data?
integrate information silos into a database environment and then to develop data warehouses for decision making
70
an information system that does not communicate with other related information systems in an organization
information silos
71
What type of databases are particularly useful when working with Big Data?
NoSQL
72
the coordinated processing of an application by multiple processors that work on different parts of the application, with each processor utilizing its own operating system and memory
massively parallel processing
73
a database management system that primarily relies on main memory for data storage, in contrast to DBMSs that use hard -drive storage
in-memory database
74
refers to the storage or relatively inactive data that does not have to be accessed frequently or rapidly
cold data
75
refers to data that must be accessed frequently and rapidly
hot data
76
What are the 5 strategies that can be used by modern organizations to manage Big Data and gain value from it?
1. Making Big Data Available
2. Enabling Organizations to Conduct Experiments
3. Microsegmentation of Customers
4. Creating New Business Models
5. Organizations Can Analyze Big Data
77
A/B experiments have only _____ possible outcomes.
two
78
dividing customers up into very small groups, or even down to the individual customer
microsegmentation
79
Big Data is valuable to various functional areas in the firm. What five functional areas does this include?
1. Human Resources
2. Product Development
3. Operations
4. Marketing
5. Government Operations
80
applications, technologies, and processes for gathering, storing, accessing, and analyzing data to help business users make better decisions
business analytics
81
a repository of historical data that are organized by subject to support decision makers within the organization
data warehouses
82
Data warehouses are (inexpensive/expensive), so they are used primarily by (small/large) companies.
expensive; large
83
a low-cost, scaled down version of a data warehouse that is designed for the end-user needs in a strategic business unit (SBU) or an individual department
data mart
84
T or F: Data warehouses can be implemented more quickly than data marts, often in less than 90 days
false; data marts can be implemented more quickly
85
T or F: data marts support local rather than central control by conferring power on the user group. typically, groups that need a single or a few business analytics applications require only a data mart rather than a data warehouse.
true
86
What are the 6 basic characteristics of data warehouses and data marts?
1. Organized by business dimension or subject
2. Use online analytical processing
3. Integrated
4. Time variant
5. Nonvolatile
6. Uses a multidimensional data structure
87
A data warehouse/mart may store _____ of data, while transactional systems maintain _____ data.
years; recent
88
What does it mean to say data warehouses and data marts are "nonvolatile"?
Users cannot change or update the data
89
Who updates warehouses and marts?
Through IT-controlled load processes rather than by users
90
A common representation for this multidimensional structure (which is the structure data is stored in for data warehouses/marts) is the ____ _____.
data cube
91
The data in data warehouses and marts are organized by ______ ______, which are subjects such as product, geographic area, and time period.
business dimensions
92
What does the Business Analytics Process start with?
A business problem, often called pain points by practicing managers.
93
transmission speed
bandwidth
94
Transmission speed (bandwidth) in computer networks, particularly the Internet, is rapidly (increasing/decreasing)
increasing.
95
Advances in digital storage capacity and access speed are driving the cost of storage (up/down), meaning that what?
down; organizations are able to store and analyze huge amounts of data
96
What is the most important issue that you will face in the Business Analytics Process?
Defining the business problem
97
an ongoing collection of related activities that create a product or service of value to the organization, its business partners, and its customers
a business process
98
What is the next step in the Business Analytics Process after defining the business problem?
consider the data that you have for the analysis
99
What is the heart of the analytics process?
Big Data
100
What are the 3 types of analytics applications?
1. Descriptive Analytics
2. Predictive Analytics
3. Prescriptive Analytics
101
In general, who usually performs descriptive, predictive, and prescriptive analyses?
Data scientists
102
What is the most common and popular business analytics tool?
Excel
103
the conversion of raw data into a smaller amount of more useful information
data reduction
104
Descriptive, predictive, and prescriptive analytics are essentially steps in _____ _______.
data reduction
105
Summarizes what has happened in the past and enables decision makers to learn from past behaviors
descriptive analytics
106
What are the business analytics tools in descriptive analytics?
1. Online Analytical Processing (OLAP)
2. Data Mining
3. Decision Support Systems
107
the process of searching for valuable business information in a large database, warehouse, or mart
data mining
108
a data mining application that discovers co-occurrence relationships among activities performed by specific individuals or groups
affinity analysis
109
What is this an example of: young men often buy diapers and beer at the same time
affinity analysis
110
analysis in which retailers seek to understand the purchase behavior of customers (ex: customers who bought book A might also like to buy book B)
market basket analysis
111
simplified representations, or abstractions, of reality
models
112
combine models and data to analyze semi structured problems and some unstructured problems that involve extensive user involvement; enable business managers and analysts to access data interactively, to manipulate these data, and to conduct appropriate analyses
decision support systems
113
examines how sensitive an output is to any change in an input while keeping other inputs constant
sensitivity analysis
114
analysis that attempts to predict the impact of changes in the assumptions-- that is, the input data-- on the proposed solution
what if analysis
115
analysis that attempts to calculate the value of the inputs necessary to achieve a desired level of output
goal seeking analysis
116
examines recent and historical data to detect patterns and predict future outcomes and trends. _________ analytics provides estimates about the likelihood of a future outcome
predictive analytics
117
What is the difference between preventive maintenance and predictive maintenance?
Preventive: scheduled at regular intervals
Predictive: occurs as needed based on conditions of the asset (reduces labor and material costs)
118
a type of predictive analysis; is the process of analyzing opinions expressed in a piece of text (ex: a Tweet) or in a speech to determine whether the writer's or listener's attitude toward a particular topic, product, or service is positive, negative, or neutral
sentiment analysis
119
T or F: Problems with predictive analytics are most likely to arise when algorithms make things happen automatically, without human intervention or oversight
True (think about Uber armed man example)
120
T or F: The best analytics approach depends on the kind of data you're working with, therefore, there cannot be one best approach for all problems.
True
121
recommends one or more courses of action and identifies the likely outcome of each decision
prescriptive analytics
