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 are trying to understand historical patterns, we are performing this type of analytics
Descriptive 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 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
What are commonly used measures of center?
Mean, Median, and Mode
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)
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)
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 spread of the data around the mean and is the square root of the variance is known as this
Standard Deviation
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