Deck 7: Accounting and Business Intelligence

Full screen (f)
exit full mode
Question
________ uses mathematical algorithms to predict future trends, such as future customer purchases.
Use Space or
up arrow
down arrow
to flip the card.
Question
Business intelligence answers questions such as

A)What products did customers buy last week?
B)What products did customers buy today?
C)What products will customers will buy next year?
D)What products did customers buy last years?
Question
________ can be used to improve decision making and business performance.
Question
________ systems provided information for routine, operational decisions.
Question
________ uses mathematical algorithms to find patterns, trends, and relationships among data, such as customer purchasing patterns.
Question
Strategic decisions are typically short term, impacting one year or less.
Question
Data is transformed into information (meaningful data)when the data is processed and organized in a systematic manner.
Question
Decision support systems provided support for strategic decisions.
Question
The purpose of integrating quantitative and qualitative factors in the decision making process is to

A)Organize the decision making process
B)Bring order to the complex business environment
C)Improve the quality of the decision
D)To analyze why customers buy a certain product or service
Question
Business intelligence can be used to answer questions such as "What products did customers purchase last year?"
Question
Routine decisions are

A)Unstructured
B)Recurring and typically relate to ongoing business operations
C)Usually long term in nature and unstructured with a high degree of ambiguity
D)Typically short term, impacting one year or less
Question
Strategic decisions are

A)Usually long term in nature and unstructured with a high degree of ambiguity
B)Semi-structured
C)Typically short term, impacting one year or less
D)Recurring and typically relate to ongoing business operations
Question
Tactical decisions are

A)Recurring and typically relate to ongoing business operations
B)Usually long term in nature and unstructured with a high degree of ambiguity
C)Typically short term, impacting one year or less
D)Structured
Question
In an Integrative Decision Model, an example of a qualitative factor is

A)Revenue
B)Cost
C)Return on investment
D)Product quality
Question
Which one of the following is not a predecessor of today's tools used for data analysis?

A)Executive information systems
B)Business Intelligence systems
C)Enterprise resource planning systems
D)Decision support systems
Question
________ decisions are recurring and typically relate to ongoing business operations.
Question
Intelligence involves the ability to see meaningful interrelationships and glean insights.
Question
Predictive modeling uses mathematical algorithms to

A)Identify trends
B)Predict future trends
C)Find patterns
D)Identify relationships among data
Question
Executive information systems provide information for tactical, semi-structured decisions.
Question
Which business intelligence tool is more likely to identify a credit card transaction from a stolen credit and not from the cardholder?

A)Data mining
B)Predictive modeling
C)Interactive decision model
D)Shadow data
Question
The ________ provides a framework to structure and organize the decision-making process.
Question
What is the Integrative Decision Model?
Question
Business intelligence technologies are typically under the control of the enterprise's IT professionals.
Question
List and explain the seven basic steps in the IDM framework.
Question
________ is used when data is stored in spreadsheets and other tools that shadow the formal accounting system.
Question
As the business environment becomes more complex and diverse, more factors must be considered when making decisions.
Question
An IDM spreadsheet template includes both quantitative (financial)and qualitative (non-financial)analysis.
Question
What is a qualitative factor?
Question
A data warehouse is a large database that serves as a central location for aggregating and storing an enterprise's data.
Question
What is a quantitative factor? Provide an example.
Question
Create/draw the IDM template.
Question
The IDM consists of seven basic steps as a framework for the decision-making and evaluation process. List these steps in order.
Question
________ technologies include analytics, data mining, and predictive modeling.
Question
In the IDM basic steps framework, when quantitative analysis may consist of

A)Product quality, timeliness, the stress factor, streamlining, ease of use, overall satisfaction
B)Creative solutions and brainstorming techniques
C)Cost-benefit analysis, cost-volume-profit analysis, capital budgeting
D)Make certain you have identified and are addressing the core issue rather than a symptom
Question
With ________ analysis you are attempting to compare the financial costs and benefits of each option and determine the differences.
Question
What were the predecessors of today's sophisticated intelligence tools used for data analysis?
Question
One of the steps not in the IDM basic steps framework is

A)Define the symptom of the issue
B)Analyze the quantitative factors
C)Evaluate performance
D)Identify options
Question
Qualitative data answers which question?

A)When?
B)Where?
C)How much?
D)Why?
Question
The process of integrating financial and non-financial factors into the decision process can lessen the quality of the decision.
Question
Define the three of business decisions. Provide an example of each.
Question
Software called ________ translates data analysis query commands into commands that are compatible with RDBMS commands.
Question
A digital dashboard is a(n)

