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?
Intelligence Interview Questions
6,759 intelligence interview questions shared by candidates
Describe the different parts of an SQL statement
Whats the difference between inner join and outer join?
What is a clustered/non clustered index.
What reporting tools have you used? Actuate, Brio, Crystal Reports? How much experience have you had in scheduling jobs on Unix? Can you write XML and implement it?
Explain/define "Weighted Average".
The typical "difficult" question that comes up in Business Intelligence is (and I'm paraphrasing), "What's the best data warehouse solution?".
Basic SQL questions. Describe a join to a non-technical person. How do you handle a query that does not perform quickly? They want to know that you can use 'explain plans', which I currently do not use (I'm still entry level). Select all customers who purchased at least two items on two separate days. Given a table with a combination of flight paths, how would you identify unique flights if you don't care which city is the destination or arrival location.
probability of the product coming from location A is 0.8 and from location B is 0.6. What is the probability the customers will receive the product from location A or location B SQL - tested on different join , lead , lag, pivoting in sql , sub query, group by having, where, aggregate and think about how you would find outliers)
Derive customer's account status as of month end for all the months in 2019. If for given month, there are more than one rows, pick the data from the latest date within the month. If for given month, there is no data, pick the data from latest date prior to the month You can use last_day function to get month ending date(Eg: last_day(01/01/2015) = 01/31/2015) customer_id event_date status credit_limit 1 1/1/2019 C 1000 1 1/5/2019 F 1000 1 3/10/2019 1000 1 3/10/2019 1000 1 8/27/2019 L 1000 2 1/1/2019 L 2000 2 1/5/2019 2500 2 3/10/2019 2500 3 1/1/2019 S 5000 3 1/5/2019 6000 3 3/10/2019 B 5000 4 3/10/2019 B 10000
Viewing 1 - 10 interview questions
See Interview Questions for Similar Jobs
Intelligence OfficerThreat IntelligenceIntelligence Analyst ManagerIntelligence Open SourceGis Technical AnalystCyber IntelligenceGeospatial Intelligence AnalystCyber Threat IntelligenceCounterintelligenceIntelligent Transportation Systems EngineerContract Intelligence AnalystIntelligence Operations SpecialistWatchlist Intelligence AnalystMilitary IntelligenceIntelligence Research SpecialistGis Systems AnalystGis ArchitectGeospatial Data Scientist