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
A dataset with a column named "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
If Charlie's dataset has a column called "Score" which shows percentages, 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 wants to compare students by grade level which are stored in a column called "Grade." Is "Grade" categorical or quantitative? Why?
Categorical because grade is used as a category to group students in this context
This type of graph compares two quantitative variables and has a line of best fit
Scatterplot
Name the four ways we can tidy up the data
Standardizing variables, Handling missing data/values, Removing duplicates, Validate data against expected values
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