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