Q4 You attempt to load a cvs file with 100 columns into a table and it fails because 1 row has too few values, how do you find the offending row?
Business Intelligence Engineer Interview Questions
1,082 business intelligence engineer interview questions shared by candidates
Data warehousing concepts, ETL fundamentals
Questions regarding ranking and metrics.
Tell me about a time you had to overcome pushback from your Manager
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
Row Level Security vs Column Level Security in Tableau? When to use ELT vs ETL? Snowflake vs Star?
(1) Oracle Partition/ Oracle Indexing (2) Types of joins (3) Difference between delete and truncate (4) Find customer who ordered this year and last year (5) Other SQL Coding questions
First was a phone call with director asking basic questions like previous job role and any experiences with tools, 2 round was panel Interivew where they gave a case study and you have to give your approach the problem using the right tool and the last was an HR round
Viewing 1061 - 1070 interview questions