SQL
Hustle
Excel
Tableau
COOP
100
SQL pronunciation and full form
What is seek-qwl and structured query language?
100
What do the 3Ws stand for?
Where I've been
Where I am
Where I'm going
100
What is Excel?
Microsoft Excel is a spreadsheet program included in the Microsoft Office suite.
100
Tableau definition
What is an interactive visualization software tool owned by Salesforce, that allows users to explore and understand their data to influence business decisions?
100
The 4 colors in COOP's logo (In order)
Red
Yellow
Green
Blue
200
=, >, <, >=, <=, <>
ALL, AND, ANY, BETWEEN, EXISTS, IN, LIKE, NOT, OR
What are comparison and logical operators?
200
Practice your 3W's with the room as if you were applying to a role of your choice
Where I am
Where I've been
Where I'm going
(OR Where I've been, Where I am, Where I'm going)
200
What are the two ways to add your formulas?
First way is to add your formula in the cell directly.
Second way to add your formula is use the formula bar above the column letters.
200
On Tableau, they are blue pills/fields and produce headers.
In Tableau, they are the green pills/fields and produce an axis.
What are discrete vs. continuous variables?
200
What year was COOP founded in?
2014
300
Sorts data in ascending (least to greatest) or descending order (greatest to least) based on one or more columns
Specifies the number of rows we want returned in a query result
Lets us skip a specific number of rows before starting to return a result from a query
What is ORDER BY, LIMIT, and OFFSET
300
What are COOP's graduation requirements?
90% attendance record
Actively participation in Client Projects
Resume 5/5
LinkedIn 8+
Coursera Courses 1-8
Apply to 20 jobs by end of program
300
What is the syntax for VLOOKUP?
Syntax: =VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
300
Types of charts below
What are dual chart, pie chart and bar chart?
300
The cities that COOP offers program in
SF, SJ, LA, Miami, New York, Chicago,
400
Walk us through the following query:
SELECT Name, Price, Type,
CASE WHEN Price <= 4.0 THEN ‘Inexpensive’
WHEN Price BETWEEN 4.0 AND 8.0 THEN ‘Average’
ELSE ‘Pricey’
END AS PriceRating
FROM Dishes
What is:
Reviewer’s price scale
$4 or less: Inexpensive
$4 - 8: Average
More than $8: Pricey
400
Here's an interview question:
What do you consider to be your weaknesses?
Respond exactly how you would as if you were in an interview. The other pods will then vote on if your response was good quality. Majority vote = points.
Was the response streamlined? Was it structured using the STAR method? Did it identify prior weakness or a current weakness? Did the speaker leave a good impression of themselves in your book?
400
How to create a pivot table?
Step 1: Highlight your data
Step 2: Insert Pivot Table
Step 3: Create new spreadsheet
400
Examples of objects in Tableau
What are horizontal and vertical container, text, image and blank?
400
The SJ program manager
Our CA director and The CEO of COOP
Sara Garcia
Mark Fajlaguatan
Kelani Leifer
500
Solve SQL Murder Mystery
Beginning your investigation
What is:
SELECT date, type, description, city
FROM crime_scene_report
WHERE date=20180115 AND type = 'murder' AND city = 'SQL City'
500
Here's an interview question:
Describe a campaign/initiative you’ve worked on from start to finish. How did you approach the task? Were you successful? How did you measure success? Were there things you could have done better?
Respond exactly how you would as if you were in an interview. The other pods will then vote on if your response was good quality. Majority vote = points.
Was the response streamlined? Was it structured using the STAR method? Was the campaign/initiative authentic? Were metrics legitimate? Did the speaker leave a good impression of themselves in your book?
500
Walk us through using a pivot table to find the answer to Q40: What is the combined revenue between the Disneyland Southern California Resident Tickets and Disneyland Annual Passes campaign in January?
$119,630,533
500
Thoughts on the following dashboard
https://public.tableau.com/app/profile/caitlin.ursino/viz/NBADraft1989-2021/dashboardwithdrafted
What is interactive?
What are important NBA metrics?
What do you think of the color choices and visual organization?
500
The year that COOP had it's first cohort in the Bay Area
2016