The questions are straight forward. The questions asked of me fell into two categories: subject matter expertise, foreign contacts, and criminal history.
Business Intelligence Analyst Interview Questions
6,924 business intelligence analyst interview questions shared by candidates
Offering 20% discount increases sales by 25% - what's the impact on financials, operations, marketing
Given the fact that revenue will not increase or even decrease a little bit, but with a higher percentage of email registration, will you say this is acceptable?
Let's say Amazon undercuts the price of a similar barstool by 10%. Should we undercut as well, and if we undercut and don't see any improvement in selling performance, what may be the cause for this?
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.
No questions at all were asked about business intelligence analyst or data analytics The only question asked was -How much do i rate myself on SQL on the scale of 1 to 10
salary(department_id,employee_id,salary) List all employees with salary greater than the everage department salary and also greather than $50K
Was asked to write queries for two problems - Q. Table: Customer_orders customer_id order_id order_day 123 27424624 25Dec2011 123 89690900 25Dec2010 797 12131323 25Dec2010 876 67145419 15Dec2011 Write SQL for customers who placed orders on both the days, 25th Dec 2010 and 25th Dec 2011? Customer_id order_id order_datetime 1234 4141-4814 25/12/2010:06:15:00 1234 4141-4815 25/12/2010:06:20:00 1234 4141-4816 25/12/2010:06:41:00 1234 4141-4817 25/12/2010:06:50:00 8153 2525-1414 26/12/2010:07:13:00 8153 2525-1415 26/12/2010:13:10:10 Let's say I can combine two orders that are placed by the same customer within 20 mins of each other, what % of orders can be combined.
Question 1 : An ad campaign has generated 1 million ad impressions and 6000 clicks.What is the CTR (ClickThrough Rate)? (in percentage) Question 2 : An ad campaign has generated 5000 clicks and 100 transactions. What is the conversion rate (in percentage)? Question 3 : With a budget of $5000 and a CPC (Cost per click) = $0.4, how many clicks an advertiser can buy (integer without unit)? Question 4 : An ad campaign has a CTR = 0.6% and a CPC = $0.4.What is the equivalent CPM (in dollar)? Question 5 : An ad campaign has a CPC = $0.5, a conversion rate = 3% and an average transaction value of $260.What is the Cost of Sales of the campaign (cost of the ad campaign divided by the revenues generated, in percentage)? Question 6 : With a margin on revenues of 13%, an average transaction value of $290 and a conversion rate = 0.7%, what is the maximum CPC an advertiser can afford without losing money (in dollar)? Question 7 : During his browsing, a user is randomly exposed to two ad banners A & B. Those two banners are equally likely to be shown. One and only one banner is shown per page. After two pages of browsing, what’s the probability that the user was shown only banners A (in percentage)? Question 8 : A/B Testing campaign: Measuring the impact of Criteo retargeting ads compared to a control group. Number of transactions on client site : • Group A exposed to Criteo banners 600,000 • Group B Control group not exposed 50,000a. a. Is it a problem to have a control group smaller than the CompanyA group? No - what you want to know is if the transaction rate for the experiment group is significantly greater than that of the control group. As long as the results are statistically significant, the uneven sample size between groups should not be a problem. b. What incremental revenues per user CompanyA has generated for the client advertiser (in dollar, rounded to the cent)? For this question you need to first calculate the revenue per user for both groups and then take the difference between them to arrive at the incremental revenue per user. c. What total incremental revenues CompanyA has generated for the client advertiser? Total incremental revenue is simply the incremental revenue per user multiplied by the number of users exposed to Company A's retargeting. d. With $200.000 revenues following clicks on banners for group A (post click), what is the related post view (view through) effect in revenues generated by CompanyA campaign?
Name a research project that you have completed, and the role that you took.
Viewing 21 - 30 interview questions
See Interview Questions for Similar Jobs
Intelligence AnalystBusiness Intelligence ConsultantBusiness Intelligence SpecialistBusiness Intelligence DeveloperBusiness AnalystData AnalystBusiness Intelligence ManagerBusiness Intelligence EngineerData ScientistBi DeveloperReporting AnalystBusiness Intelligence Project ManagerBi AnalystBi ConsultantMarket Intelligence ManagerBusiness System Analyst