Chapter 9

Ace your homework & exams now with Quizwiz!

​The coefficient of determination, r squared, is ____.

a number that indicates how well data fits the statistical model

What is the projected shortage of data scientists in the USA, according to a McKinsey & Co. report?

100,000 to 200,000

​What is the projected shortage of data scientists in the USA, according to a McKinsey & Co. report?

100,000 to 200,000

From which vendor is the BI product Business Objects available?

SAP

​From which vendor is the BI product Business Objects available?

SAP

Which of the following will be a 'fact' measure in a data cube used at a chain retail business?

Sales revenue

With the help of ____ analytics tools, users work independently to access data and perform their own analyses.

Self Service

_________ encourages nontechnical end users to make decisions based on facts and analyses rather than intuition.

Self-service analytics

You are to advise XYZ so that their BI efforts are fruitful. Which among the following is the most crucial advice of all?

There must be strong commitment from the management

Which of the following is NOT considered business intelligence practice?​ ​Data extraction Transaction processing ​Analysis Visualization

Transaction processing

If you wish to have a visual depiction of relative frequencies of words in a document, a word cloud would be an appropriate option​.

True

Power Pivot and Power Query are components of Microsoft's Power BI tool​.

True

T/F: Data governance involves identifying people who are responsible for fixing and preventing issues with data.

True

T/F: During drill-down, you go from high-level summary data to detailed levels of data.

True

T/F: For an organization to get real value from its BI efforts, it must have a solid data management program.

True

T/F: Some insurance companies can detect fraudulant claims using BI software​.

True

T/F: To solve the product mix problem that will maximize the profits, you can use Excel's Solver add-in.

True

The data for BI (business intelligence) comes from many source

True

The data for BI (business intelligence) comes from many sources​. T or F

True

​Data governance involves identifying people who are responsible for fixing and preventing issues with data.

True

​Data mining is used to explore large amounts of data, looking for hidden patterns that can be used to predict future trends and behaviors. Tor F

True

​In OLAP data cubes, you would likely find numeric measures categorized by time and geography.

True

​Linear regression is useful when you wish to predict the value of a quantitative variable based on a another quantitative variable. T or F

True

​Suppose you are viewing a database of your monthly expenses, categorized under broad headings such as food, entertainment and accommodation. If you have drill down ability, you are able to view details under each category.

True

​Suppose you are viewing a database of your monthly expenses, categorized under broad headings such as food, entertainment and accommodation. If you have drill down ability, you are able to view details under each category. T or F

True

T/F: A vehicle routing optimization system helps in maximizing the number of drivers being assigned.

False

T/F: Business analytics can be used only for forecasting future business results.

False

T/F: Creative data scientists - a key component of BI efforts in an organization - are people who are primarily focused on coming up with novel ways of analyzing data.

False

​Grocery stores can use BI tools to better ______ the demands, so that stock outs are reduced.

Compute

Suppose your employer has four manufacturing units, each with its own data operations. They are considering using BI tools. Which of the following is a valid recommendation regarding the BI initiative?

Create a data warehouse so that data from the factories are combined for BI analysis

​Suppose your employer has four manufacturing units, each with its own data operations. They are considering using BI tools. Which of the following is a valid recommendation regarding the BI initiative?

Create a data warehouse so that data from the factories are combined for BI analysis

Suppose you have access to quantitative data on populations by ZIP code and crime rates. You wish to determine if there is a relationship between the two variables and display the results in a graph. Which BI tool will be most useful?​

Data visualization tool

____ is the last phase of the six-phase CRISP-DM method.

Deployment

Mastery over which subject is NOT required for being a data scientist?

English

A conversion funnel is a visual depiction of a set of words that have been grouped together because of the frequency of their occurrence.

False

Data cubes can be created on an ad hoc basis. There is no need to create them ahead of time.

False

Excel's scenario manager can be used to solve optimization-type problems​.

False

In linear regression, you are to find a line that best fits the data. Sometimes the line may be curved.

False

T/F: Data scientists do not need much business domain knowledge.​

False

