Ch1 Data Analytics- Questions and
Answers
Which Microsoft Track tool is most appropriate for working with small data sets? Excel
Which is the best Tableau Track tool for advanced visualizations? Tableau Desktop
True or false: Data analytics involves only the analysis of unstructured data. false
The real value inherent in data comes from Blank______, discovering the various buying
patterns of customers, investigating anomalies that were not predicted in firm operations, and
forecasting future demand and supply. data analytics
Co-occurrence Grouping an attempt to discover associations between individuals based on
transactions involving them
As part of mastering the data, data analysts perform data Blank______ to reduce data
redundancy and improve data integrity. normalization
Data Validation & completeness to provide a sense of reliability of the data
ETL extraction, transformation, & loading data (master the data)
, Data Preparation & scrubbing converting information from surveys or other data sources
so it can be used in statistical analysis; the process of going through a database and eliminating
dirty data
Classification Assignment of objects or people to categories on the basis of shared
characteristics.
Regression predict a specific dependent variable value based on independent variable
inputs
Similarity matching identifying like-individuals based on what you know about them
Clustering organizing items into related groups during recall from long-term memory;
divide individuals into groups in a useful way (find underlying drivers of similar data elements to
group them together)
Profiling characterize the typical behavior of an individual/group by generating summary
statistics like mean/median/max... about the data
Link prediction predicting connections b/w 2 data items
reduces the amount of information that needs to be considered to focus on the most important
data reducing
Answers
Which Microsoft Track tool is most appropriate for working with small data sets? Excel
Which is the best Tableau Track tool for advanced visualizations? Tableau Desktop
True or false: Data analytics involves only the analysis of unstructured data. false
The real value inherent in data comes from Blank______, discovering the various buying
patterns of customers, investigating anomalies that were not predicted in firm operations, and
forecasting future demand and supply. data analytics
Co-occurrence Grouping an attempt to discover associations between individuals based on
transactions involving them
As part of mastering the data, data analysts perform data Blank______ to reduce data
redundancy and improve data integrity. normalization
Data Validation & completeness to provide a sense of reliability of the data
ETL extraction, transformation, & loading data (master the data)
, Data Preparation & scrubbing converting information from surveys or other data sources
so it can be used in statistical analysis; the process of going through a database and eliminating
dirty data
Classification Assignment of objects or people to categories on the basis of shared
characteristics.
Regression predict a specific dependent variable value based on independent variable
inputs
Similarity matching identifying like-individuals based on what you know about them
Clustering organizing items into related groups during recall from long-term memory;
divide individuals into groups in a useful way (find underlying drivers of similar data elements to
group them together)
Profiling characterize the typical behavior of an individual/group by generating summary
statistics like mean/median/max... about the data
Link prediction predicting connections b/w 2 data items
reduces the amount of information that needs to be considered to focus on the most important
data reducing
