Chapter 9 In Class Notes Flashcards

1
Q

information
systems that process operational and other data to
identify patterns, relationships, and trends for use by
business professionals and other knowledge workers.

A

Business intelligence (BI) systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

patterns, relationships,

trends, or predictions

A

Business intelligence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

The software component of a BI system is referred to

as a

A

BI application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Big Data
• A problem for data processing, organization and
storage

A

– Nonrelational data stores (a.k.a. NoSQL databases)
enter stage right. With celebrity endorsements by the
likes of Amazon (Dynamo), Google (Bigtable), and
Facebook (Cassandra), NoSQL architectures are gaining
in popularity and acceptance and are likely to have a big
impact on the BI space in the near future

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

BI Applications process data to produce business

intelligence via:

A

– Reporting
– Data Mining
– Knowledge Management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Where Does BI Data Come From?

A
  • Operational Data
  • Purchased Data (Data Vendors)
  • Human Knowledge
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Q1: How Do Organizations Use Business

Intelligence (BI) Systems?``

A

They make BI Applications that manage operational and purchased Data, and Human knowledge

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is BI used for? 4 things

A

Project management
problem solving
deciding
informing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Q2: What Are the Three Primary
Activities in the Business Intelligence
Process?

A

• Collecting Data: Obtaining, cleaning, organizing,
relating, and cataloging source data.
• Performing Analysis: Creating business intelligence
via reporting, data mining, and knowledge
management
• Publishing Results: Delivering business intelligence
to the knowledge workers who need it.
– Push publishing: BI is delivered without any request on
the part of the user (scheduled or event driven)
– Pull publishing: BI is delivered to users upon request

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Push vs. Pull: Implications for BI?
• What are some suggestions for maintaining a healthy
dynamic between your reporting team and the end
users? 4 of them

A
– Voice of customer
– Steering committee
– Data sufficiency
– Islands of automation and sharing of reporting
information
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Why Do Organizations Use Data
Warehouses and Data Marts to Acquire
Data?

A

• Creating reports and performing analyses from operational data is
generally not recommended
– Security and control
– Data structure is structured for fast and reliable transaction
process and not for BI analysis (one of the potential
downsides of Nonrelational database systems)
– BI analysis can be very resource intensive
• For these reasons, data is often extracted to a data warehouse
for BI analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Components of a Data Warehouse 3 of them

A

Cental is Data warehouse DBMS. 2 components coming off center are data warehouse metadata and data warehouse database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Data Warehouses

• Functions: (4 of them)

A

– Obtain data
– Cleanse data
– Organize and relate data
– Catalog data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Data Warehouses vs. Data Marts

A
• Data warehouse
– Obtain data
– Cleanse data
– Organize and relate data
– Catalog data
• Data Mart: A collection of data smaller than a data
warehouse that addresses the needs of a particular
department or function
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Q4 How Do Organizations Use Typical

Reporting Applications

A

Reporting applications apply reporting operations to

data to produce business intelligence.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q
Q4 How Do Organizations Use Typical
Reporting Applications
• Reporting applications apply reporting operations to
data to produce business intelligence.
• Basic operations: (5 of them)
A
Sorting
filtering
grouping
calculating
formatting
17
Q

RFM Analysis and Report

A

Customers are rank-ordered according to their
purchasing patterns (1-5, 20th percentiles) with
1. how recently a customer has ordered.
2. how frequently a customer orders
3. how much money a customer has spent

18
Q

Provides an
ability to sum, count, average, and perform
calculations on groups of data.

A

Online analytical processing (OLAP)

19
Q

data item of interest that is to be summed or

averaged (e.g. total sales, returns, etc.)

A

Measure

20
Q

a characteristic of a measure (date of

purchase, customer zip code, type of customer, etc.)

A

dimension

21
Q

The application for statistical techniques to find patterns
and relationships among data for classification and
prediction

A

data mining

22
Q

Q5 How Do Organizations Use Typical

Data-mining Applications?

A

Data mining is the central location. coming off of data mining is artificial intelligence machine learning. data management technology. cheap computer procesing and storae , statistics/mathematics, huge databases

23
Q

Unsupervised vs. Supervised Data Mining

A
Unsupervised
1. no model before running analysis
2. hypotheses created after analysis
3. cluster analysis to find groups
Supervised
1. model created before analysis
2. hypotheses created before analysis
3. regression analysis make predictions.
24
Q
  • Used for predicting values and making classifications

* Complicated set of nonlinear equations

A

Neural Networks (Supervised)

25
Q

• Data mining technique for determining sales patterns
• Shows products that customers tend to buy together
– Cross-selling opportunities
– Support: The probability that two items will be purchased
together
– Lift: How much the base probability increases or
decreases when other products are purchased

A

Market Basket Analysis (Unsupervised)

• Data mining technique for determining sales patterns

26
Q

• A hierarchical arrangement of criteria that predict a

classification or a value.

A

Decision Tree (unsupervised)

27
Q

Ethics Guide: The Ethics of Classification

A

• Classifying applicants for college
• University collects demographics and performance
data of all its students
• Uses decision tree data mining program
• Uses statistically valid measures to obtain statistically
valid results
• No human judgment involved

28
Q

“the process of
creating value from intellectual capital and sharing
that knowledge with employees, managers,
suppliers, customers and others who need it.”

A

knowledge management (KM)

29
Q

Q6. Role/Benefits of KM Systems

(Santosus and Surmacz) 5 of them

A
  1. Encourage free flow of ideas.
  2. Improve customer service by streamlining response
    time.
  3. Boost revenues by getting products and services to
    market faster.
  4. Enhance employee retention rates by recognizing
    and rewarding knowledge sharing.
  5. Streamline operations and reduce costs
30
Q

Three Major Categories of Knowledge

Assets

A
  1. Data
  2. Documents
  3. Employees
31
Q

most important content function in KM

applications

A

Indexing

32
Q

subscribing to

content sources

A

Real Simple Syndications

33
Q

place where employees share their

knowledge that may include RSS feeds

A

Blogs

34
Q

• Encode human knowledge as Rule-based systems
(IF/THEN)
• Rules created by interviewing experts

A

Expert Systems

35
Q

• Major problems with ES:

A

– Expensive to develop
– Unpredictable maintenance
– Over hyped

36
Q

Q7 What Are the Alternatives for

Publishing Business Intelligence?

A

Email or collaboration tool
Web server
SharePoint
BI Server

37
Q

Components of a Generic Business

Intelligence System

A

You have metadata on top. Then on the second row you start with the BI application, which is BI data source, BI Application, and BI application results. Then it goes to BI Server, then you have push an pulls from BI server to Any Device. You have BI users using “Any Device”

38
Q

machines can build their own

information systems. What is this called?

A

Social singularity

39
Q

Q8: 2022

A

• Companies will know more about your purchasing
habits and psyche.
• Social singularity — machines can build their own
information systems.
• Will machines possess and create information for
themselves?