BUSINESS INTELLIGENCE ANALYTICS DATA
SCIENCE AND AI EXAM SCRIPT UPDATED
QUESTIONS AND ACCURATE ANSWERS
FULL SOLUTION
●● Four tasks of BI systems
Answer: Informing, deciding, problem solving, and project management.
●● Three primary activities in the BI process
Answer: Acquire data, perform analysis, and publish results.
●● Business intelligence vs. business analytics
Answer: BI looks at the past (reactive); business analytics looks at the
present/future (proactive).
●● Descriptive analytics
Answer: Analytics that describe past performance (what happened)
using dashboards and reports.
●● Predictive analytics
Answer: Analytics that use current and historical data to forecast what
will happen.
, ●● Prescriptive analytics
Answer: Analytics that recommend what action to take; the most
advanced type.
●● Data warehouse
Answer: An enterprise-wide facility that obtains, cleanses, organizes,
relates, and catalogs data.
●● Four functions of a data warehouse
Answer: Obtain data, cleanse data, organize and relate data, and catalog
data.
●● Possible problems with source data
Answer: Dirty data, missing values, inconsistent data, wrong granularity,
and too much data.
●● Dirty data
Answer: Erroneous or problematic data, such as an invalid value or
format.
●● Granularity
Answer: The level of detail in data, which can be too fine or too
summarized.
SCIENCE AND AI EXAM SCRIPT UPDATED
QUESTIONS AND ACCURATE ANSWERS
FULL SOLUTION
●● Four tasks of BI systems
Answer: Informing, deciding, problem solving, and project management.
●● Three primary activities in the BI process
Answer: Acquire data, perform analysis, and publish results.
●● Business intelligence vs. business analytics
Answer: BI looks at the past (reactive); business analytics looks at the
present/future (proactive).
●● Descriptive analytics
Answer: Analytics that describe past performance (what happened)
using dashboards and reports.
●● Predictive analytics
Answer: Analytics that use current and historical data to forecast what
will happen.
, ●● Prescriptive analytics
Answer: Analytics that recommend what action to take; the most
advanced type.
●● Data warehouse
Answer: An enterprise-wide facility that obtains, cleanses, organizes,
relates, and catalogs data.
●● Four functions of a data warehouse
Answer: Obtain data, cleanse data, organize and relate data, and catalog
data.
●● Possible problems with source data
Answer: Dirty data, missing values, inconsistent data, wrong granularity,
and too much data.
●● Dirty data
Answer: Erroneous or problematic data, such as an invalid value or
format.
●● Granularity
Answer: The level of detail in data, which can be too fine or too
summarized.