Business Analytics Exam #1

Cole Nussbuamer Knaflic makes the point that we should be presenting data from our

explanatory analyses

In order for IoT devices to properly work, which of the following components is NOT necessary?

reactor

What is return on investment?

revenue multiplied by the contribution margin divided by spending

Which of the following is not necessarily a part of analyzing metrics?

running statistical analyses

Which is NOT a primary way to utilize analytics in the cloud?

security

Which of the following is defined as an entity that can observe occurrences or changes in the IoT environment?

sensor

Which of the following is not a dimension of the Internet of Things?

sensor

Which of the following is NOT a strategy espoused by Cole Nussbaumer Knaflic for gaining acceptance?

Make it clear that you know what is best for the audience

Which of the following is a competitor of Google Analytics?

Matomo

Which of the following cloud service providers has the highest market share?

Microsoft Azure

Which of the following is a/are non-commercial open-source database management systems?

MongoDB only

Which of the following is a security provider for Internet of Things mentioned in the textbook?

Norton

Programming tool that was not originally designed for data analysis but has since become useful for it

Python

Which visualization tool is open source?

Python

Programming tool designed specifically for data analysis

R

One of the primary programming tools that makes it easier to work with data using the programming language R

RStudio

Which of the following is not a programming language important for business analytics?

RStudio

One of the primary programming tools that makes it easier to work with data using the programming language Python

Rodeo

Which of the following is NOT a commercial data visualization tool?

Tablet

When working on your visualization's aesthetics, which of the following is NOT a factor you should consider, according to Cole Nussbaumer Knaflic?

Use the company's colors whenever possible

Which of the following is used to restrict rows is SQL?

WHERE

Which is not an AWS client?

Walmart

Which of the following is NOT a question you should ask yourself when assessing the context?

What data do we need to hide to strengthen our case?

What is a primary key in a relational database?

a column that uniquely identifies a row in the table

What is a programming language?

a formal set of instructions that can be used to produce various kinds of output

Which of the following is RStudio?

a programming tool

What is a programming tool?

a software package that allows the execution of programming code

Which of the following is defined as the conversion of electrical inputs into physical actions?

actuator

What does a query do?

allows you to ask a question and answer the said question through information pulled from the database

What is the definition of Internet of Things?

an extension of the internet to device sensors affording simple objects a high degree of computing and analytical capabilities

What is the most used form of artificial intelligence?

applied AI

What are the two categories of artificial intelligence?

applied and general

Which of these refers to systems that are designated to work on specific tasks?

applied intelligence

Which is a business case topic from the Internet of Things chapter?

autonomous cars

What type of Google Analytics report can give information about how a page is performing

behavior report

What is the name of an artificial intelligence application in use today for business?

Albert

Which of the following is an Amazon Web Services product?

Amazon Redshift

Which is not an AWS service helpful for business analytics?

Analytiks

Which of the following is NOT an example of an affordance in Cole Nussbaumer Knaflic's book?

Apple i-phones

What is the difference between machine learning and deep learning?

Deep learning uses neural networks to mimic the human brain and machine learning does not.

According to the book, what is the most accessible tool for creating, analyzing, and presenting data visually?

Excel

Power Map is which of the following?

Excel's geographic mapping tool

Which is NOT a cloud service advantage?

proximity

Which of the following is a graph that displays information as a bar chart illustrating a project schedule?

Gantt chart

Which of the following does a relational database not contain?

ID graphs

Which of the following is an example of a non-programming tool for data analytics?

JMP

Which of the following is best used for time series data and should NEVER be used for categorical data?

Line

Which of the following is likely to be included in Google Analytics Behavior Overview reporting?

brands

Which of the following graphs displays information as a scatter plot with an additional dimension of quantitative data represented by changing the size of the dot?

bubble chart

Which of the following is likely to be included in Google Analytics Acquisition Overview reporting?

channels

Which of the following is likely to be included in Google Analytics Audience reporting?

channels

Which algorithm does not use supervised learning?

cluster analysis

Hadoop is an open-source software framework that stores and processes large amounts of data using ________.

commodity cluster hardware

