Back
Data Analyst
Questions
228 Questions
Clicking on the following links will update the content below
1.
Why do you want to work for us?
selected
2.
Why do you think you are suitable for this job?
3.
Can you tell me about yourself?
4.
Where do you see yourself in 5 years from now?
5.
What do you know about SQL?
6.
If a online shop is deciding to purchase or not purchase the BloomReach site search service, how would you help them to decide?
7.
How will you define an array?
8.
What are your strengths?
9.
What do you think you need to improve?
10.
What is your biggest concern?
11.
Have you worked with time series data before?
12.
How does your work experience help you in preparing for this role?
13.
What is your favorite marketing campaign?
14.
How many footballs will be required to fill a cubical room?
15.
What is your research experience?
16.
Tell me about a time when you had to deal with conflicts in a team.
17.
How will you explain multiple regression analysis in layman terms?
18.
How many petrol pumps are there in Mumbai?
19.
How do you deal with boring tasks?
20.
Tell me about a time when you received constructive criticism and how did you handle it?
21.
What is a data warehouse?
22.
Why do you think this is a good fit for you?
23.
What is the most difficult situation you have ever experienced and how did you handle it?
24.
What does the word initiative mean to you?
25.
How would you measure the height of this building?
26.
What tools do you have experience working with for performing Data Analysis?
27.
How will your past experiences help you in this role?
28.
How do you handle stress?
29.
What is your priority, working quickly or producing quality work?
30.
Tell me about your previous work experience.
31.
What are some of First Derivatives' clients?
32.
How would you extract or sort specific data from a dataset with millions of rows?
33.
How will you improve the accuracy for customer query?
34.
How would you build a game user LTV model given a slice of user in-app purchase data?
35.
How do you handle pressure?
36.
Tell me about your greatest professional failure.
37.
What was the hardest SQL statement you've ever written/ dealt with?
38.
What would you do to improve our reporting and analytic capabilities?
39.
What would you do if you were sick and had a deadline to meet?
40.
What was one challenge you faced in your previous work experience?
41.
How would your friends describe you?
42.
What do you want to be doing in 5 years?
43.
How can we prevent overfitting in case of decision trees?
44.
How comfortable are you in programming in R, python and sql?
45.
How will you convince a client to give his data to you if he is not willing to?
46.
What is involved in data analysis?
47.
If you were to open a business, how would you decide what type of business would be successful?
48.
Why do you want to join Google?
49.
Tell me about a time when you handled your stress well?
50.
What type of pros do customers take interest in?
51.
How will you write a code in C++ which receives a string and shifts all the vowels present in it, to the beginning.
52.
What are three things that you want to work on in the next year?
53.
Tell me about a time when you worked in a team.
54.
What do you know about derivatives?
55.
How did you hear about this position?
56.
Tell me about a time when you failed and how did you handle it?
57.
What are your skills?
58.
Why do you want to work in the automotive industry?
59.
How do you deal with large amount of data to analyze?
60.
How would you cluster this data set?
61.
Tell me about your favorite project and the least favorite one.
62.
How did your previous experience help you get ready for this position?
63.
What obstacles have you met in your job?
64.
How did you handle your most recent problem?
65.
How many ice cubes do you need to build an igloo?
66.
Tell me about a time you have been challenged and how did you approach it?
67.
What kind of research would you like to do at Redfin?
68.
What is your dream job?
69.
How will you build a Random Forest?
70.
When are you available for a phone screen?
71.
How would you put an elephant in a fridge?
72.
What is a situation where you had to balance accuracy vs urgency?
73.
What are some of your past projects that will help you achieve in this position?
74.
What are your reasons for wanting to work here?
75.
How good are you at writing SQL queries?
76.
When did you complete your graduation?
77.
Tell me about a time when you had a conflict with someone at work, and how did you resolve it?
78.
What SQL queries have you written?
79.
What are the different types of ratios?
80.
What would you do if you got a dataset with {schema}?
81.
What is your project about?
82.
What are some significant projects you have worked on and what were the end results?
83.
What metrics would you use to gauge the "health" of Imagine Learning students?
84.
What are your expectations from this position?
85.
Tell me about a time you overcame adversity.
86.
How would you test the threshold for a 100-floor building?
87.
How will you determine if a pilot study was successful?
88.
What would you do if you have two projects and only have time to finish one?
89.
What is your expected tenure with our company?
90.
What is one project/experience that you are proud of?
91.
What is the distribution of extracting sample from two independent normal one after another.
92.
How do you keep yourself organized?
93.
What are you most proud of from your resume?
94.
Why do you want to join this team?
95.
What statistical programs do you use, and how much experience do you have in coding and programming?
96.
What three things you want me to focus on in your resume?
97.
How will you read in a csv file into R or Python?
98.
What's the most challenging project you have worked on?
99.
How do you see yourself in this role?
100.
Have you ever worked with large datasets?
101.
What is normalization?
102.
How would you hide data in Excel?
103.
Tell me a time when you were challenged as a leader and how did you handle it?
104.
What did you use to build a specific project?
105.
What do you like to do in your free time?
106.
How do you handle difficult people?
107.
What do you know about us?
108.
What is data science?
109.
What is a time you had to troubleshoot a process?
110.
What is your comfort level with Excel?
111.
Tell me about a time when you had to find an innovative solution.
112.
What can you tell us about the data set?
113.
How will you improve their product?
114.
What is your biggest weakness?
115.
How would you calculate the probability of getting at least 1 head when 3 coins are tossed?
116.
What qualities do you think are important for this position?
117.
What would you do if you worked so hard and at the end of the year everybody got promoted except you?
118.
Can you share an experience in which you were given the chance to lead a project and what's the outcome?
119.
How would you extract the months and years from dates in that dataset?
120.
Why do you think we should hire you?
121.
Why are you looking to leave your current job?
122.
What were you looking for in a company?
123.
How will you find the closed form solution of linear regression?
124.
How would you explain a box plot?
125.
What are your future goals?
126.
What is the Fast Enterprises?
127.
How would you visualize the accuracy of a classifier?
128.
What motivates you?
129.
Why did you leave your previous role?
130.
What is the difference between a join and a left join in SQL?
131.
How will you describe bayesian classifiers?
132.
How would you join two tables in pandas?
133.
How will you dedupe data in SQL?
134.
When can you start?
135.
What are the metrics you use for analyzing performance?
136.
What are the asset classes?
137.
What do you know about the job?
138.
How would you build a pivot table with the data on the sheet?
139.
Tell me about one of your past projects?
140.
What do you want to achieve in your career?
141.
How do you find the root cause?
142.
What is the default configuration needed on a CPE router that allows internal LAN traffic to be routed on to the internet?
143.
What do you know about vlookups?
144.
Are you not overqualified for this post?
145.
What makes you a good fit for the company?
146.
Why do you want to be a data analyst at Google?
147.
How do you feel about sql?
148.
What is the most difficult software you have had to learn?
149.
What are the benefits of mutual funds vs stocks?
150.
What is the probability of meeting your friend in a mall at any random day?
151.
How do you make decisions?
152.
Tell me about a time when you had to lead a group of peers.
153.
What is your experience with data management.
154.
What sort of data analysis experience do you have?
155.
What was your worst professional experience?
156.
What is the difference between public and protected methods?
157.
How was your second internship?
158.
What was your biggest mistake?
159.
How do you handle monotonous work?
160.
How do you identify X or Y in Excel?
161.
How much experience do you have with SQL?
162.
What would your previous managers say are your greatest strengths and weaknesses?
163.
How does your previous job experience help you in this job?
164.
How did you hear about Looker?
165.
What is the groupby in sql?
166.
What are your shortcomings?
167.
What is your greatest strength?
168.
How would you develop a metric that would help you determine whether company's new product is doing well?
169.
Why did you choose to study English as your first degree?
170.
What is the root cause analysis?
171.
What role do you play in a group project?
172.
Tell me about the wisest decision you ever took in your life.
173.
Why did you choose Accenture?
174.
What variables would you use to investigate the effect of a sales offer on revenue?
175.
How did you ensure the accuracy and quality of your work at previous roles?
176.
How will you structure a takeout food delivery app's database?
177.
What are the top 5 things you look for in a company?
178.
How would you explain AB test to a layman?
179.
If you can't find the answer to somebody's question and your supervisor is out of the office unavailable what do you do?
180.
Which is more important, to have work done on time or to have it done perfectly?
181.
How would you measure revenue?
182.
What statistical tests have you used most?
183.
How have you made changes and productively in your previous positions?
184.
How would you determine the price for each customer contact?
185.
What do you know about asset seizure?
186.
Tell me about a time when you had to work with someone difficult.
187.
How do you compress files in Linux?
188.
How would you estimate the number of cars on the street in Boston?
189.
Tell me about yourself, why data analysis?
190.
What kind of data have you worked with?
191.
What projects have you worked on that are related to this position?
192.
What about your salary expectations?
193.
What was the biggest disappointment you've experienced?
194.
What are your three biggest weaknesses?
195.
How do you handle the deadline for multiple projects?
196.
How would you create a SQL SELECT statement for a particular row?
197.
What is your work style?
198.
How would you get 5 gallons of water from a 7 gallon bucket and 4 gallon bucket?
199.
Are you willing to relocate?
200.
Why do you want to change your current job and that to for a company that has an exactly different profile then to what you have been in the company right now(previous employer)?
201.
What skills do you think are important to have as a data analyst at Google?
202.
What do you know about the financial consulting industry?
203.
Tell me about a time when you disagreed with your manager.
204.
How long do you plan to stay?
205.
What do you know about this position?
206.
What makes you a good candidate for this position?
207.
What is the difference between small and big data?
208.
What experience do you have that applies to this job?
209.
Tell me about a time when you were stuck.
210.
What is your greatest achievement?
211.
How do you handle problems at work?
212.
How do you ensure the accuracy of your results?
213.
What is the best number to reach you?
214.
What was your role in this project?
215.
What's your favorite function in Excel?
216.
How would you handle a heavy workload and conflicting priorities?
217.
Why do you want to join MSCI?
218.
What is a good manager like in your opinion?
219.
Please explain how you would use Morningstar data to begin evaluating an equity and a fund.
220.
How did you come to know about this company?
221.
Tell me about a time you had to deal with an unreasonable stakeholder.
222.
What is your experience with relational databases?
223.
What kind of job are you looking for?
224.
How would you predict consumer behavior in the industry?
225.
Have you ever had a difficult boss and how did you deal with them?
226.
How will you sort lines in a txt file by one of the columns using shell scripting?
227.
What are your interests?
228.
Tell me about your previous role.
Previous Question
Question 1 of 228
Next Question
1. What do you know about SQL?
Overview
This question is a good way to gauge a candidate's technical skills.
Overview
This question is a good way to gauge a candidate's technical skills.
Interview Expectations
Basic knowledge of SQL
Knowledge of how to use SQL
Knowledge of how to use SQL to solve problems
Sample Answer
I know how to create tables and how to use them in queries. I also know how to create indexes and how to use them in queries.