Excel
What is Excel?
Excel is a spreadsheet that features calculations, graphing tools, pivot tables, and VBA/macro applications
What is Tableau?
A data visualization platform to help people understand data.
When and where did LinkedIn launch?
2002, Mountain View, CA
What does SQL stand for?
Structured Query Language
Which social media platforms were down on 10/5/21.
Facebook, IG and WhatsApp
What is a VLOOKUP?
VLOOKUP is an excel function that looks up data in a table organized vertically. You can lookup a value by matching in the first column of the table.
What are dimensions and measures in Tableau?
Dimensions can be categorical, qualitative or a number.
Measures can be a property of sum, count, minimum, maximum, which is quantitative or aggregated
What is the purpose of LinkedIn?
Their mission is to connect the world's professionals to make them more productive and successful.
What is a database?
A database is an organized collection of data, generally stored and accessed electronically from a computer system.
what is Dracula's real name?
Vlad the Impaler
How do you freeze a row in excel?
Select VIEW - Freeze panels
What is a marks card?
A marks card is a key element for visual analysis in tableau. You can drag the fields to the different properties and context and detail to the marks in the view.
Which section do you put COOP under?
Education
Name the 3 main commands in SQL
1. SELECT
2. FROM
3. WHERE
Which borough has the BEST halal food?
QUEENS
What does KPI stand for?
Key performance indicators
What is a filters shelf?
A filters shelf allows you to specify what data to include and exclude.
Who bought linkedin and for how much?
Microsoft paid $26 billion for LinkedIn
Name 2 relational database management systems
MYSQL
PostgreSQL
Oracle Database
Microsoft SQL Server
When was the first iphone released
What is a cell,row and column?
must answer all three
A cell is consisted of a column letter and row number. Example - C2
A column is vertical lines in a excel worksheet.
A row is horizontal lines in a excel worksheet
Share your screen and use tableau to create a heat map with the data of your choice.
thanks.
Name all the founders
Reid Hoffman, Konstantin Guericke, Jean-Luc Vaillant, Allen Blue, Eric Ly
What does the JOIN clause do?
Using the JOIN clause in a query, we can combine row data across two separate tables using this unique key.
When was the first android released?
September 23, 2008