why are you moving on
Business Intelligence Intern Interview Questions
6,929 business intelligence intern interview questions shared by candidates
DS, DA, big data, SQL
Data warehousing concepts, ETL fundamentals
Questions regarding ranking and metrics.
Tell me about a time you had to overcome pushback from your Manager
From a scale of 1 to 5, what would you say is your fluency with SQL?
SQL Table with the columns: UserID, TransactionID, DepartmentID, TransactionDate, UserName, DepartmentName 1. Do not remember the question. 2. For each department , show the users who make at least 3 transactions 3. For each department, select the user with the most Transaction (the result should contain the following fields: DepartmentName, UserName, number of interactions) 4. Difference between RowNumber and Rank Business question: Conversion ratio: x / (y + z) x = sales y = searches z = Searches in Alexa Given: The conversion rate increased, and the number of searches in Alexa (z) decreased. Question: Should I remove the Alexa search function? Answer: Not necessarily - need to check if y dropped more than z
3. SQL query to get all order lines and average of category on each record and return only top 10 categories
Q: Difference between UNION and UNION ALL
Why you want to join Amazon?
Viewing 6761 - 6770 interview questions