DATA TYPES
This type of data is meant for sorting into categories and is not used for calculations
Categorical Data
This graph is used to look at one or more categorical variables based on the number of counts
Bar Graph
In order to join two tables together the tables must share the same what (Row or Column)?
Same Column
When we want to answer the question, "What should 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 numeric and is useful for performing 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 are trying to explain why something occurred, we must perform this 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 "Score" which describes the students' report card scores as a percentage. What data type is "Score?"
Quantitative Data (numeric)
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
Charlie now wants to look at the students’ grade levels, which are stored in a column called "Grade." Is this variable categorical or quantitative? Why?
Categorical because grade is used as a category to group students in this context
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 average squared difference between each data point and the mean value is known as this
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