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
Business Intelligence Engineer Interview Questions
Business Intelligence Engineer Interview Questions
Business Intelligence Engineers oder kurz BI Engineers erhalten wahrscheinlich mehrere Fragen zu ihren Kenntnissen in der Anwendung von Skriptsprachen, Prozessoren und Programmen, die vom potenziellen Arbeitgeber verwendet werden. Es können zwar auch einige Fragen zu zwischenmenschlichen Beziehungen gestellt werden, doch wird es beim Vorstellungsgespräch für Business Intelligence Engineers eher um Ihre Erfahrungen im Bereich Datenanalyse gehen.
Typische Bewerbungsfragen als Business Intelligence Engineer (m/w/d) und wie Sie diese beantworten
Frage 1: Auf welches Projekt, an dem Sie gearbeitet haben, sind Sie stolz?
Frage 2: Mit welchen Sprachen/Programmen/Softwareprodukten sind Sie bereits sehr vertraut?
Frage 3: Wie würden Sie ...?
6,925 business intelligence engineer interview questions shared by candidates
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?
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
How do you work with stakeholders?
Sql question - Use of Group by,Having,Count.
Walk me through your rsm
1. Could you please provide a detailed walkthrough of your professional background, highlighting the specific roles and responsibilities you have held throughout your career journey? 2. What are the most significant achievements, technical skills, or key takeaways from your previous work experiences that we should explore further during this discussion? 3. Given the fast paced nature of our industry, are you open to working additional hours or overtime when project deadlines and business needs require it?
Viewing 6801 - 6810 interview questions