T/F: Online analytical processing is another name for enterprise application.

False

Users still need help from the IT function of the organization to create customer reports using modern reporting tools.​ T or F

False

Users still need help from the IT function of the organization to create customer reports using modern reporting tools.​ Tor F

False

​A conversion funnel is a visual depiction of a set of words that have been grouped together because of the frequency of their occurrence.

False

​A marketing manager who does not have deep knowledge of information systems or data science, will NOT be able to use BI tools

False

​In the regression line Y = a+ bX + e, Y is the value of the independent variable.

False

​In the regression line Y = a+ bX + e, Y is the value of the independent variable. T or F

False

​T/F: A marketing manager who does not have deep knowledge of information systems or data science, will NOT be able to use BI tools

False

​T/F: Suppose your university administrators wish to summarize student GPA on Major, Gender, High School, Home City and ZIP Code dimensions. This cannot be done with one data cube.

False

Which of the following is NOT a key capability of BI tools? ​ability to provide advice to the user on which model best suits the data ​ability to create graphs of results ability to ​link disparate data to gain various levels of insights ability to zoom in to view various levels of details

​ability to provide advice to the user on which model best suits the data

​During modeling of the CRISP-DM method, we would ______.

​apply selected modeling techniques

​Which of the following is NOT a commonly used BI tool? ​drill-down analysis ​​data visualization linear regression ​automated customer service

​automated customer service

What determines the size of words in a word cloud? ​difficulty in pronouncing the word or phrase ​whether the word is a pronoun ​frequency of occurrence of the word in source documents ​length of the word or phrase

​frequency of occurrence of the word in source documents

Which of these analysis methods describes neural computing?

​historical data is examined for patterns that are then used to make predictions

Which of the following is NOT true about linear regression?

​the technique implies causality between the independent and the dependent variables

_________ encourages nontechnical end users to make decisions based on facts and analyses rather than intuition.​

​​Self-service analytics

​_____ is used to explore large amounts of data for hidden patterns to predict future trends.

Data mining

​Which of the following is NOT considered business intelligence practice?

Transaction processing

Suppose management wishes to start a BI project at your new job. Which of following will you recommend as the first step?

Clarify business goals and design a project plan

​For BI to be successful, the _____ in the organization must be strongly committed to data-driven decision making.

Management

Which of the following is NOT considered a BI and analytics tool?

Online transaction processing

Which of the following is NOT considered a BI and analytics tool?​ ​Data mining ​Data visualization ​Drill-down analysis Online transaction processing

Online transaction processing

Which of the following is NOT considered a BI and analytics tool?​ ​Drill-down analysis ​Data visualization ​Data mining Online transaction processing

Online transaction processing

Which of the following is NOT a characteristic of a data scientist?

business leadership skills

​Which of the following is NOT a characteristic of a data scientist?

business leadership skills

T/F: Data cubes can be created on an ad hoc basis. There is no need to create them ahead of time.

false

Which of the following is NOT a component of a KPI (key performance indicator)?

format

​Which of the following is NOT a component of a KPI (key performance indicator)?

format

Business users access BI applications via the Web or through organizational ______ and extranets​.

intranets

One of the goals of business intelligence is to _________.

present the results in an easy to understand manner

Data within the data cube has been ______ by specific dimensional values.

summarized

​Data within the data cube has been ______ by specific dimensional values.

summarized

The goal of business intelligence is to _____. ​provide access to novel tools to the users ​improve employee morale ​support and improve decision making ​reduce the cost of data processing

support and improve decision making

To analzye various alternative scenarios, a manager would use _______.

the spreadsheet's 'what-if' capability

​Which of the following is NOT true about linear regression?

the technique implies causality between the independent and the dependent variables


Related study sets

HIUS 3490 From Motown to Hip-Hop Exam #1, Key Terms

View Set

Imperialism in China (European Spheres of Influence)

View Set

Maternal Child Nursing Rasmussen Mod 2

View Set

毗斯迦山旧约第5部分—先知书概览

View Set

Chapter 21: Macroeconomics: The Big Picture

View Set