Deck 6: Business Intelligence and Analytics

Question 1

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.

Answer 1

False

Question 2

Some insurance companies can detect fraudulant claims using BI software .

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

Data scientists do not need much business domain knowledge.

Question 8

In the regression line Y = a+ bX + e, a is the slope of the regression line.

Question 9

A vehicle routing optimization system helps in maximizing the number of drivers being assigned.

Question 10

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

Question 11

The data for BI (business intelligence) comes from many sources .

Question 12

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.

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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.

Question 19

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

Question 20

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

Question 21

Which of the following is NOT a key capability of BI tools?

A)​ability to create graphs of results
B)ability to zoom in to view various levels of details
C) ​ability to provide advice to the user on which model best suits the data
D) ability to ​link disparate data to gain various levels of insights

Question 22

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

A)​Understand the data
B)​Prepare the data
C) ​Clarify business goals and design a project plan
D) ​Create and apply analytical modeling techniques

Question 23

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

Question 24

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

A)​Evaluation
B)​Modeling
C) ​Business understanding
D) ​Deployment

Question 25

What determines the size of words in a word cloud?

A)​length of the word or phrase
B)​difficulty in pronouncing the word or phrase
C) ​whether the word is a pronoun
D) ​frequency of occurrence of the word in source documents

Question 26

Suppose you are good in math and statistics. Adding programming to your skill-set will be necessary if you want to be a data scientist.

Question 27

Business analytics can be used only for forecasting future business results.

Question 28

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

A)​correlated
B)​summarized
C) ​regressed
D) ​drilled into

Question 29

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

A)Sales revenue
B)​Month name
C) Product category
D) ​City name

Question 30

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

A)​the spreadsheet's 'what-if' capability
B)the graphing features of spreadsheet software
C) the reporting feature of a BI tool
D) ​a data visualization tool

Question 31

Online analytical processing is another name for enterprise application.

Question 32

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

A)​clarify business goals for the data mining project
B)​select a subset of data to be used and prepare it
C) ​assess if the model achieves business goals
D) ​apply selected modeling techniques

Question 33

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?

A)​Automate data entry at the factories for reduction in error rates
B)​Implement BI tools in each factory separately
C) Create a data warehouse so that data from the factories are combined for BI analysis
D) ​None of these answers

Question 34

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

Question 35

From which vendor is the BI product Business Objects available?

A)​IBM
B)SAP
C) ​​Google
D) ​Microsoft

Question 36

One of the goals of business intelligence is to _________.

A)​present the results in an easy to understand manner
B)educate the users about business statistics
C) ensure the transaction data is properly stored
D) use the most sophisticated techniques

Question 37

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

A)Easy access to a degree in Statistics
B)​​Self-service analytics
C) ​Seeking expert opinions
D) ​Outsourcing BI tasks

Question 38

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

Question 39

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

A)​You need good data management practices
B)There must be strong commitment from the management
C) You need good data governance practices
D) ​You need creative data scientists

Question 40

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

Question 41

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

A)​Data governance
B)​Data mining
C) ​Linear regression
D) ​Drill down

Question 42

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

A)​Computer science
B)Mathematics
C) Statistics
D) English

Question 43

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

A)​Data visualization
B)​Drill-down analysis
C) Online transaction processing
D) ​Data mining

Question 44

The goal of business intelligence is to _____.

A)​provide access to novel tools to the users
B)​reduce the cost of data processing
C) ​support and improve decision making
D) ​improve employee morale

Question 45

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?

A)​Word cloud tool
B)​Querying tool
C) Reporting tool
D) Data visualization tool

Question 46

The presentation of data in a pictorial or graphical format is called _____.

Question 47

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

A)​strong business acumen
B)​a deep understanding of analytics
C) ​a healthy appreciation of the limitations of their data
D) business leadership skills

Question 48

The graphical representation that summarizes the steps a consumer takes in making the decision to buy your product and become a customer is called _____.

A)​a word cloud
B)a conversion funnel
C) ​a scatter diagram
D) a pivot chart

