Skip to contentSkip to footer

Business Intelligence Analyst Interviews

Salaries
Interviews

Business Intelligence Analyst Interview Questions

"Business intelligence analysts use their analysis of market trends and internal data to recommend where a business can improve profits and reduce expenses. Prepare for your interview by brushing up on your financial math and SQL skills, as well as your knowledge of the company's competitive space. A few years of experience and a degree in business, finance, or computer science is required for this position."

6,937 business intelligence analyst 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 6651 - 6660 interview questions

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