SQL: 1. find the duplicates in a given dataset 2. order of execution 3. output of rank and dense rank 4. running total Tableau: 1. live vs extract 2. scatter plot and box plot 3. formula for IDR and outliers Guesstimate: 1. Number of flights taking off from an airport in a day

Question

Accepted Answer

Interview questions for Analyst II position on SQL, Tableau, and Guesstimate

SQL: finding duplicates, order of execution, rank and dense rank, running total
Tableau: live vs extract, scatter plot and box plot, IDR and outliers formula
Guesstimate: estimating number of flights taking off from an airport in a day

SQL: 1. find the duplicates in a given dataset 2. order of execution 3. output of rank and dense rank 4. running total Tableau: 1. live vs extract 2. scatter plot and box plot 3. formula for IDR and outliers Guesstimate: 1. Number of flights taking off from an airport in a day

Popular interview questions of Analyst II