Some questions to test complex joins of tables and data modelling.
Business Intelligence Engineer Interview Questions
1,082 business intelligence engineer interview questions shared by candidates
Given and orders table and a products table give me all products that had sales in 2016 and no sales in 2017
Given an orders table and a products table give me a list of all product categories, the number or orders they had and the total revenue.
HR decides if the candidates is able to move to the next round
Order Table OrderID|Merch ID|MerchantID|Category|date|price|quantity|…… MerchantID|ID|Name|Status 1. To find out all merchants with ‘Amazon’ in name and return a column ‘internal customer’ if Upper(Amazon) in name or else ‘3P Seller’. Return Null if the merchant name is null
4. What is ETL? what it is used for
SQL - Top 2 highest salaries by department.
Tell me about yourself. Why Amazon?
Define data warehouse? and how you used in your project
I signed an NDA
Viewing 141 - 150 interview questions