Spreadsheets
This makes up the rows and columns in a spreadsheet
What is a "CELL"?
This always starts the SQL statement
What is "SELECT"?
The FIRST PHASE in the data life cycle
What is "PLAN"?
This function adds up a series of numbers and/or cells
What is "SUM()"
There are this many steps in the Data Analysis process
What is 6?
You need to enter the number $250 into the cell where row 5 and column C intersect. What is the name of this cell?
What is cell "C5"?
This SQL statement returns all columns and rows from a table.
What is "SELECT * FROM table"?
The PHASE that, "Securely eliminate data that's no longer needed to protect privacy"
What is "DESTROY"?
This function makes all text in a string into upper case.
What is "UPPER()"?
This is the first step in the Data Analysis process
This chart plots two numerical data columns
What is a "scatter plot"?
This aggregate function returns unique values from a column
What is "DISTINCT"?
This technique is used for ROOT CAUSE ANALYSIS
What is "The FIVE Whys"?
This function converts "john" to "John"?
What is "PROPER()"?
This data type is qualitative traits and is divided into nominal (unordered categories, like colors or names) and ordinal (ordered categories, like rankings or levels).
What is "Categorical" data?
This counts all items in a series
What is "COUNTA"?
This is missing in the SQL statement:
"SELECT CARS FROM WHERE TYPE = 'red' "
What is "TABLE name" or "TABLE"?
"The trustworthiness and quality of your data sources"
What is "VERACITY"?
This returns the middle value of a series
What is MEDIAN?
This process, "identify patterns, uncover relationships, spot trends, and perform calculations to extract meaning"
What is "ANALYZE"?
This powerful feature lets you calculate, summarize, and analyze data as well as letting you see comparisons, patterns, and trends in your data
What is "PIVOT" or "PIVOT tables"?
This is missing in the SQL statement:
"SELECT CARS, COUNT(*) FROM CAR_TABLE"
What is "GROUP BY CARS"?
This process is where recommendations can be made
What is "ACT"?
This used in SQL to filter results after a GROUP BY clause has aggregated the data.
What is "HAVING"?
This storage is ideal for storing unstructured data of any type or size, such as images, videos, audio files, or backups. It's highly scalable and cost-effective.
What is "BLOB"?