A)Tool used to extract data from a data database
B)Interactive data visualization tool
C)Transfers data to a data analysis tool
D)Stores data
Question
What are two approaches to business intelligence commonly used by companies?
Question
An analysis tool not designed for software spreadsheets is

A)AutoFilter
B)PivotTables
C)Subtotal
D)Neural networks
Question
Shadow data can exist in tools other that spreadsheets, such as user-developed databases.
Question
Business intelligence technologies do not include

A)Data storage
B)Analytics
C)Predictive modeling
D)Data mining
Question
Standardizing spreadsheets to permit global spreadsheet analysis within an organization does not involve

A)The creation of formatting guidelines
B)Password protecting individual spreadsheets
C)Requiring all spreadsheets be stored on an enterprise server
D)Assigning a unique identifer to each spreadsheet
Question
Quantitative data answers which question?

A)What?
B)How much?
C)Where?
D)Why?
Question
Business intelligence tools allow you to

A)View the same data in different ways
B)Examine past history
C)Transform data into information
D)Extract data from a database
Question
Data storage for shadow data is kept in a centralized location in an organization.
Question
Spreadsheets can be used to

A)Create two-dimensional databases
B)Store data that is not in the accounting system
C)Keep data secure
D)A and B
Question
Data is extracted from a database and transferred to a spreadsheet using

A)Open DataBase Connectivity (ODBC)
B)Extract/Transfer/Load tools
C)Manual entry
D)B and C
Question
Control of business intelligence technologies is usually under the control of

A)IT professionals
B)Accounting professionals
C)Security professionals
D)Executive management
Question
Which of the following is considered a disadvantage of shadow data?

A)Spreadsheets are outside the formal data systems under IT control.
B)An accounting professional can develop the spreadsheet solution when needed.
C)Spreadsheets have extensive analytic features.
D)Spreadsheets offer reporting features that do not require custom programming.
Question
Business informatics focuses on how to

A)Visualize data
B)Store data
C)Keep data secure
D)Use information technology to solve business problems
Question
Business ________ focuses on how to use information technology to solve business problems.
Question
The ODBC as a ________ between the database and the spreadsheet.
Question
A shadow data dashboard in an Excel spreadsheet can be created using

A)AutoFilter and PivotCharts
B)Conditional Formatting and Subtotal
C)PivotTables and PivotCharts
D)PivotTables and Conditional Formatting
Question
Shadow data is vulnerable to

A)Data analysis
B)Unauthorized access
C)Data collection
D)Manipulation
Question
List and explain the four components of an intelligent enterprise system.
Question
The primary keys of the dimension tables are foreign keys in the ________ at the center of the star.
Question
Business intelligence technologies reside under the control of the ________ providing the opportunity for standardization of controls to secure the system.
Question
The dimension tables in a star database are dimensions of the database, such as time dimension, product information, sales territory, and currency.
Question
An ________ is simply a step-by-step solution to a problem.
Question
Business intelligence technologies are

A)Just another form of unsecured shadow data
B)Are usually controlled by accounting professionals
C)A type of advanced data analytics used to support business decision making
D)Consist of database queries that take a long time to run
Question
What are the disadvantages of shadow data?
Question
Business Intelligence Technologies are a type of advanced data analytics used to support business decision making.
Question
A ________ graphically represents BI, allowing the user to manipulate data and view the resulting changes.
Question
What are the advantages of shadow data?
Question
A dimensional database has one ________ table and two or more dimension (Dim)tables.
Question
What are three ways of standardizing and securing shadow data spreadsheets within an organization?
Question
What is the purpose of Open DataBase Connectivity (ODBC)software?
Question
What are some of the data analysis tools available for software spreadsheets, such as MS Excel?
Question
Why are shadow data spreadsheets created?
Question
________ can be used to mine text stored in various enterprise documents, including emails, word processing documents, and reports.
Question
BI technologies store in a data warehouse that uses the relational database structure.
Question
Why are spreadsheets popular for performing data analysis?
Question
Predictive modeling also uses algorithms to identify patterns and trends and then predict future behavior.
Question
________ techniques rely on pattern recognition, clustering, and neural networks.
Question
In a dimensional database with a star structure, a query traverses only three tables.
Unlock Deck
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/100
auto play flashcards
Play
simple tutorial
Full screen (f)
exit full mode
Deck 7: Accounting and Business Intelligence
1
________ uses mathematical algorithms to predict future trends, such as future customer purchases.
Predictive modeling
2
Business intelligence answers questions such as