Web services offer broad IT platforms including all but ________.

database-as-a-service

Which step requires businesses to study web traffic patterns and website optimization methods in order to drive more conversions?

design

Which is an advantage of R?

designed for data analytics

What does open source mean?

developed by and for the community and available for free

Which of the following measures the company's ability to leverage competitive advantage and product or service progress?

development metrics

Which one of the following is not measured by innovation metrics?

development speed

Which of the following is not an industry mentioned in the chapter as having made an impressive impact by the Internet of Things?

education

In our reading Cole Nussbaumer Knaflic refers to a the book Universal Principles of Designwhich offers guidelines for how to use preattentive attributes to create design affordances. However, Cole Nussbaumer Knaflic does not agree with all of their recommendations. Which of the following is/are recommended by Lidwell, Holden, and Butler but NOT by Cole Nussbaumer Knaflic?

flashing, blinking

When preparing for data visualization, one should start by doing which of the following?

getting to know the audience

Which of the following is likely to be included in Google Analytics Conversions reporting?

goals

Food4Less is a known brand, but many don't see it as a viable option for food that is available at Trader Joes. What does this infer about the brand metrics for Food4Less?

good depth but less breadth

Which type of non-relational database is best for the data structure of social media websites?

graph database

Which is not one of AWS's competitors?

iCloud

Which join uses records that have matching values in both tables?

inner join

Which is an advantage of Python?

integrates well with programming activities outside data analytics

Which of the following is FALSE about business analytics metrics?

it is easy to track the important metrics

What is one function that a relational database can do that a non-relational database cannot?

join queries

Which type of non-relational database is best for the simplest data modeling?

key-value stores

Which of the following are ways you can order your story according to Cole Nussbaumer Knaflic?

lead with the ending, chronologically

Which of the following includes matched records from the right table and all records from the left table?

left join

Radar charts are graphs that display information as a ______ or ______, with many axes representing more than two variables in the data.

line chart [or] area chart

Which of the following is best used for time series data?

line graph

Which application of artificial intelligence allows systems to automatically learn and improve without being programmed to do so?

machine learning

Which is not an Excel function important to business analytics?

mean

Google Analytics collects all of the following information about website users EXCEPT:

name

A software package that analyzes data without the use of programming code

non-programming tool Excel SPSS JMP

What is an IoT device?

object with a sensor that can transmit data to another object

Suppose there are two tables: A and B. What would the following code output? SELECT * from A INNER JOIN B on A.orderid = B.orderid;

only the records from both tables A and B where tables A and B have the same orderid

The Hadoop ecosystem encompasses Hadoop's various tools and projects, which were designed to promote

optimal usability

Which of the following is not a type of join?

partial inner join

What is the most attractive feature of cloud services?

pay-as-you-go pricing

A collection of statements written in a particular programming language

programming code

Which is NOT a type of report in Google Analytics?

progress

Return on investment is what type of business analytics metric?

strategic

Which type of metrics is used to fulfill important operational and financial functions in an organization?

strategic metrics

Brands use which type of metrics for campaign performance?

support metrics

One reason companies may not adopt cloud services is ________.

that there's a steep learning curve for employees

Which is most important to the Internet of Things?

the cloud

Big data are useless to a company unless

the company has a place to analyze and easily access the information

Suppose there are two tables: A and B. What would the following code output? SELECT * from A LEFT JOIN B on A.orderid = B.orderid;

the complete set of records from table A, along with the matching records (depending on the availability) from table B where tables A and B have the same orderid

Suppose there are two tables: A and B. What would the following code output? SELECT * from A RIGHT JOIN B on A.orderid = B.orderid;

the complete set of records from table B, along with the matching records (depending on the availability) from table A where tables A and B have the same orderid

According to Robert McKee, these are the two ways to persuade people

through story, conventional rhetoric

What is the function COUNT () used for?

to return the number of rows that match a specified criteria

What is the role of a relational database?

to store large amounts of data and create easy access to important information

What is NOT an example of a dimension in Google Analytics?

user

What is an integer?

variable that contains numbers without decimal points

What is NOT included in an infographic?

video