Business Intelligence Analyst Interview Questions | Glassdoor

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."

Top Interview Questions

Sort: RelevancePopular Date

Explain/define "Weighted Average".

1 Answer

An average in which each quantity to be averaged is assigned a weight. These weightings determine the relative importance of each quantity on the average. Weightings are the equivalent of having that many like items with the same value involved in the average.

50,000 shoppers with a 0.5% conversion rate for a chair that costs $250. Wayfair makes a 27% profit. Next, 50,000 shoppers will get a 10% discount. What is the conversion rate they must achieve to achieve the same profits as before?

14 Answers

Describe the different parts of an SQL statement

2 Answers

Whats the difference between inner join and outer join?

2 Answers

You have a table called Order with Cust_ID, Order_Date, Order_ID, Tran_Amt. Select the top 100 customers with high spend over a year long period.

4 Answers

What is the market for tennis balls in your city?

1 Answer

just general questions

1 Answer

Give an example of a time when you influenced strategic decisions.

1 Answer

What is the difference between DELETE and TRUNCATE? What is the difference between UNION and UNION ALL? What is the difference between a WHERE statement and a HAVING clause?

1 Answer

If you were stuck on a desert island with a database that contained all the knowledge ever created, but you only had 10 SQL statements that you could ever use, what would they be?

1 Answer
110 of 280 Interview Questions