SQL
Hustle
Excel
Tableau
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?
200
=, >, <, >=, <=, <>
ALL, AND, ANY, BETWEEN, EXISTS, IN, LIKE, NOT, OR
What are comparison and logical operators?
200
Starting from yourselves (C486 students), who is above on the COOP org chart? 100 bonus points for naming titles!
C486 students > C486 captains (Ash, Saodi, Kelvin) > C486 senior captain (Jackie) > DA lead captain (Monali) > SFDA program manager (JC) > CA associate director of program (Mark) > senior director of program, national (Darlene) > chief program officer (Adanta) > chief executive officer (Kalani)
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?
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?
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?
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?