DATA TYPES
This type of data is meant for sorting into categories and is not used for calculations
Categorical Data
This type of graph shows one or more categorical variables based on counts of a particular occurrence
Bar Graph
In order to join two tables, both tables must contain the same what (Row or Column)?
Same Column
When we are asking the question "What do we do about these findings," we are performing this type of analytics
Prescriptive Analytics
What does SMART stand for?
Specific, Measurable, Achievable, Relevant, Time-bound
This type of data is useful for performing numeric calculations
Quantitative Data
This type of graph looks at the shape of the distribution of a quantitative variable
Histogram
This type of join returns one table with only the matching rows from both tables
INNER JOIN
When we want to better understand why something occurred, we are performing which type of analytics?
Diagnostic Analytics
What type of platform is Microsoft Azure, Amazon Web Services (AWS), and others?
Cloud-Based Platform
Charlie is a school principal with a lot of data of his students. One column in his dataset, "Date of Birth," has this data type
Special Data (date)
This type of graph is useful for showing changes over time of a variable
Line Graph
This type of join returns all records from the left table and matched records from the right table
LEFT JOIN (or LEFT OUTER JOIN)
What are commonly used measures of center?
Mean, Mode, and Median
This type of cloud-based storage allows for data to kept both on-premises or on the cloud for sharing between many other organizations
Data Mesh
In Charlie's dataset, there is a column called "Annual Income" which shows the annual income of the students' parents. What data type is "Annual Income?"
Quantitative Data
On this type of graph, data is plotted as points and can show a trend or pattern of two quantitative variables
Scatterplot
This type of join returns all records from the right table and matched records from the left table
RIGHT JOIN (or RIGHT OUTER JOIN)
In the dataset 5, 8, 8, 10, 13, find the median.
8
This is known as the "data about the data" and is used for quick retrieval of data when stored on the cloud
Metadata
The students' grade level is found in the column "Grade" in Charlie's dataset. Is "Grade" categorical or quantitative? Why?
Categorical because even though grade is a number, it is used to group the students, not perform calculations
This chart uses boxes to show data distribution, showing minimum, maximum, median, quartiles, and outliers
Boxplot
Returns all records when there is a match in either the left or right table
FULL JOIN (or FULL OUTER JOIN)
The measure that describes the mean of the squared differences between each data point and the mean
Variance
What is the biggest challenge for implementing a Digital Transformation initiative like what we are going through now? Learning New Technology or Culture Change
Culture Change