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.
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
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.
Along with the usuals, he asked "If it's 11:20 on an Analog clock, what is the angle between the two hands?" (note: that includes the slight rotation of the hour hand between the hours). I got it wrong three times, but he didn't care. He said he just had to ask because it was required.
What’s the biggest threat to global security today?
How would you describe yourself? Someone who works independently or a team member?
A product has a probability of 60% showing up in warehouse A, and 80% in warehouse B. What is the probability that two products show up at the same warehouse?
Viewing 31 - 40 interview questions