IS 312 analytics and business intelligence
In the six-phase CRISP-DM method, what comes after "business understanding"? -
ANS-data understanding
SAP is the vendor of ________. - ANS-Business Objects
SAP is the vendor of Business Objects, a suite of BI applications. Review the section on
Self-Service Analytics in the text.
Which of the following is a core process associated with data management? -
ANS-process for data storage
Of these, a process for data storage is a core function of data management, as are the
processes by which data is obtained, certified fit for use, secured, and processed.
Processes for business intelligence or staffing are separate from data management.
Review the section on Components Required for Effective BI and Analytics in the text.
In the six-phase CRISP-DM method, what comes after "business understanding"? -
ANS-data understandng
Data scientists in organizations are primarily focused on building theories. true false -
ANS-false
To solve the product mix problem that will maximize returns, you can use Excel's Solver
add-in. - ANS-true
You are to advise Modern Enterprises, Inc. so that their BI efforts are fruitful. Which
among the following is the least important advice you could offer? - ANS-you need to
employ the most spohisticated and innovative techniques
It is more important for an organization to have good data management and governance
practices, as well as support from upper management, than it is for the organization to
employ sophisticated and innovative techniques. Review the section on Components
Required for Effective BI and Analytics in the text.
Which of the following is NOT considered a BI and analytics tool?
enterprise resource planning
,regression analysis
data mining
data visualization - ANS-enterprise resource planning
Data visualization, regression analysis, and data mining are all ____________but
______________is not. Review the section on Business Intelligence and Analytics
Tools in the text. - ANS-bi and analytical tools and erp is not
Business analytics can be used only for detecting fraud. - ANS-false
Data mining is used to explore large amounts of data for _________. - ANS-hidden
patterns
simple attribute - ANS-An attribute that cannot be subdivided into meaningful
components. Compare to composite attribute.
Entity Relationship Diagram - ANS-a technique for documenting the entities and
relationships in a database environment
Chen notation - ANS-In ____________________, relationships are represented by a
diamond connected to the related entities through a relationship line.
Crow's Foot notation - ANS-In ___ a three-pronged symbol represents the "many" side
of the relationship.
composite attribute - ANS-An attribute that has meaningful component parts (attributes).
derived attribute - ANS-An attribute whose value can be computed from related attribute
values.
optional attribute - ANS-An attribute that may not have a value for every entity (or
relationship) instance with which it is associated.
required attribute - ANS-In ER modeling, an attribute that must have a value. In other
words, it cannot be left empty.
single-valued attribute - ANS-An attribute that can have only one value.
Multi-valued attribute - ANS-means having the potential to contain more than one value
for an attribute at any given time
, entity identifiers - ANS-one or more attributes that uniquely identify each entity instance
composite identifier - ANS-composed of one or more attribute. needs more htan one.
like a1 a2 a3
relationship - ANS-association between entities
relation from professor to class - ANS-one to many
optional participation - ANS-participation in an entity relationship may be either optional
or mandatory. like when a course doesnt have a course in a semester (1,1) (1,0)
mandatory participation - ANS-each entitiy is required to dparticipate. like class needs a
student to be running. student needs class to be going
relationship degress - ANS-number of entities participating in a relationship
three types of relatinships degrees - ANS-unary, binary, ternary
connectivity terms - ANS-1 to many- one professor teaches many classes
many to many-may students can enroll to many classd
1 to 1- store owner to owner
unary relationship - ANS-association mainatined within a single enityt. manager in
charge of many employees
cardinalities - ANS-a number of pair of numner under the connectivity line . (1,40)
(1,40)d
binary relationship - ANS-most common type of rel. when two entities areassociated in a
relationship
ternary relationship - ANS-when three entities are associate in a common relationship.
like doctor patient drug... all connected to a prescription
relational database model - ANS-data model based on the simple concept of tables in
order to capitalize on characteristics of rows and columns of data
relations - ANS-a set of ordered pairs
In the six-phase CRISP-DM method, what comes after "business understanding"? -
ANS-data understanding
SAP is the vendor of ________. - ANS-Business Objects
SAP is the vendor of Business Objects, a suite of BI applications. Review the section on
Self-Service Analytics in the text.
Which of the following is a core process associated with data management? -
ANS-process for data storage
Of these, a process for data storage is a core function of data management, as are the
processes by which data is obtained, certified fit for use, secured, and processed.
Processes for business intelligence or staffing are separate from data management.
Review the section on Components Required for Effective BI and Analytics in the text.
In the six-phase CRISP-DM method, what comes after "business understanding"? -
ANS-data understandng
Data scientists in organizations are primarily focused on building theories. true false -
ANS-false
To solve the product mix problem that will maximize returns, you can use Excel's Solver
add-in. - ANS-true
You are to advise Modern Enterprises, Inc. so that their BI efforts are fruitful. Which
among the following is the least important advice you could offer? - ANS-you need to
employ the most spohisticated and innovative techniques
It is more important for an organization to have good data management and governance
practices, as well as support from upper management, than it is for the organization to
employ sophisticated and innovative techniques. Review the section on Components
Required for Effective BI and Analytics in the text.
Which of the following is NOT considered a BI and analytics tool?
enterprise resource planning
,regression analysis
data mining
data visualization - ANS-enterprise resource planning
Data visualization, regression analysis, and data mining are all ____________but
______________is not. Review the section on Business Intelligence and Analytics
Tools in the text. - ANS-bi and analytical tools and erp is not
Business analytics can be used only for detecting fraud. - ANS-false
Data mining is used to explore large amounts of data for _________. - ANS-hidden
patterns
simple attribute - ANS-An attribute that cannot be subdivided into meaningful
components. Compare to composite attribute.
Entity Relationship Diagram - ANS-a technique for documenting the entities and
relationships in a database environment
Chen notation - ANS-In ____________________, relationships are represented by a
diamond connected to the related entities through a relationship line.
Crow's Foot notation - ANS-In ___ a three-pronged symbol represents the "many" side
of the relationship.
composite attribute - ANS-An attribute that has meaningful component parts (attributes).
derived attribute - ANS-An attribute whose value can be computed from related attribute
values.
optional attribute - ANS-An attribute that may not have a value for every entity (or
relationship) instance with which it is associated.
required attribute - ANS-In ER modeling, an attribute that must have a value. In other
words, it cannot be left empty.
single-valued attribute - ANS-An attribute that can have only one value.
Multi-valued attribute - ANS-means having the potential to contain more than one value
for an attribute at any given time
, entity identifiers - ANS-one or more attributes that uniquely identify each entity instance
composite identifier - ANS-composed of one or more attribute. needs more htan one.
like a1 a2 a3
relationship - ANS-association between entities
relation from professor to class - ANS-one to many
optional participation - ANS-participation in an entity relationship may be either optional
or mandatory. like when a course doesnt have a course in a semester (1,1) (1,0)
mandatory participation - ANS-each entitiy is required to dparticipate. like class needs a
student to be running. student needs class to be going
relationship degress - ANS-number of entities participating in a relationship
three types of relatinships degrees - ANS-unary, binary, ternary
connectivity terms - ANS-1 to many- one professor teaches many classes
many to many-may students can enroll to many classd
1 to 1- store owner to owner
unary relationship - ANS-association mainatined within a single enityt. manager in
charge of many employees
cardinalities - ANS-a number of pair of numner under the connectivity line . (1,40)
(1,40)d
binary relationship - ANS-most common type of rel. when two entities areassociated in a
relationship
ternary relationship - ANS-when three entities are associate in a common relationship.
like doctor patient drug... all connected to a prescription
relational database model - ANS-data model based on the simple concept of tables in
order to capitalize on characteristics of rows and columns of data
relations - ANS-a set of ordered pairs
