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
