Skip to contentSkip to footer

Business Intelligence Developer Interviews

Salaries
Interviews

Business Intelligence Developer Interview Questions

"Business intelligence developers are responsible for developing and maintaining the business data systems of a company. They must be well versed in SQL and other query tools, as well have have strong business analysis to work in tandem with the company's business data. During an interview, be prepared to be tested on these skills by both technical questions and case studies on how you would fix particular problems for a company."

6,924 business intelligence developer interview questions shared by candidates

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
avatar

Senior Business Intelligence Engineer

Interviewed at Amazon

3.5★
Dec 7, 2020

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

Viewing 6691 - 6700 interview questions

Glassdoor has 6,924 interview questions and reports from Business intelligence developer interviews. Prepare for your interview. Get hired. Love your job.