Skip to contentSkip to footer

Analyste Interview Questions

Salaries
Interviews

Analyste Interview Questions

L’analyste exerce dans différents domaines et examine en détail des problèmes complexes dans le but de trouver des solutions. Les employeurs recherchent des candidats dotés de fortes capacités d’analyse et de résolution de problèmes, doublées d’une connaissance approfondie du domaine concerné. Pour en savoir plus sur les questions spécifiques qui vous seront posées, renseignez-vous sur des postes particuliers tels que consultant fonctionnel, analyste financier, analyste programmeur ou data analyst.

Questions d'entretien d'embauche fréquentes pour un analyste (H/F) et comment y répondre

Question 1

Question 1 : Quelles sont selon vous les principaux atouts d’un analyste ?

How to answer
Comment répondre : Dressez la liste des critères techniques et comportementaux qui s’appliquent au poste. Votre réponse doit inclure les compétences spécifiques recherchées par un employeur ainsi que les capacités/qualités appréciées.
Question 2

Question 2 : Comment réagissez-vous face aux modifications des exigences ?

How to answer
Comment répondre : Cette question a pour but de tester votre sens logique et vos capacités à résoudre les problèmes. Il est important de discuter de votre aptitude à hiérarchiser les changements, évaluer leur impact sur les projets et les ressources, et identifier les divergences qu’ils créent au niveau technique et fonctionnel.
Question 3

Question 3 : Quel(s) outil(s) ou système(s) d’informatique décisionnelle avez-vous déjà utilisés ?

How to answer
Comment répondre : Citez les outils/systèmes en précisant comment vous les avez utilisés ; si parmi eux se trouve un outil/système auquel a recours l’entreprise pour laquelle vous passez l’entretien, il est important de le souligner. Si vous ne connaissez pas la technologie utilisée par l’entreprise, indiquez comment vous envisagez de vous y former.

434,604 analyste interview questions shared by candidates

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?
avatar

Business Intelligence Analyst

Interviewed at Criteo

3.9★
Mar 28, 2015

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?

1. if a coin is tossed the probability of getting head is 1/4. Let's say we toss the coin n times and the probability of getting two head and the probability of getting 3 head is the same. What is n? 2. The first number is sqrt of 3 , the third root of 3 and the 6th root of 3. What is the fourth number? I think I f up on both questions. I don't think they will call me for the next process
avatar

Seismic Imaging Analyst

Interviewed at Viridien

4.4★
Aug 23, 2019

1. if a coin is tossed the probability of getting head is 1/4. Let's say we toss the coin n times and the probability of getting two head and the probability of getting 3 head is the same. What is n? 2. The first number is sqrt of 3 , the third root of 3 and the 6th root of 3. What is the fourth number? I think I f up on both questions. I don't think they will call me for the next process

Here's the deal: You have to know SQL. By all accounts, and according to people within the company, they are no longer hiring people who do not have previous SQL experience. If there is one thing that I can point to that probably cost me the offer, it is that I have not used SQL in a while, and it showed. Everyone with whom I interviewed asked SQL questions. They will give you a set of EMR (Electronic Medical Record) data (2 or 3 tables) and ask questions about how you the tables might be manipulated to provide information. So you not only need to know how to select certain data types and columns to provide insight in theory, but you also must know how to construct the correct select statement. Expect questions on inner/outer joins, unions, subqueries, aggreagtor functions including how to use sum and/or count with group by. If you don't have solid command of SQL and a good bit of fresh, current use, you are probably wasting your time. Yes, SQL is a rather small language in the DML context, and something that can be picked up rather easily, but probably not quickly and completely enough to impress in the interview. Bottom line: don't expect to fake it till' you make it.
avatar

Business Analyst

Interviewed at Advisory Board

3.9★
Feb 27, 2013

Here's the deal: You have to know SQL. By all accounts, and according to people within the company, they are no longer hiring people who do not have previous SQL experience. If there is one thing that I can point to that probably cost me the offer, it is that I have not used SQL in a while, and it showed. Everyone with whom I interviewed asked SQL questions. They will give you a set of EMR (Electronic Medical Record) data (2 or 3 tables) and ask questions about how you the tables might be manipulated to provide information. So you not only need to know how to select certain data types and columns to provide insight in theory, but you also must know how to construct the correct select statement. Expect questions on inner/outer joins, unions, subqueries, aggreagtor functions including how to use sum and/or count with group by. If you don't have solid command of SQL and a good bit of fresh, current use, you are probably wasting your time. Yes, SQL is a rather small language in the DML context, and something that can be picked up rather easily, but probably not quickly and completely enough to impress in the interview. Bottom line: don't expect to fake it till' you make it.

Viewing 771 - 780 interview questions

Glassdoor has 434,604 interview questions and reports from Analyste interviews. Prepare for your interview. Get hired. Love your job.