Chapter 6 - Data Analytical Tools

Question 1

List the 3 reasons R language is so popular?

Answer 1

1) it’s open source
2) the machine learning packages are free on CRAN, the R code repository
3) the tidyverse data-analyis packages simplify the R language make it easier for data analysts

Question 2

Python has a specialist tool specifically for data analysts to use. What is it called and what kind of data structures does it work with?

Answer 2

PANDAS = Python Data Analysis Library.
It’s specifically for structured/tabular data

Question 3

Which of the following commands are Data Definition Language and which are Data Manipulation Language

CREATE
UPDATE
ALTER
DELETE
DROP
SELECT
INSERT

Answer 3

CREATE - DDL
UPDATE - DML
ALTER - DDL
DELETE - DML
DROP - DDL
SELECT - DML
INSERT - DML

Question 4

Which 3 DDL commands does the book mention?

Answer 4

CREATE
ALTER
DROP

Question 5

Which 2 ways can tools interact with databases using SQL?

Answer 5

1) provide a GUI to either reconfigure the database or retrieve data from the database
2) directly via computer software.

Question 6

Which statistics packages created in the 60’s and 70’s are still widely in use today?

Answer 6

IBM SPSS
SAS

SPSS Statistics is a different product to SPSS Modeller!

Question 7

Which are two statistics packages (or statistical analysis software) aren’t used as much today?

Answer 7

Minitab and Stata

Question 8

if you saw a machine learning tool interface that showed decision trees in the form of flowcharts, which tool would you be looking at?

Answer 8

IBM SPSS Modeler

Question 9

Which machine learning tool offer pre-built analytics templates for common business scenarios and offers access to hundreds of different algorithms?

Answer 9

Rapid Miner

Question 10

Farrow wants to perform analysis of data but it requires a bespoke solution, what out of the below methods should they go with?

Spreadsheets
IBM SPSS
Use Python or R?

Answer 10

Using Python or R will allow Farrow to build an analysis package that suites their specific needs

Question 11

List the analytics suites discussed in the book

Answer 11

AWS quicksight
business Objects
Domo
Datorama
IBM Cognos
Microstrategy
Power BI
Qlik
Tableau

Question 12

Which analytics suite is specifically designed for Sales and Marketing functions of the business?

Answer 12

Datorama

Question 13

Which analytics suite from SAP allows companies to integrate it with other applications?

Answer 13

BusinessObjects

Question 14

Raheela needs to create a bespoke analytics but she’s not very familiar with programming, which solution should she choose?

Answer 14

R

Question 15

List the SQL Data Manipulation Commands

Answer 15

UPDATE
SELECT
INSERT
DELETE

Question 16

What’s the key benefit machine learning software or packages bring to analysts of today?

Answer 16

They don’t require analysts to know programming languages or write their own scripts/algorithms

Question 17

What’s considered the most popular data visualization tool?

Answer 17

Tableau

Question 18

Which data visualization tool enables easy ingestion of data from a wide variety of sources?

Answer 18

Tableau

Question 19

Qlik X is the company’s original analytics platform and Qlik X is a more advanced platform

Answer 19

Qlik VIEW is the company’s original analytics platform and Qlik SENSE is a more advanced platform

Question 20

Regarding IBM Cognos, what’s the difference between the two modules below?
Query Studio
Report Studio

Answer 20

Query Studio provides access to data querying and basic reporting
Report Studio is for complex reporting needs

Question 21

Which ‘Studio’ module in IBM Cognos enables advanced modelling and analytics for large data sets?

Answer 21

Analysis Studio

Question 22

If you’re a business executive and want to create a scorecard to analyse key metrics across the business, which module would you use in IBM Cognos?

Answer 22

Metric Studio

Question 23

Which Power BI module allows developers to create paginated reports that are designed for printing and email?

Answer 23

Power BI Report Builder

think building reports to publish

Question 24

An organization wants to host it’s own Power BI capability, what offering would they purchase?

Answer 24

Power BI Report Server

Question 25

List the analytics suites begging with A and B

Answer 25

AWS Quicksite
Business Objects (SAP)

Question 26

List the analytics suites beginning with D

Answer 26

Domo
Datarama

Question 27

List the analytics suites beginning with C and P

Answer 27

Cognos
Power BI

Question 28

List the analytics suites beginning with Q and T

Answer 28

Qlik
Tableau

Question 29

Power BI Report Builder has a key function to use specifically when printing or emailing reports, what is it?

Answer 29

Pagination

Question 30

Which 2 products in the book are built especially for machine learning capabilities?

Answer 30

IBM SPSS Modeller
Rapid Miner

Question 31

Which name is given to a group of packages within R that is specifically design for data manipulation, analysis and visualization?

Answer 31

Tidy-verse

Question 32

Machine learning and the tidy-verse analytics packages are stored where for R?

Answer 32

in CRAN (Comprehensive R Archive Network)

Question 33

these provide an advanced statistical environment via GUI or bult-in scripting language and are generally the domain of professional statisticians

Answer 33

Statistics packages