ISM 3540 QUIZ ANSWERS

Today, many vendors offer diversified tools, some of which are completely preprogrammed (called shells). How are these shells utilized?

All a user needs to do is insert the numbers.

Why is a performance management system superior to a performance measurement system?

because measurement alone has little use without action

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

bubble chart

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

cleanse

Which characteristic of data means that all the required data elements are included in the data set?

data RICHNESS

In the Opening Vignette on Sports Analytics, what type of modeling was used to predict offensive tactics?

heat maps

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

improved customer service

Key performance indicators (KPIs) are metrics typically used to measure

internal results.

All of the following are true about in-database processing technology EXCEPT

it is the same as in-memory storage technology.

What is the management feature of a dashboard?

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

The very design that makes an OLTP system efficient for transaction processing makes it inefficient for

output like end-user ad hoc reports, queries, and analysis.

Which type of visualization tool can be very helpful when the intention is to show relative proportions of dollars per department allocated by a university administration?

pie chart

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

Real-time data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is

speed of data transfer

This measure of dispersion is calculated by simply taking the square root of the variations.

standard deviation

Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are

subject-oriented and nonvolatile.

Dashboards can be presented at all the following levels EXCEPT

the visual cube level.

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.

During the early days of analytics, data was often obtained from the domain experts using manual processes to build mathematical or knowledge-based models.

true

Structured data is what data mining algorithms use and can be classified as categorical or numeric.

true

The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization.

true

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

true

The use of statistics in baseball by the Oakland Athletics, as described in the Moneyball case study, is an example of the effectiveness of prescriptive analytics.

true

With key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily true.

true

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

BI

Major commercial business intelligence (BI) products and services were well established in the early 1970s.

False

How does the use of cloud computing affect the scalability of a data warehouse?

Hardware resources are dynamically allocated as use increases.

Google Maps has set new standards for data visualization with its intuitive Web mapping software.

True

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

True

Predictive algorithms generally require a flat file with a target variable, so making data analytics ready for prediction means that data sets must be transformed into a flat-file format and made ready for ingestion into those predictive algorithms.

True

There are basic chart types and specialized chart types. A Gantt chart is a specialized chart type.

True

Which type of question does visual analytics seeks to answer?

Why is it happening?

Which type of visualization tool can be very helpful when a data set contains location data?

geographic map

Which of the following is LEAST related to data/information visualization?

graphic artwork

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

What is Six Sigma?

a methodology aimed at reducing the number of defects in a business process

This measure of central tendency is the sum of all the values/observations divided by the number of observations in the data set.

arithmetic mean

Kaplan and Norton developed a report that presents an integrated view of success in the organization called

balanced scorecard-type reports.

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

drill down

Bill Inmon advocates the data mart bus architecture whereas Ralph Kimball promotes the hub-and-spoke architecture, a data mart bus architecture with conformed dimensions.

false

Business intelligence (BI) is a specific term that describes architectures and tools only.

false

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

false

Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure.

false

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

false

In the Dallas Cowboys case study, the focus was on using data analytics to decide which players would play every week.

false

OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items.

false

Properly integrating data from various databases and other disparate sources is a trivial process.

false

The BPM development cycle is essentially a one-shot process where the requirement is to get it right the first time.

false

User-initiated navigation of data through disaggregation is referred to as "drill up."

false

With the balanced scorecard approach, the entire focus is on measuring and managing specific financial goals based on the organization's strategy.

false