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