Data, Data, Everywhere!
🐍
SQL
Table-au
Misc
100
This is a two dimensional structure with rows and columns
What is A Table
100
To comment a line in Python, you use this/these character(s).
What is #?
100
SQL stands for this
What is Structured Query Language?
100
This company bought Tableau for 15.7 Billion
What is Salesforce?
100
This Captain recently got married
Who is Esmelin Lopez?
200
A type of database that ‘relates’ tables to each other
What is Relational Database
200
This commonly used Python data structure contains a collection of items referenced by a numeric index.
What is A List
200
This is what each SQL statement does when...
SELECT (what) ...
FROM (what)
WHERE (what);
*Captain to verify answer*
200
This is what a Data Analyst must do to ensure data can be reported properly
What is Data Cleaning?
200
The year COOP launched in Chicago
What is 2021?
300
This term defines what data looks like and how it can be used
What is Data Type
300
In Python, this is the smallest element of a program that can be executed
What is a statement?
300
This is how you select everything from a table
Select * FROM
300
True or false?
Number Data Types can be aggregated on.
True
300
Name all 6 COOP cities
1. NYC
2. SF
3. LA
4. SJ
5. CHI
6. MIA
400
The meaning of CPC, CPA, or CPM (any one answer would be fine)
What is [Cost Per Click, Cost Per Action, Cost Per Thousand Views]
400
Python will warn on a logic error, but it will warn (and possibly error) on this type of error.
What is a syntax error?
400
This is a subset of SQL used to select and update the data in a database
What is DML?
400
It’s important to change Numbers from String to Number data types for this reason
Strings don’t have an ability to aggregate
400
The name of this man.
Who is Kalani Leifer?
500
A field of study that uses raw data to create new ways of modeling and understanding the unknown
What is Data Science
500
This built-in Python function returns the length of many objects, including Lists.
What is Lens()?
500
This function provides the lowest value in a set of values
What is Min()?
500
This controls the appearance of the visual analysis in Tableau
What are Marks?
500
Name COOP's 6 Pillars
1. Purpose
2. Curiosity
3. Resourcefulness
4. Optimism
5. Empathy
6. Community