Data Analyst Interview Questions

Data Analyst Interview Questions

L’entretien d’embauche vise en partie à tester vos connaissances techniques concernant notamment les logiciels d’analyse de données, la terminologie propre à cette discipline et les méthodes statistiques. Vos capacités à résoudre les problèmes et votre esprit créatif seront également évaluées.

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

Question 1

Question 1 : Avec quels logiciels d’analyse de données avez-vous travaillé ?

How to answer
Comment répondre : La majeure partie des tâches d’un data analyst se fait à l’aide de logiciels. Cette question vise à déterminer votre niveau de compétence actuel et le degré de formation dont vous auriez éventuellement besoin. Mentionnez tous les logiciels d’analyse de données que vous avez utilisés, sans oublier les formations à des logiciels spécifiques, en donnant des exemples de leur utilisation.
Question 2

Question 2 : Quelles sont les méthodes statistiques les plus intéressantes pour l’analyse de données ?

How to answer
Comment répondre : Cette question vise à évaluer votre connaissance des méthodes statistiques les plus courantes, telles que l’algorithme du simplexe, l’imputation, la méthode bayésienne ou le processus de Markov. Énumérez les différentes méthodes en précisant les avantages de chacune d’elles. Si possible, donnez des exemples de votre propre expérience de ces méthodes statistiques.
Question 3

Question 3 : Expliquez comment vous estimeriez le nombre de parapluies vendus à Seattle au mois de mai ?

How to answer
Comment répondre : Ce genre d’estimation approximative est souvent utilisé lors des entretiens pour évaluer les capacités d’analyse et de résolution des problèmes des candidats au poste de data analyst. Expliquez votre démarche en indiquant de quels types de données vous auriez besoin, comment vous trouveriez ces données et quelles méthodes vous utiliseriez pour calculer votre estimation.

49,201 data analyst interview questions shared by candidates

how did you analyze data? Who uses your data analysis results? how large is the data set you work with? sql question one: the first table is customer purchase table, with five columns, customer id, purchase date, product id, unit price, unit purchased, write queries to retrieve data with unique customer id that made over $100 purchase in the past seven days. sql question two: a second table is the customer details table, with two columns, customer id, registration date, write queries to retrieve data with unique customer id that made over $100 purchase who registered in the past ten days. probability question: what is the probability of generating ten consecutive numbers in ascending order out of 100 numbers? this is a random number generation question.
avatar

Data Analyst

Interviewed at Amazon

3.5
Nov 8, 2016

how did you analyze data? Who uses your data analysis results? how large is the data set you work with? sql question one: the first table is customer purchase table, with five columns, customer id, purchase date, product id, unit price, unit purchased, write queries to retrieve data with unique customer id that made over $100 purchase in the past seven days. sql question two: a second table is the customer details table, with two columns, customer id, registration date, write queries to retrieve data with unique customer id that made over $100 purchase who registered in the past ten days. probability question: what is the probability of generating ten consecutive numbers in ascending order out of 100 numbers? this is a random number generation question.

Case 1: Given APR, Interchange fee, Avg monthly balance, Avg spend every month, and loss rate of 3% calculate the profit per customer. Now justify if it is profitable to give cash back to the customers.. Case 2: 2 ways of campaigning for credit cards 1. Email - 10% of applicants become customers - each representative can verify 10 email applications in an hr and is paid $25/hr 2. Chat - 20% of applicants become customers - each representative can respond to 4 applications in an hr and is paid $25/hr Profit per customer in both the cases in $100. which one is profitable email or chat. Draw the graph of profit vs no of applicants Consider a scenario where there are only 5 representatives to handle applications. In this case which one is more profitable email or chat. calculate the breakeven point for the no of representatives where chat will be profitable than email.
avatar

Senior Data Analyst

Interviewed at Capital One

5
Mar 17, 2016

Case 1: Given APR, Interchange fee, Avg monthly balance, Avg spend every month, and loss rate of 3% calculate the profit per customer. Now justify if it is profitable to give cash back to the customers.. Case 2: 2 ways of campaigning for credit cards 1. Email - 10% of applicants become customers - each representative can verify 10 email applications in an hr and is paid $25/hr 2. Chat - 20% of applicants become customers - each representative can respond to 4 applications in an hr and is paid $25/hr Profit per customer in both the cases in $100. which one is profitable email or chat. Draw the graph of profit vs no of applicants Consider a scenario where there are only 5 representatives to handle applications. In this case which one is more profitable email or chat. calculate the breakeven point for the no of representatives where chat will be profitable than email.

Viewing 21 - 30 interview questions

Glassdoor has 49,201 interview questions and reports from Data analyst interviews. Prepare for your interview. Get hired. Love your job.