ISM 3540 exam 1

what is Six Sigma? a. a letter in the greek alphabet that statisticians use to measure process variability? b. a methodology aimed at reducing the number of defects in a business process c. a methodology aimed at measuring the amount of variability in a business process d. a methodology aimed at reducing the amount of variability in a business process

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

the measure of central tendency is the sum of all the values/observations divided by the number of observations in the data set a. mediam b. arithmetic mean c. dispersion d. mode

b. arithmetic mean

which of the following is the LEAST related to data/information visualization? a. graphic artwork b. statistical graphics c. information graphics d. scientific visualization

a. graphic artwork

which of the following best enables a data warehouse to handle complex queries and scale up to handle many more requests? a. parallel processing b. larger IT staff c. microsoft windows d. use of the web by users as a front-end

a. parallel processing

in the opening vignette on sports analytics, what type of modeling was used to predict offensive tactics? a. heuristics b. heat maps c. sentiment analysis d. cascaded decision trees

b. heat maps

which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates? a. public data mart b. independent data mart c. volatile data mart d. sectional data mart

b. independent data mart

what is the fundamental challenge of dashboard design? a. ensuring that the organization has the appropriate hardware onsite to support it b. ensuring that the organization has access to the latest web browers c. ensuring that users across the organization have access to it d. ensuring that the required information is shown clearly on a single screen

d. ensuring that the required information is shown clearly on a single screen

how does the use of cloud computing affect the scalability of a data warehouse? a. cloud computing vendors bring as much hardware as needed to users' offices b. cloud vendors are mostly based overseas whereas the cost of labor is low c. cloud computing has little effect on a data warehouse's scalability d. hardware resources are dynamically allocated as use increases

d. hardware resources are dynamically allocated as use increases

Business Intelligence is a specific term that describes architectures and tools only

false

T/F information systems that support such transactions as ATM withdrawals, bank deposits, and cash register scans at the grocery store represent transaction processing, a critical branch of BI

false

T/F: computerized support is only used for organizational decisions that are responses to external pressures, not for taking advantage of opportunities.

false

T/F 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 flat-file format and made ready for ingestion into those predictive algorithms

true

T/F there are basic chart types and specialized chart types. A gantt chart is a specialized chart type

true

the competitive imperatives for BI include all of the following except a. right type of data center b. right time c. right place d. right information

a. right type of data center

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 a. speed of data transfer b. source of the data c. country of the (data) origin d. nature of the data

a. speed of data transfer

contextual metadata for a dashboard includes all the following EXCEPT a. which operating system is running the dashboard server software b. whether the dashboard is presenting "fresh" or "stale" information c. whether any high-value transactions that would skew the overall trends were rejected as a part of the loading process d. when the data warehouse was last refreshed

a. which operating system is running the dashboard server software

key performance indicators (KPIs) are metrics typically used to measure a. qualitative feedback b. internal results c. external results d. database responsiveness

b. internal results

Dashboards can be presented at all the following levels EXCEPT a. the self-service cube level b. the visual cube level c. the visual dashboard level d. the static report level

b. the visual cube level

benefits of the latest visual analytics tools, such as SAS Visual analytics, include all of the following EXCEPT: a. it is easier to spot useful patterns and trends in the data b. they explore massive amount of data in hours, not days c. there is less demand on IT departments for reports d. mobile platforms such as the iPhone are supported by these products

b. they explore massive amount of data in hours, not days

why is a performance management system superior to a performance measurement system? a. because performance management systems cost more b. because performance measurement systems are only in their infancy c. because measurement alone has little use without action d. because measurement automatically leads to problem solution

c. because measurement alone has little use without action

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? a. snowflake schema b. dimensional schema c. star schema d. relational schema

c. star schema

which type of question does visual analytics seeks to answer? a. what happened yesterday? b. when did it happen? c. why is it happening? d. what is happening today?

c. why is it happening?

when you tell a story in a presentation, all the following are true EXCEPT a. the outcome and reasons for it should be clear at the end of your story b. a story should make sense and order out of a lot of background noise c. stories and their lessons should be easy to remember d. a well-told story should have no need for subsequent discussion

d. a well-told story should have no need for subsequent discussion

BI applications must be integrated with a. legacy systems b. databases c. enterprise systems d. all of these

d. all of these

kaplan and norton developed a report that presents an integrated view of success in the organization called a. metric management reports b. dashboard-type reports c. visual reports d. balanced scorecard-type reports

d. balanced scorecard-type reports

which kind of chart is described as an enhanced version of a scatter plot? a. bullet b. heat map c. pie chart d. bubble chart

d. bubble chart

which characteristics of data requires that the variables and ddata values be defined at the lowest (or as low as required) level of detail for the intended use of the data? a. data source reliability b. data accessibility c. data richness d. data granularity

d. data granularity

when querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is a. slice b. roll-up c. dice d. drill down

d. drill down

all of the following are true about in-database processing technology EXCEPT a. it pushes the algorithms to where the data is b. it makes the response to queries much faster than conventional databases c. it is often used for apps like credit card fraud detection and investment risk management d. it is the same as in-memory storage tech

d. it is the same as in-memory storage tech

this measure of dispersion is calculated by simply taking the square root of the variations a. arithmetic mean b. range c. variance d. standard deviation

d. standard deviation

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

false

T/F bill inmom advocated the data mart bus architecture whereas ralph kimball promotes the hub-and-spoke architecture, a data mart bus architecture with confirmed dimensions

false

T/F data source reliability means that data are correct and are a good match for the analytics problem

false

T/F data warehouses are subsets of data marts

false

T/F demands for instant, on-demand access to dispersed information decrease as firms successfully intergrate BI into their operations

false

T/F nominal data represents the labels of multiple classes used to divide a variable into specific groups

false

T/F properly integrating data from various databases and other disparate sources is a trivial process

false

T/F subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks

false

T/F the BPM development cycle is essentially a one-shot process where the requirement is to get it right the first time

false

T/F the data storage component of a business reporting system builds the various reports and hosts them for, or disseminates them to users. it also provides notification, annotation, collaboration, and other services

false

T/F the use of dashboards and data visualizations is seldom effective in identifying issues in organizations, as demonstrated by the Silvaris Corporation Case Study

false

T/F user-initiated navigation of data through disaggregation is referred to as "drill up"

false

T/F with the balanced scorecard approach, the entire focus is on measuring and managing specific financial goals based on the organization's strategy

false

T/F computer applications have moved from transaction processing and monitoring activities to problem analysis and solution applications

true

T/F data accessibility means that the data are easily and readily obtainable

true

T/F google maps has new set standards for data visualization with its intuitive Web mapping software

true

T/F many business users in the 1980s referred to their mainframes as "the black hole", because all the information went into it, but little ever came back and ad hoc real-time querying was virtually impossible

true

T/F the "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization

true

T/F the data warehousing maturity model consists of 6 six stages: prenatal, infant, child, teenager, adult and sage

true

T/F with key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily true

true