Lydia Kesatie Flashcards
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 number
Which of the following developments is not contributing to facilitating the growth of decision support analytics
Locally concentrated workforces
Software monitors referred to as ___ can be placed on a separate server in the network and use event- and process based approaches to measure and monitor operational processes
Intelligent Agents
____ cycle times are now extremely compressed, faster, and more informed across industries
Business
This plot is a graphical illustration of several descriptive statistics about a given data set.
Box-and-whiskers plot
This measure of dispersion is calculated by simply taking the square root of the variations
Standard Deviation
Which characteristic of data requires that the variables and data values be defined at the lowest (or as low as required) level of detail for the intended use of the data?
Data Granularity
____ statistics is about drawing conclusions about the characteristics of the population
Inferential
When validating the assumptions of a regression, ____ assumes that the relationship between the response variable and the explanatory variable are linear.
Linearity
What is the management feature of a dashboard?
Operational data that identify what actions to take to resolve a problem.
Which of the following is Least related to data/information visualization?
Graphic Artwork
___ are typically used together with other charts and graphs, as opposed to by themselves, and show postal codes, country names, etc.
Maps
Visual analytics is widely regarded as the combination of visualization and ___ analytics
Predictive
Which of the following is an umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies?
BI
In what decade did disjoint information systems begin to be integrated?
1980s
What has caused the growth of the demand for instant, on-demand access to dispersed information?
The more pressing need to close the gap between the operational data and strategic objectives
The very design that makes an OLTP system efficient for transaction processing makes it ineffective for
End-user ad hoc reports, queries, and analysis
Which type of question does visual analytics seeks to answer
Why is it happening?
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
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
Which kind of chart is described as an enhanced version of a scatter plot?
Bubble Chart
The internet emerged as a new medium for visualization and brought all the following EXCEPT
a.
New forms of computation of business logic.
Key Performance Indicators (KPIs) are metrics typically used to measure
Internal results
List and Explain three levels or categories of analytics that are most often viewed as sequential and independent, but also occasionally overlapping.
Descriptive or reporting analytics refers to knowing what is happening in the organization and understanding some underlying trends and causes of such occurrences.
Predictive analytics aims to determine what is likely to happen in the future. This analysis is based on statistical techniques that fall under the general category of data mining.
Prescriptive analytics recognize what is going on as well as the likely forecast and makes decisions to achieve the best performance possible
A web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of
three-tier architecture
Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are
Subject-oriented and nonvolatile
Oper marts are created when operational data needs to be analyzed
multidimensionally
The three main types of data warehouses are data marts, operational ________ , and enterprise data warehouses
data store
A(n) ____ data store (ODS) provides a fairly recent form of customer information file.
Operational
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
In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?
Cleanse
Data warehouses provide direct and indirect benefits to organizations. Which of the following is an indirect benefit of data warehousing?
Improved Customer Service
Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?
Enterprise application integration
Data ____ comprises data access, data federation, and change capture
Integration
____ as a ____, or “The Extended ASP Model “, is a creative way of deploying information system applications where the provider licenses its applications to customers for use as a service on demand.
Software, Service
Why is performance management system superior to a performance measurement system?
Because measurement alone has little use without action
What is Six Sigma?
A methodology aimed at reducing the number of defects in a business process
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
source of the data
_____ is an evolving tool space that promises real-time data integration from a variety of sources such as relational databases, Web services, and multidimensional databases.
Enterprise information integration (EII)
Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?
Enterprise Application Integration
What is the main reason parallel processing is sometimes used for data mining?
Because of the massive data amounts and search efforts involved
Which broad area of data mining applications analyzes data, forming rules to distinguish between defined classes?
Classification
The data field “ethnic group” can best be describe as
Nominal data
Data are often buried deep within very large ___, which sometimes contain data from several years.
databases
There has been an increase in data mining to deal with global competition and customer more sophisticated _____ and wants
Needs
Data preparation, the third step in the CRISP-DM data mining process, is more commonly known as _____
data processing.
Business applications have moved from transaction processing and monitoring to other activities. Which of the following is NOT one of those activities?
a. data monitoring
b. problem analysis
c. mobile access
d. solution applications
a. data monitoring
Which characteristic of data means that all the required data elements are included in the data set?
Data Richness
Dashboards can be presented at all the following levels EXCEPT
a. the self-service cube level
b. the visual cube level
c. the static report level
d. the visual dashboard level
b. the visual cube level
Which of the following statements about Big Data is true?
a. data chunks are stored in different locations on one computer.
b. Hadoop is a type of processor used to process Big Data applications
c. MapReduce is a storage filing system.
d. Pure Big Data systems do not involve fault tolerance
d. Pure Big Data systems do not involve fault tolerance
The competitive imperatives for BI include all of the following EXCEPT
a. right information
b. right user
c. right time
d. right place
d. right place
Benefits of the latest visual analytics tools, such as SAS Visual Analytics, include all of the following EXCEPT
a. mobile platforms such as the iPhone are supported by these products
b. it is easier to spot useful patterns and trends in the data
c. they explore massive amounts of data in hours, not days
d. there is less demand on IT departments for reports
c. they explore massive amounts of data in hours, not days
KPIs have all of the distinguishing criteria, EXCEPT
a. Limits
b. Benchmarks
c. Ranges
d. Encodings
e. Targets
a. Limits
The DMAIC performance improvement model all of the following steps, EXCEPT
a. Monitor
b. Define
c. Improve
d. Control
a. Monitor
Six Sigma Performance Measurement System has all of the following characteristics, EXCEPT
a. Emphasize learning and innovation
b. Emphasizes targets for each measurement
c. Identifies measures that drive performance
d. Includes all business processors
b. Emphasizes targets for each measurement
All of the following are benefits of hosted data warehouses EXCEPT
a. smaller upfront investment
b. better quality hardware
c. frees up in-house systems
d. greater control of data
d. greater control of data
Which kind of data warehouse is created separately from the enterprise data warehouse by department and not reliant on it for updates?
Independent data mart
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 of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?
a. use of the web by users as a front-end
b. parallel processing
c. Microsoft Windows
d. a larger IT staff
b. parallel processing
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
All of the following about data mining are true EXCEPT
a. the process aspect means that data mining should be a one-step process to results
b. the novel aspect means that previously unknown patterns are discovered
c. the potentially useful aspect means that results should lead to some business benefit
d. the valid aspect means that the discovered patterns should hold true on new data
a. the process aspect means the data mining should be a one-step process to results