itscm 774 midterm

Data transformation (e.g. log transformation) is especially useful when an attribute has a(n) ___________ distribution.

Asymmetric

The need for more versatile reporting than what was available in 1980s era ERP systems led to the development of what type of system?

Executive information systems

Data is the contextualization of information, that is, information set in context.

False

Decision support system (DSS) and management information system (MIS) have precise definitions agreed to by practitioners.

False

Demands for instant, on-demand access to dispersed information decrease as firms successfully integrate BI into their operations.

False

Due to industry consolidation, the analytics ecosystem consists of only a handful of players across several functional areas.

False

Moving the data into a data warehouse is usually the easiest part of its creation.

False

Nominal data represent the labels of multiple classes used to divide a variable into specific groups.

False

Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses.

False

Successful BI is a tool for the information systems department, but is not exposed to the larger organization.

False

The main problem with redundant data (i.e. duplicate records) is that they take unnecessary memory and storage space.

False

When an attribute involves missing values the only thing we can do is to remove the objects with missing values from analysis.

False

When telling a story during a presentation, it is best to avoid describing hurdles that your character must overcome, to avoid souring the mood.

False

Data warehouses provide direct and indirect benefits to organizations. Which of the following is an indirect benefit of data warehouses?

Improved customer service

_____ providers focus on bringing all the data stores into an enterprise-wide platform.

Middleware

The most common approach for imputing missing values of a nominal attribute is to replace them with the ____________.

Mode

What is the management feature of a dashboard?

Operational data that identify what actions to take to resolve a problem

An unusual, despite correct, value for an attribute is considered as a(n):

Outlier

_____ analytics helps managers understand probable future outcomes.

Predictive

What type of analytics seeks to recognize what is going on as well as the likely forecast and make decisions to achieve the best performance possible?

Prescriptive

When representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure?

Star schema

The attribute selection approaches for dimensionality reduction reduce dimensionality by:

Systematically selecting a subset of the original attributes

Which of the following is NOT true regarding the Principal Component Analysis approach for dimensionality reduction?

The principal components are linearly correlated

Benefits of the latest visual analytics tools, such as SAS Visual Analytics, include all of the following EXCEPT

They explore massive amounts of data in hours, not days.

In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?

Transformation

Interval data are variables that can be measured on interval scales.

True

The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage.

True

The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts.

True

There are some machine learning algorithms that are able to deal with attributes with missing values.

True

Visualization differs from traditional charts and graphs in complexity of data sets and use of multiple dimensions and measures.

True

Which type of question does visual analytics seeks to answer?

Why is it happening?

Which of the following is an umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies?

BI

This plot is a graphical illustration of several descriptive statistics about a given data set.

Box-and-whiskers plot

Which kind of chart is described as an enhanced version of a scatter plot?

Bubble chart

The user interface of a BI system is often referred to as a(n) _____

Dashboard

A large storage location that can hold vast quantities of data (mostly unstructured) in its native/raw format for future/potential analytics consumption is referred to as a(n)

Data lake

When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is:

Drill down

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?

Enterprise application integration