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 Analyst Interview Questions
Intelligence Analyst Interview Questions
An intelligence analyst evaluates data and information to identify security risks and mitigate them for various organizations. Some intelligence analysts work for government agencies, but the field is broad and spans across various industries. When interviewing for a position as an intelligence analyst, you may face questions about the tools you use to identify risks.
Top Intelligence Analyst Interview Questions & How to Answer
Question 1
Question #1: Describe your method for identifying and mitigating security risks.
How to answer
How to answer: An interviewer uses this question to understand your methods and processes for managing important tasks. Use the STAR method to describe a specific situation that demonstrates how you analyze data to identify potential security risks for an organization and take action.
Question 2
Question #2: How do you track the data you use to make decisions and share information with others on the team?
How to answer
How to answer: Data analysis is part of the role of an intelligence analyst, but this individual also needs to be able to track the data they use and disseminate it across the intelligence team. When answering this question, talk about the software or tools you have experience with that allow for accurate data analysis and management.
Question 3
Question #3: What do you think is the greatest responsibility of an intelligence analyst?
How to answer
How to answer: This question allows you to share your perspective on the role of an intelligence analyst and their responsibilities to an organization. Your perspective might outline the importance of mitigating security risks or describe the responsibility of protecting a group of people.
6,923 intelligence analyst interview questions shared by candidates
Describe the different parts of an SQL statement
What is a clustered/non clustered index.
Whats the difference between inner join and outer join?
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)
Wayfair is going to send 2 different catalogs to their customers. One of the catalogs costs 50 cents to make and is 50 pages long. The conversion rate for the catalog is 5% and each customer brings in 315 dollars. The second catalog costs 95 cents to make, is 100 pages long and each customer brings in 300 dollars from it. The profit margin is 30%. What should the conversion rate for the second catalog be to make at least the same amount of profit as the first one. After you find the conversion rate for the second one, there is a second part of the problem. Wayfair is planning to make a new catalog which is going to cost 10 cents more than the 100 page one. The more expensive catalog is going to be sent out to 20% of the customers while the remaining 80% are going to get the 100 page one. Assume the same 30% profit margin and 300 dollar profit from each customer. What should the conversion rate for the new catalog be in order to receive the same profit at the end?
Viewing 1 - 10 interview questions