Skip to contentSkip to footer

Business Intelligence Engineer Interview Questions

Salaries
Interviews

1,082 business intelligence engineer interview questions shared by candidates

1. If there are 2 tables with m and n rows respectively, then what will be the minimum and maximum number of rows in all the joins. 2. Get the 3rd highest employee salary from employee salary table. 3. Given a product table, the new record gets appended in table with the new timestamp for the product ID. Find out the latest row for that particular product with or without analytical functions. 4. Given there are 2 tables of employee details and employee project details, which all employee are not yet assigned a project.
avatar

Business Intelligence Developer

Interviewed at Balboa Water Group

2.4★
Jul 15, 2022

1. If there are 2 tables with m and n rows respectively, then what will be the minimum and maximum number of rows in all the joins. 2. Get the 3rd highest employee salary from employee salary table. 3. Given a product table, the new record gets appended in table with the new timestamp for the product ID. Find out the latest row for that particular product with or without analytical functions. 4. Given there are 2 tables of employee details and employee project details, which all employee are not yet assigned a project.

Q1: Time required to load 1gb of data Q2: situational how do you complete a task if one of the requirement is missing? Q3: Given table having columns Date and CustomerID , Date when a customer visited website and customerID identifying a customer. Create a report which will display last month's % of returning customers. example: Date 0 1 2 3 4 ......30 ( These are the columns for report) 17thDec2017 25 22 21 19 18....3 (values
avatar

Business Intelligence Engineer

Interviewed at A9.com

3.7★
Jan 17, 2018

Q1: Time required to load 1gb of data Q2: situational how do you complete a task if one of the requirement is missing? Q3: Given table having columns Date and CustomerID , Date when a customer visited website and customerID identifying a customer. Create a report which will display last month's % of returning customers. example: Date 0 1 2 3 4 ......30 ( These are the columns for report) 17thDec2017 25 22 21 19 18....3 (values

At this point, I do not remember specific questions, but there were a number of personality questions meant to determine if you could handle the demands of working remotely with no direct, in-person supervision.
avatar

Business Intelligence Developer

Interviewed at Academic Analytics

3.7★
Sep 4, 2015

At this point, I do not remember specific questions, but there were a number of personality questions meant to determine if you could handle the demands of working remotely with no direct, in-person supervision.

Viewing 941 - 950 interview questions

Glassdoor has 1,082 interview questions and reports from Business intelligence engineer interviews. Prepare for your interview. Get hired. Love your job.