Questions about my experience, motivation to change the job, teamwork & management skills and a few technical questions regarding most important tools/technologies used in the team.
Senior Intelligence Analyst Interview Questions
244 senior intelligence analyst interview questions shared by candidates
Online SQL test. Questions about experience, motivations and interests.
Please write a SQL statement to identify...
About my past SQL work experience.
Questions during interview: 1- Say you do on-line ads for two different companies, EasyJet and Mercedes. How would you present your results to the board and prove them you did not waste any money? 2- Another question that involves some economic thinking about why profits go down etc. in the on-line ad business. I recommend you review concepts such as Click-Through Rate, Conversion Rate and the auction mechanisms in on-line marketing etc. 3- After Facebook users pass away, their profile pages remain. So today we have some dead users and some users that are still alive. Will the number of dead people ever equal that of the ones that are alive? When will that happen? How would you calculate it?
How do you deal with a difference of opinion of senior leadership?
General Q&A about experience and goals
Q1. Difference between SQL, MySQL and Redshift in terms of computation and performance as i had worked on these 3 Q2. What is hierarchy of SQL script execution and how can it be optimised Q3. Which visualization tool is best among tools i worked upon - Tableau, Power BI , DOMO and Google Data Studio and what are advantages of Power BI w.r.t Tableau and DOMO in terms of computation and other Q4. Some Question related to time series forecasting and best method to be used for this Q5. How to analyse and evaluate customer behaviours (Case study)
I was asked how I would validate models. My comfort level with SQL. If I had ever read a financial statement. And if I had ever programmed with nested loops.
What tools do you use in your daily work at the moment?
Viewing 191 - 200 interview questions