Data Analytics Tools

Mod 6 Knowledge Check

Which one of the following statements about spreadsheets is incorrect?

Spreadsheet software provides powerful machine learning capabilities.

Which one of the following commands would not be considered part of the Data Manipulation Language (DML)?

CREATE

Glen would like to modify the structure of an existing database table. What SQL command would best meet her needs?

ALTER

Which one of the following is not a standard way for a relational database to receive commands?

Natural language query written by a customer

What Python library provides data analysts with access to tools that allow them to structure data better?

pandas

Paul accidentally created a database table and would like to remove the entire table from the database. What Structured Query Language command would best meet his needs?

DROP

Ann is using the Structured Query Language to retrieve information stored in a relational database table. What DML command should she use to specify the records she would like to retrieve?

SELECT

Ricky is a data analyst looking to develop his own applications to simplify some reporting and modeling tasks. He does not have experience in programming and would like to use a language that will meet his analytics needs but be easy to learn. What language would best meet his needs?

R

Kevin is helping prepare a computer for a professional statistician who will be performing some quality control analyses for his organization. Which one of the following tools is most likely to meet the statistician’s needs?

SPSS

Kelly is looking for a statistical analysis package for use by her organization’s statisticians. Which one of the following tools would be least suitable for this purpose?

SPSS Modeler

Vincent is looking for a software package that will allow his team to create machine learning workflows by visually designing them. Which one of the following approaches would best meet his needs?

Using RapidMiner

Amanda works for an organization that uses the Cognos analytics suite. She would like to set up automated alerting that notifies leaders when one of the organization’s stores experiences an out-of-stock situation. What component of Cognos would best meet her needs?

Event Studio

Wanda is selecting a tool to present analytics reports to business leaders. Which one of the following tools is most likely to meet her needs?

Power BI

Tyler works for a sales organization that uses the Salesforce customer relationship management platform. He would like to produce some sales analytics quickly and needs a tool with the fastest integration time. What tool should he select?

Datorama

Which one of the following is an enterprise reporting tool available from SAP?

BusinessObjects

Bob is exploring analytics tools available from Qlik and would like to use a cost-effective tool that will get him up and running quickly. What tool would best meet his needs?

QlikView

Xavier is a new data analyst who wants to learn a data visualization package. He would like to use software that specializes in data visualization, integrates with a large number of data sources, and is widely used across organizations. What tool would best meet his needs?

Tableau

Lisa is an IT technician with a large organization that uses the Power BI analytics suite. A new data analyst is joining the organization and would like to have a tool installed on their laptop to create paginated reports. What tool would best meet this need?

Power BI Report Builder

Simone works for an organization that uses the Cognos analytics suite. What component of the suite could she use to best create scorecards for business leaders?

Metric Studio

Carla works for an organization that relies heavily on the machine learning and analytics tools offered by Amazon Web Services. She would like to select a dashboarding tool that will easily integrate with those other tools. What product would best meet her needs?

QuickSight