Write a SQL query to compute a frequency table of a certain attribute involving two joins. What if you want to GROUP or ORDER BY some attribute? What changes would you need to make? How would you account for NULLs?
Business Analytics Intern Interview Questions
13,100 business analytics intern interview questions shared by candidates
Lets say the population on Facebook clicks ads with a click-through-rate of P. We select a sample of size N and examine the sample's conversion rate, denoted by hat{P}, what is the minimum sample size N such that Probability( ABS(hat{P} - P) < DELTA ) = 95%. In other words (this is my translation), find the minimum sample size N such that our sample estimate hat{P} is within DELTA of the true click through rate P, with 95% confidence.
Given two binary strings, write a function that adds them. You are not allowed to use any built in string to int conversions or parsing tools. E.g. Given "100" and "111" you should return "1011". What is the time and space complexity of your algorithm?
Tell me about your dream job
We have a table called ad_accounts(account_id, date, status). Status can be active/closed/fraud. A) what percent of active accounts are fraud? B) How many accounts became fraud today for the first time? C) What would be the financial impact of letting fraud accounts become active (how would you approach this question)?
what is logistic regression? How to perform variable selection
Imagine a cube 1x1x1, then imagine that you form a cube of 10x10x10 with all these little cubes of 1x1x1. How many cubes do you have to remove to get rid of the surface of cubes.
how did u handle multicolleanarity in logistic model
Mini Case: eBay is getting complaints from customers that the site doesn't have enough product selection. To increase product selection eBay runs a promotion and decides to waiver the listing fees for all sellers. eBay's earns revenue from the listing fees and as a % of sales transaction and the bulk of revenue comes as a commission over sales transactions. The promotion instead of increasing the revenue results in a drop in revenue for eBay. Explain
Which field are you interested in.
Viewing 1 - 10 interview questions
See Interview Questions for Similar Jobs
Analytics InternBusiness AnalyticsBusiness AnalyticData Analytics InternAnalytics InternshipLead AnalystAnalytics ConsultingSenior Analyst Advanced AnalyticsGraduate Analytics InternMarket Risk Business AnalystData Manager InternData Analyst InternData Analytics InternshipAnalyticsBusiness Analyst Co OpMis Reporting AnalystBusiness Intelligence InternshipBusiness Analyst Intern