ISM 3541: Introduction to Business
Analytics final exam with detailed
answers and rationale updated 2026
Total Questions: 100 | Time Limit: 120 Minutes | 1 Point Each
Which of the following is the standard industry definition of Business Analytics?
A) The process of building data warehouses and transactional databases
B) The systematic use of data, statistical methods and quantitative models to improve fact-based
business decision making
C) The creation of dashboards and weekly reports for business managers
D) The implementation of artificial intelligence to automate routine work
Rationale: This is the definition published by INFORMS and taught as the foundation of this course. A
describes data engineering, C describes only descriptive analytics, D describes only one narrow
application of analytics.
What is the correct order of the analytics value hierarchy from lowest to highest business value?
A) Prescriptive, Predictive, Diagnostic, Descriptive
B) Descriptive, Diagnostic, Predictive, Prescriptive
C) Diagnostic, Descriptive, Prescriptive, Predictive
D) Predictive, Prescriptive, Descriptive, Diagnostic
Rationale: This is the fundamental framework for the entire course. Each level builds on the prior
one and answers a progressively more impactful business question.
Which category of analytics answers the question "What happened?"
A) Diagnostic
B) Predictive
C) Descriptive
D) Prescriptive
,Rationale: This is the core definition of descriptive analytics. Diagnostic answers why, predictive
answers what will happen, prescriptive answers what should we do.
Which category of analytics answers the question "Why did it happen?"
A) Diagnostic
B) Predictive
C) Descriptive
D) Prescriptive
Rationale: Diagnostic analytics is focused exclusively on identifying root causes of past outcomes.
Which category of analytics answers the question "What will happen?"
A) Diagnostic
B) Predictive
C) Descriptive
D) Prescriptive
Rationale: Predictive analytics generates probabilistic forecasts of future outcomes.
Which category of analytics answers the question "What should we do?"
A) Diagnostic
B) Predictive
C) Descriptive
D) Prescriptive
Rationale: Prescriptive analytics is the highest level of the hierarchy, and the only one that provides
actionable recommendations.
Which of the following is the universal standard process model for business analytics projects?
A) Agile
B) Waterfall
C) CRISP-DM
D) Scrum
Rationale: CRISP-DM (Cross Industry Standard Process for Data Mining) is the standard process
taught in all introductory BA courses. Agile and Scrum are software development methodologies.
,What is the first step of the CRISP-DM process?
A) Data understanding
B) Data preparation
C) Business understanding
D) Modeling
Rationale: This is the most commonly missed question on introductory BA exams. All analytics
projects must start with defining the business problem, not with data.
Approximately what percentage of time on a typical BA project is spent on data cleaning and
preparation?
A) 10%
B) 30%
C) 50%
D) 80%
Rationale: This is an industry standard rule of thumb that is emphasized repeatedly in this course.
Data preparation is by far the most time consuming part of almost all analytics work.
Which of the following is an example of a vanity metric?
A) Customer churn rate
B) Number of website visitors
C) Customer lifetime value
D) Gross margin per customer
Rationale: A vanity metric looks good on a report but does not directly correlate to business
outcomes. All other options are true actionable KPIs.
What is the difference between a report and a dashboard?
A) Dashboards are interactive, reports are static
B) Reports show what happened, dashboards show what is happening right now
C) Reports are for analysts, dashboards are for managers
D) There is no meaningful difference
Rationale: This is the standard functional definition taught in ISM 3541.
, OLTP systems are optimized for:
A) Processing individual transactions
B) Running analytical queries
C) Storing historical data
D) Creating dashboards
Rationale: OLTP = Online Transaction Processing. OLAP is optimized for analytics.
OLAP systems are optimized for:
A) Processing individual transactions
B) Running analytical queries across large datasets
C) Recording new customer orders
D) Processing credit card payments
Rationale: This is the core distinction between OLTP and OLAP, one of the most important
foundational concepts.
Which of the following roles is responsible for translating business requirements into analytics
questions?
A) Data Engineer
B) Data Scientist
C) Business Analyst
D) Database Administrator
Rationale: This is the core definition of the business analyst role.
The single most common and most expensive mistake made in business analytics is:
A) Using incomplete data
B) Building overly complex models
C) Confusing correlation with causation
D) Poor presentation of results
Rationale: This is cited in every introductory BA textbook as the number one mistake made by new
and experienced analysts alike.
Analytics final exam with detailed
answers and rationale updated 2026
Total Questions: 100 | Time Limit: 120 Minutes | 1 Point Each
Which of the following is the standard industry definition of Business Analytics?
A) The process of building data warehouses and transactional databases
B) The systematic use of data, statistical methods and quantitative models to improve fact-based
business decision making
C) The creation of dashboards and weekly reports for business managers
D) The implementation of artificial intelligence to automate routine work
Rationale: This is the definition published by INFORMS and taught as the foundation of this course. A
describes data engineering, C describes only descriptive analytics, D describes only one narrow
application of analytics.
What is the correct order of the analytics value hierarchy from lowest to highest business value?
A) Prescriptive, Predictive, Diagnostic, Descriptive
B) Descriptive, Diagnostic, Predictive, Prescriptive
C) Diagnostic, Descriptive, Prescriptive, Predictive
D) Predictive, Prescriptive, Descriptive, Diagnostic
Rationale: This is the fundamental framework for the entire course. Each level builds on the prior
one and answers a progressively more impactful business question.
Which category of analytics answers the question "What happened?"
A) Diagnostic
B) Predictive
C) Descriptive
D) Prescriptive
,Rationale: This is the core definition of descriptive analytics. Diagnostic answers why, predictive
answers what will happen, prescriptive answers what should we do.
Which category of analytics answers the question "Why did it happen?"
A) Diagnostic
B) Predictive
C) Descriptive
D) Prescriptive
Rationale: Diagnostic analytics is focused exclusively on identifying root causes of past outcomes.
Which category of analytics answers the question "What will happen?"
A) Diagnostic
B) Predictive
C) Descriptive
D) Prescriptive
Rationale: Predictive analytics generates probabilistic forecasts of future outcomes.
Which category of analytics answers the question "What should we do?"
A) Diagnostic
B) Predictive
C) Descriptive
D) Prescriptive
Rationale: Prescriptive analytics is the highest level of the hierarchy, and the only one that provides
actionable recommendations.
Which of the following is the universal standard process model for business analytics projects?
A) Agile
B) Waterfall
C) CRISP-DM
D) Scrum
Rationale: CRISP-DM (Cross Industry Standard Process for Data Mining) is the standard process
taught in all introductory BA courses. Agile and Scrum are software development methodologies.
,What is the first step of the CRISP-DM process?
A) Data understanding
B) Data preparation
C) Business understanding
D) Modeling
Rationale: This is the most commonly missed question on introductory BA exams. All analytics
projects must start with defining the business problem, not with data.
Approximately what percentage of time on a typical BA project is spent on data cleaning and
preparation?
A) 10%
B) 30%
C) 50%
D) 80%
Rationale: This is an industry standard rule of thumb that is emphasized repeatedly in this course.
Data preparation is by far the most time consuming part of almost all analytics work.
Which of the following is an example of a vanity metric?
A) Customer churn rate
B) Number of website visitors
C) Customer lifetime value
D) Gross margin per customer
Rationale: A vanity metric looks good on a report but does not directly correlate to business
outcomes. All other options are true actionable KPIs.
What is the difference between a report and a dashboard?
A) Dashboards are interactive, reports are static
B) Reports show what happened, dashboards show what is happening right now
C) Reports are for analysts, dashboards are for managers
D) There is no meaningful difference
Rationale: This is the standard functional definition taught in ISM 3541.
, OLTP systems are optimized for:
A) Processing individual transactions
B) Running analytical queries
C) Storing historical data
D) Creating dashboards
Rationale: OLTP = Online Transaction Processing. OLAP is optimized for analytics.
OLAP systems are optimized for:
A) Processing individual transactions
B) Running analytical queries across large datasets
C) Recording new customer orders
D) Processing credit card payments
Rationale: This is the core distinction between OLTP and OLAP, one of the most important
foundational concepts.
Which of the following roles is responsible for translating business requirements into analytics
questions?
A) Data Engineer
B) Data Scientist
C) Business Analyst
D) Database Administrator
Rationale: This is the core definition of the business analyst role.
The single most common and most expensive mistake made in business analytics is:
A) Using incomplete data
B) Building overly complex models
C) Confusing correlation with causation
D) Poor presentation of results
Rationale: This is cited in every introductory BA textbook as the number one mistake made by new
and experienced analysts alike.