A)What products did customers buy last week?
B)What products did customers buy today?
C)What products will customers will buy next year?
D)What products did customers buy last years?
C
3
________ can be used to improve decision making and business performance.
Business intelligence
4
________ systems provided information for routine, operational decisions.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
5
________ uses mathematical algorithms to find patterns, trends, and relationships among data, such as customer purchasing patterns.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
6
Strategic decisions are typically short term, impacting one year or less.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
7
Data is transformed into information (meaningful data)when the data is processed and organized in a systematic manner.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
8
Decision support systems provided support for strategic decisions.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
9
The purpose of integrating quantitative and qualitative factors in the decision making process is to

A)Organize the decision making process
B)Bring order to the complex business environment
C)Improve the quality of the decision
D)To analyze why customers buy a certain product or service
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
10
Business intelligence can be used to answer questions such as "What products did customers purchase last year?"
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
11
Routine decisions are

A)Unstructured
B)Recurring and typically relate to ongoing business operations
C)Usually long term in nature and unstructured with a high degree of ambiguity
D)Typically short term, impacting one year or less
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
12
Strategic decisions are

A)Usually long term in nature and unstructured with a high degree of ambiguity
B)Semi-structured
C)Typically short term, impacting one year or less
D)Recurring and typically relate to ongoing business operations
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
13
Tactical decisions are

A)Recurring and typically relate to ongoing business operations
B)Usually long term in nature and unstructured with a high degree of ambiguity
C)Typically short term, impacting one year or less
D)Structured
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
14
In an Integrative Decision Model, an example of a qualitative factor is

A)Revenue
B)Cost
C)Return on investment
D)Product quality
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
15
Which one of the following is not a predecessor of today's tools used for data analysis?

A)Executive information systems
B)Business Intelligence systems
C)Enterprise resource planning systems
D)Decision support systems
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
16
________ decisions are recurring and typically relate to ongoing business operations.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
17
Intelligence involves the ability to see meaningful interrelationships and glean insights.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
18
Predictive modeling uses mathematical algorithms to

A)Identify trends
B)Predict future trends
C)Find patterns
D)Identify relationships among data
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
19
Executive information systems provide information for tactical, semi-structured decisions.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
20
Which business intelligence tool is more likely to identify a credit card transaction from a stolen credit and not from the cardholder?

A)Data mining
B)Predictive modeling
C)Interactive decision model
D)Shadow data
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
21
The ________ provides a framework to structure and organize the decision-making process.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
22
What is the Integrative Decision Model?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
23
Business intelligence technologies are typically under the control of the enterprise's IT professionals.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
24
List and explain the seven basic steps in the IDM framework.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
25
________ is used when data is stored in spreadsheets and other tools that shadow the formal accounting system.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
26
As the business environment becomes more complex and diverse, more factors must be considered when making decisions.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
27
An IDM spreadsheet template includes both quantitative (financial)and qualitative (non-financial)analysis.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
28
What is a qualitative factor?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
29
A data warehouse is a large database that serves as a central location for aggregating and storing an enterprise's data.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
30
What is a quantitative factor? Provide an example.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
31
Create/draw the IDM template.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
32
The IDM consists of seven basic steps as a framework for the decision-making and evaluation process. List these steps in order.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
33
________ technologies include analytics, data mining, and predictive modeling.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
34
In the IDM basic steps framework, when quantitative analysis may consist of

A)Product quality, timeliness, the stress factor, streamlining, ease of use, overall satisfaction
B)Creative solutions and brainstorming techniques
C)Cost-benefit analysis, cost-volume-profit analysis, capital budgeting
D)Make certain you have identified and are addressing the core issue rather than a symptom
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
35
With ________ analysis you are attempting to compare the financial costs and benefits of each option and determine the differences.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
36
What were the predecessors of today's sophisticated intelligence tools used for data analysis?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
37
One of the steps not in the IDM basic steps framework is

A)Define the symptom of the issue
B)Analyze the quantitative factors
C)Evaluate performance
D)Identify options
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
38
Qualitative data answers which question?

A)When?
B)Where?
C)How much?
D)Why?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
39
The process of integrating financial and non-financial factors into the decision process can lessen the quality of the decision.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
40
Define the three of business decisions. Provide an example of each.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
41
Software called ________ translates data analysis query commands into commands that are compatible with RDBMS commands.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
42
A digital dashboard is a(n)

