DATA TYPES
This type of data is meant for sorting into categories and is not used for calculations
Categorical Data
This type of chart is useful for understanding a categorical variable based on counts of a particular occurrence
Bar Graph
Name any two types of joins
Inner Join (or Join)
Left Outer Join (or Left Join)
Right Outer Joint (or Right Join)
Full Outer Join
Cross Join
What is prescriptive analytics?
Asking what should we do about it
What does SMART stand for?
Specific, Measurable, Achievable, Relevant, Time-bound
When analyzing your household income, you are looking at this type of data
Quantitative (numeric) Data
This type of graph looks at the shape of the distribution of a quantitative variable
Histogram
What does an INNER JOIN return?
One table with only the matching rows from both tables
What is diagnostic analytics?
Asking why something occurred
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
Data with names or labels other than numbers is also known as this data type
Qualitative Data
On this type of graph, data is plotted as points and can show a trend or pattern of two quantitative variables
Scatterplot
Explain the difference between Inner Join and Outer Join
Inner Join returns a table with only the matching rows from the two tables.
Outer Join returns matching rows plus non-matching rows with NULLs.
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’ report card scores. He has obtained this data and stored them as numbers in a variable called “Score”. Is this variable categorical or quantitative? Why?
Quantitative because it can be used for mathematical 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 OUTER JOIN (or FULL JOIN)
The measure that describes the typical difference between each data point and the mean
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