Question 49

Which of the following is NOT a core process associated with data management?

A)​process for obtaining data
B)process for certifying it fit for use
C) process for gathering BI requirements
D) ​process for storage

Question 50

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

A)​100,000 or less
B)​100,000 to 200,000
C) 200,000 to 500,000
D) more than 500,000

Question 51

Which of the following is NOT true about linear regression?

A)​both of the variables must be quantitative variables
B)​the line minimizes the sum of the squared errors of prediction
C) ​the technique implies causality between the independent and the dependent variables
D) ​consists of finding the best-fitting straight line through a set of observations

Question 52

The coefficient of determination, r squared, is ____.

A)​the same as the error term in a linear regression
B)​a number that indicates how well data fits the statistical model
C) a number that must be close to zero to be useful
D) ​the same as the slope of the linear regression

Question 53

Which of the following is a potential disadvantage with self-service BI?

A)​Accelerates and improves decision making.
B)​Can lead to over spending on unapproved data sources and business analytics tools.
C) ​Encourages nontechnical end users to make decisions based on facts and analyses rather than intuition.
D) ​Gets valuable data into the hands of the people who need it the most-end users.

Question 54

Suppose the r² (r squared) value for the linear regression is 0.85. You can state that the linear regression accounts for ____ percent of the variation in the dependent variable.

Question 55

Metrics that track progress in executing strategies to attain organizational objectives are also known as _______ (KPIs).

Question 56

Which of the following is NOT a commonly used BI tool?

A)​​data visualization
B)linear regression
C) ​drill-down analysis
D) ​automated customer service

Question 57

Which of the following is NOT considered business intelligence practice?

A)​Data extraction
B)Visualization
C) ​Analysis
D) Transaction processing

Question 58

Which of the following is IBM's BI product?

A)​Power BI
B)​Business objects
C) Cognos
D) ​Hyperion

Question 59

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

A)​direction
B)measure
C) time frame
D) ​format

Question 60

Which of these analysis methods describes neural computing?

A)a ​specialized set of algorithms sorts through data and forms statistical rules about relationships among the items
B)​historical data is examined for patterns that are then used to make predictions
C) ​historical if-then-else cases are used to recognize patterns
D) ​a mathematical procedure to predict the value of a dependent variable based on a single independent variable

Question 61

Often times, information on dashboards are color coded, using the color ____ for problem areas.

Question 62

If you wish to present traffic trends on your company's Website, a _____ format is preferable to tabular formats.

Question 63

A ___________ is an individual who combines strong business acumen, a deep understanding of analytics, and a healthy appreciation of the limitations of their data, tools, and techniques to deliver real improvements in decision making.

Question 64

____ is the most popular spreadsheet program .

Question 65

Without real time data, generating reports will take ____ time than with real time data.

Question 66

Data ______ tools can take raw data and immediately provide a rich visual image.

Question 67

Similar to what you find in a car, a business _____ provides rapid access to information, in an easy-to-interpret and concise manner, which helps organizations run more effectively and efficiently.

Question 68

____ is the first phase of the cross-industry process for data mining (CRIPS-DM).

Question 69

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

Question 70

Suppose you wish to predict the value of shopping cart contents (order total), based on the amount of time the customer spent at the online store site. In a linear regression model, you will use order total as the ____ variable .

Question 71

The goal of the data scientist is to ____ valuable insights that will influence organizational decisions.

Question 72

______ is the the interactive examination of high-level summary data in increasing detail to gain insight into certain elements.

Question 73

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

Question 74

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

Question 75

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

Question 76

_______ tools can present data in an easy-to-understand fashion via formatted data, graphs, and charts.

Question 77

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

Question 78

Data _____ is the core component of data management; it defines the roles, responsibilities, and processes for ensuring that data can be trusted.

Question 79

Petroleum companies use BI tools that advise the refineries and oil traders on the mix of products to produce, buy, and sell in order to ______ profit .

Question 80

Business intelligence includes technologies for extraction, integration and visualization of ____ .