A)Tool used to extract data from a data database
B)Interactive data visualization tool
C)Transfers data to a data analysis tool
D)Stores data
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
43
What are two approaches to business intelligence commonly used by companies?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
44
An analysis tool not designed for software spreadsheets is

A)AutoFilter
B)PivotTables
C)Subtotal
D)Neural networks
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
45
Shadow data can exist in tools other that spreadsheets, such as user-developed databases.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
46
Business intelligence technologies do not include

A)Data storage
B)Analytics
C)Predictive modeling
D)Data mining
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
47
Standardizing spreadsheets to permit global spreadsheet analysis within an organization does not involve

A)The creation of formatting guidelines
B)Password protecting individual spreadsheets
C)Requiring all spreadsheets be stored on an enterprise server
D)Assigning a unique identifer to each spreadsheet
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
48
Quantitative data answers which question?

A)What?
B)How much?
C)Where?
D)Why?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
49
Business intelligence tools allow you to

A)View the same data in different ways
B)Examine past history
C)Transform data into information
D)Extract data from a database
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
50
Data storage for shadow data is kept in a centralized location in an organization.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
51
Spreadsheets can be used to

A)Create two-dimensional databases
B)Store data that is not in the accounting system
C)Keep data secure
D)A and B
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
52
Data is extracted from a database and transferred to a spreadsheet using

A)Open DataBase Connectivity (ODBC)
B)Extract/Transfer/Load tools
C)Manual entry
D)B and C
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
53
Control of business intelligence technologies is usually under the control of

A)IT professionals
B)Accounting professionals
C)Security professionals
D)Executive management
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
54
Which of the following is considered a disadvantage of shadow data?

A)Spreadsheets are outside the formal data systems under IT control.
B)An accounting professional can develop the spreadsheet solution when needed.
C)Spreadsheets have extensive analytic features.
D)Spreadsheets offer reporting features that do not require custom programming.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
55
Business informatics focuses on how to

A)Visualize data
B)Store data
C)Keep data secure
D)Use information technology to solve business problems
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
56
Business ________ focuses on how to use information technology to solve business problems.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
57
The ODBC as a ________ between the database and the spreadsheet.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
58
A shadow data dashboard in an Excel spreadsheet can be created using

A)AutoFilter and PivotCharts
B)Conditional Formatting and Subtotal
C)PivotTables and PivotCharts
D)PivotTables and Conditional Formatting
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
59
Shadow data is vulnerable to

A)Data analysis
B)Unauthorized access
C)Data collection
D)Manipulation
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
60
List and explain the four components of an intelligent enterprise system.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
61
The primary keys of the dimension tables are foreign keys in the ________ at the center of the star.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
62
Business intelligence technologies reside under the control of the ________ providing the opportunity for standardization of controls to secure the system.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
63
The dimension tables in a star database are dimensions of the database, such as time dimension, product information, sales territory, and currency.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
64
An ________ is simply a step-by-step solution to a problem.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
65
Business intelligence technologies are

A)Just another form of unsecured shadow data
B)Are usually controlled by accounting professionals
C)A type of advanced data analytics used to support business decision making
D)Consist of database queries that take a long time to run
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
66
What are the disadvantages of shadow data?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
67
Business Intelligence Technologies are a type of advanced data analytics used to support business decision making.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
68
A ________ graphically represents BI, allowing the user to manipulate data and view the resulting changes.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
69
What are the advantages of shadow data?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
70
A dimensional database has one ________ table and two or more dimension (Dim)tables.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
71
What are three ways of standardizing and securing shadow data spreadsheets within an organization?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
72
What is the purpose of Open DataBase Connectivity (ODBC)software?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
73
What are some of the data analysis tools available for software spreadsheets, such as MS Excel?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
74
Why are shadow data spreadsheets created?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
75
________ can be used to mine text stored in various enterprise documents, including emails, word processing documents, and reports.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
76
BI technologies store in a data warehouse that uses the relational database structure.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
77
Why are spreadsheets popular for performing data analysis?
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
78
Predictive modeling also uses algorithms to identify patterns and trends and then predict future behavior.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
79
________ techniques rely on pattern recognition, clustering, and neural networks.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
80
In a dimensional database with a star structure, a query traverses only three tables.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
locked card icon
Unlock Deck
Unlock for access to all 100 flashcards in this deck.