BUSINESS DATA ANALYTICS FINAL EXAM
REVIEW QUESTIONS; 1005 SOLVED
What is DATA - ANS-Everything!
Data wrangling - ANS-the process of retrieving, cleansing, integrating, transforming, and enriching data
to support analytics
Database management - ANS-a process that na organization uses to acquire, organize, store,
manipulate, and distribute data
Database - ANS-a collection of data organized to enable easy retrieval, management, and distribution of
data
relational database - ANS-two-dimension grid/table; like excel
Database Management System (DBMS) - ANS-a software application for defining, manipulation, and
managing data: SQL, Oracle
What is the most popular query language used today? - ANS-Structured query language (SQL)
Two types of data - ANS-Structured: row and column, numerical
Unstructured: textual, media
Categorical Data (think of columns in Tableau) - ANS-Label or names, qualitative, changed into #
example: sex, marital status, gender
Numerical Data - ANS-represents meaningful numbers, quantitative
example: # of kids
Nominal Data - ANS-categorical data, least sophisticated
example: male/female
Ordinal Data - ANS-categorical, label or names, but can be ranked
example: 1-5 star review
Interval Data - ANS-numerical, difference has meaning (zero is usually arbitrary)
example: temperature
Ratio Data - ANS-Numerical, most sophisticated, zero has true point, ratios are meaningful
example: profit
REVIEW QUESTIONS; 1005 SOLVED
What is DATA - ANS-Everything!
Data wrangling - ANS-the process of retrieving, cleansing, integrating, transforming, and enriching data
to support analytics
Database management - ANS-a process that na organization uses to acquire, organize, store,
manipulate, and distribute data
Database - ANS-a collection of data organized to enable easy retrieval, management, and distribution of
data
relational database - ANS-two-dimension grid/table; like excel
Database Management System (DBMS) - ANS-a software application for defining, manipulation, and
managing data: SQL, Oracle
What is the most popular query language used today? - ANS-Structured query language (SQL)
Two types of data - ANS-Structured: row and column, numerical
Unstructured: textual, media
Categorical Data (think of columns in Tableau) - ANS-Label or names, qualitative, changed into #
example: sex, marital status, gender
Numerical Data - ANS-represents meaningful numbers, quantitative
example: # of kids
Nominal Data - ANS-categorical data, least sophisticated
example: male/female
Ordinal Data - ANS-categorical, label or names, but can be ranked
example: 1-5 star review
Interval Data - ANS-numerical, difference has meaning (zero is usually arbitrary)
example: temperature
Ratio Data - ANS-Numerical, most sophisticated, zero has true point, ratios are meaningful
example: profit
