DSCI 4330 Exam 1 Complete Questions And Correct Detailed Answers.

BI represents a bold new paradigm in which the company's business strategy must be aligned to its business intelligence analysis initiatives. T/F - correct answer FALSE The very design that makes an OLTP system efficient for transaction processing makes it inefficient for - correct answer end-user ad hoc reports, queries, and analysis. In the Opening Vignette on Sports Analytics, what type of modeling was used to predict offensive tactics? - correct answer heat maps Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically - correct answer a distinct system that provides storage for data that will be made use of in analysis. Due to industry consolidation, the analytics ecosystem consists of only a handful of players across several functional areas. T/F - correct answer FALSE The need for more versatile reporting than what was available in 1980s era ERP systems led to the development of what type of system? - correct answer executive information systems Relational databases began to be used in the - correct answer 1980s The use of dashboards and data visualizations is seldom effective in identifying issues in organizations, as demonstrated by the Silvaris Corporation Case Study. T/F - correct answer FALSE Traditional BI systems use a large volume of static data that has been extracted, cleansed, and loaded into a data warehouse to produce reports and analyses. T/F - correct answer TRUE Which of the following is NOT an example of transaction processing? - correct answer sales report This plot is a graphical illustration of several descriptive statistics about a given data set. - correct answer box-and-whiskers plot Contextual metadata for a dashboard includes all the following EXCEPT - correct answer which operating system is running the dashboard server software. This measure of dispersion is calculated by simply taking the square root of the variations. - correct answer standard deviation Visualization differs from traditional charts and graphs in complexity of data sets and use of multiple dimensions and measures. T/F - correct answer TRUE Descriptive statistics is all about describing the sample data on hand. - correct answer TRUE Data accessibility means that the data are easily and readily obtainable. T/F - correct answer TRUE 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. T/F - correct answer FALSE Which kind of chart is described as an enhanced version of a scatter plot? - correct answer bubble chart This measure of central tendency is the sum of all the values/observations divided by the number of observations in the data set. - correct answer arithmetic mean ey performance indicators (KPIs) are metrics typically used to measure - correct answer internal results The BPM development cycle is essentially a one-shot process where the requirement is to get it right the first time. - correct answer FALSE One way an operational data store differs from a data warehouse is the recency of their data. - correct answer TRUE In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected? - correct answer cleanse Why is a performance management system superior to a performance measurement system? - correct answer because measurement alone has little use without action What is Six Sigma? - correct answer a methodology aimed at reducing the number of defects in a business process Moving the data into a data warehouse is usually the easiest part of its creation. T/F - correct answer FALSE Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates? - correct answer independent data marts All of the following are benefits of hosted data warehouses EXCEPT - correct answer greater control of data With key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily true. T/F - correct answer TRUE Oper marts are created when operational data needs to be analyzed - correct answer multidimensionally List some capabilities of information systems that can facilitate managerial decision making. - correct answer Better communication and information capture, better storage and recall of data, and vastly improved analytical models that can be more voluminous or more precise. How can a computer help overcome the cognitive limits of humans? - correct answer being able to store huge amounts of data, being able to run extensive numbers of scenarios and analyses, and the ability to spot trends in vast datasets or models. List three of the terms that have been predecessors of analytics. - correct answer Data Support Systems (DSS) Operations Research (OR) models Expert Systems (ES). Define BI. - correct answer Umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies. Its major objective is to enable interactive access (sometimes in real time) to data, enable manipulation of these data, and provide business managers and analysts the ability to conduct appropriate analysis. List