Chapter 9
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