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
You have a website and you need to report the traffic insights on this website to the Product Manager. Write a SQL query to find the top 10 persons who have visited the website in the last month.
How to systematically find outlier?
What is a primary key?
Difference between where and having
1. Tell me about yourself 2. difference between transactional databased and OLAP 3. pick a field you are strong in and then follow up questions were asked SQL: given a table consisting of routes including source and destination find the sources which are never a destination. (something like that, don't remember exactly)
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.
About a project where I used metrics to capture business insights.
SQL - Top 2 highest salaries by department.
Viewing 141 - 150 interview questions