MIS Business Intelligence and Analytics 2

Question 1

What distinguishes descriptive analytics from predictive analytics?

Accepted Answer

Descriptive analytics explains what happened; predictive analytics forecasts what will happen

Answer

Descriptive analytics summarizes historical data to explain past events, while predictive analytics uses statistical models to forecast future outcomes.

Question 2

A star schema in data warehousing consists of:

Accepted Answer

A central fact table surrounded by dimension tables

Answer

A star schema has a central fact table containing measurable business metrics surrounded by denormalized dimension tables providing context.

Question 3

What is the purpose of a data mart?

Accepted Answer

A subset of a data warehouse focused on a specific business function

Answer

A data mart is a subset of the enterprise data warehouse containing data relevant to a specific department or business function like sales or finance.

Question 4

Key Performance Indicators (KPIs) in BI are best described as:

Accepted Answer

Quantifiable metrics that reflect how effectively an organization achieves objectives

Answer

KPIs are quantifiable measurements that evaluate the effectiveness of an organization in meeting its key business objectives.

Question 5

What is prescriptive analytics?

Accepted Answer

Analytics that recommends actions to achieve desired outcomes

Answer

Prescriptive analytics goes beyond describing or predicting to recommend specific actions that will achieve desired outcomes, often using optimization algorithms.

MIS - Management Information Systems Practice Test

MIS - Management Information Systems Practice Test

MIS Business Intelligence and Analytics 2