解释你做过的project

最常见的就是讲故事，讲你做过的analytics project。一般准备两分钟左右的故事就可以了。讲故事可以根据以下的脉络：

Q2

Tell me about a time when you had to go above and beyond the call of duty in order to get a job done.

告诉我你需要付出职责之外的努力去完成一个任务的故事。

Q3

Tell me about a time when you had too many things to do and you were required to prioritize your tasks.

告诉我你手上有很多事情要干，然后你需要排好优先次序的一个故事。

Q4

Give me an example of a time when something you tried to accomplish and failed.

给我一个当你尝试去做一件事却失败了的例子。

Q5

Give me a specific example of a time when you used good judgment and logic in solving a problem.

给我一个具体的例子——你用很好的判断和推理去解决一个问题。

Q6

Tell me about a time when you had to work under pressure or extreme conditions.

告诉我你怎么在压力很大或在很极端的条件下工作的。

Q7

Tell me about your best and/or worst team experience -- and your role in it.

告诉我你一个最好的和/或最差的团队经历。

Q8

Give an example of a difficult situation you've faced and how you handled it.

Q9

Have you ever had a disagreement with a co-worker or boss? How did you handle it?

你曾经有和同事或者老板意见不一致吗？你是如何处理这种情况的？

10

Give two examples of things you've done in previous jobs that demonstrate your willingness to work hard.

11

Some people consider themselves to be "big picture people" and others are detail oriented. Which are you? Given an example that illustrates your preference.

有些人视他们为big picture people，有些人视他们为细节控，你是哪一种？给我一个例子去解释你的选择。

12

Give me an example of a time when you solved a complex analytical problem.

给我一个你解决一个需要分析复杂问题的例子。

13

Give me an example of a time when you solved an analytical problem in an environment of ambiguity.

给我一个例子——你如何解决一个含糊不清的分析相关的问题。

技术面试问题

Technical Interview Questions

MS Excel

Basic and Intermediate Statistics

Python and R

SQL

Modelling

MS Excel

Excel是最基础的，

但是也是真正工作中很常用的，

小编和很多BA职位的人聊过，

Excel依旧是他们经常用的工具，

Excel技能没有最好，只有更好！

1

What is the default value of last parameter of VLOOKUP?

VLOOKUP最后一个默认的参数是什么？

2

What is the main limitation of VLOOKUP function?

VLOOKUP主要的缺点是什么？

3

Does VLOOKUP look up case-sensitive values?

VLOOKUP会区分大小写吗？

4

2 ways to extract unique values in excel

两个在Excel调取唯一值的方法。

5

How to find duplicates in a column?

如何在一栏里寻找重复出现的值？

6

How to insert a drop down?

如何插入下拉菜单？

7

How to sum values based on some conditions?

如何根据一些条件进行加和？

8

How to create cross tabulation in Excel?

如何在Excel里创建交叉列表？

9

What is Excel Array Formula?

什么是Excel Array Formula?

10

How to extract First Name from a full name?

如何从一个人的姓名里调取他的名？

Basic and Intermediate Statistics

统计学的重要性无须强调了，

但是如何把统计解释给一个没有统计学背景的人

比你想象中困难。

用浅显易懂的方式介绍给周围人听。

1

What is p-value?

什么是p-value？

2

How are confidence intervals constructed and how will you interpret them?

Confidence interval是如何创建的，以及你是如何解释他们的？

3

In which data types MEAN, MEDIAN and MODE are more suitable?

4

Different Types of Sampling Techniques?

不同类型的采集样本方式？

5

Difference between Cluster and Stratified Sampling?

6

When should we use T-test than Z-test?

我们什么时候应该用T-test，而不用Z-test？

7

What is the difference between R-square and Adjusted R-square?

R-square和Adjusted R-square的区别是什么？

8

How to detect outliers?

如何探测outliers?

9

Define Homoscedasticity?

什么是同方差性？

10

What is logistic regression? Or State an example when you have used logistic regression recently.

11

What is random forest?

什么是随机森林？

12

How to conduct t-test?

如何进行t-test？

13

What do you understand by the term Normal Distribution?

14

What is Interpolation and Extrapolation?

15

What is K-means? How can you select K for K-means?

什么是K-means?你如何选择K的？

16

What is the goal of A/B Testing?

A/B Testing的目的是什么？

17

How to statistically compare means between groups?

统计学里是如何比较不同组别的平均数的？

18

Explain eigenvalues and eigenvectors intuitively

请用用浅显易懂的方式解释特征值和特征向量。

Python

1

Python or R – Which one would you prefer for text analytics?

对于文本分析，你喜欢用Python还是R？

2

Write a function that takes in two sorted lists and outputs a sorted list that is their union.

请写一个function，让它包括两个整理好的列表，只输出一个合并列表。

SQL

1

How to write conditional statements (IF ELSE) in SQL?

如何在SQL里写条件语？

2

What are the common SQL data types?

SQL常见的数据类型有什么？

3

How to subset or filter data in SQL?

如何在SQL里取子集，或者筛选数据？

4

Difference between WHERE and HAVING clauses.

Where和Having语句的区别是什么？

5

Difference between Full Join and Cross Join?

如何区分full join和cross join?

6

Difference between UNION and UNION ALL

如何区分Union和Union All？

7

How to create a blank table？

8

What will be the result of the query below?

一般会写个query，问你在SQL里跑这个query得到的结果是什么？

9

Suppose you have a table named TEMP. You need to recode values of column Y, Swap values 2 and 3 in column Y

假设你有一个表格叫做TEMP，你需要重新编码Y栏的值——交换Y栏的第二个值和第三个值。如何在SQL实现？

10

Identify second maximum value？

如何在SQL里找出第二大的值？

11

Identify second maximum value by a group

如何在SQL里找出在一个组别里第二大的值？

12

Is the query below correct? If not, what's the issue?

可能会写一个query，让你判断对不对，如果不对，找出其中的错误。

Modeling

1

What is the difference between Supervised Learning an Unsupervised Learning?

2

How can outlier values be treated?

如何处理异常值？

3

How can you assess a good logistic model?

4

What are various steps involved in an analytics project?

5

During analysis, how do you treat missing values?

6

What is the difference between Bayesian Inference and Maximum Likelihood Estimation (MLE)?

7

What is Machine Learning?

什么是机器学习？

8

Is it better to have too many false negatives or too many false positives?

8月24日，10周商业分析师求职训练营了解一下？

课程基本信息

商

业

分

析

师

如果你想要从头开始扎实你的数据分析基础，或者从0开始学习数据分析，了解你不曾见过的商业指标，这一次机会你不能放弃了，商业分析师训练营动力起航，我们给你最完备的教学计划。

课程周期：10周

课程形式：Online Webinar 直播课堂 实时互动，同时提供 video 回看复习整理

课程时间：

Lecture & Lab：

Saturday：14:00 - 16:00 PT

Sunday：14:00 - 16:00 PT17:00 – 19:00 PT

TA Office Hour：

Tuesday & Thursday 17:00 – 19:00 PT

Option 1 扫描左侧二维码添加小姐姐进行个性化咨询&简历测评

Option 2 点击阅读原文，进入报名页面

Option 4 直接登陆官网 https://www.dataapplab.com/ba/

想知道更多BA面试问题？

关注我们的公众号

【每日一练】每天为大家分享Data Scientist & Business Analyst & Leetcode 面试题，希望积极寻求相关领域工作的你每天关注我们的问题并且与我们一起思考，我们将会在第二天给出答案。返回搜狐，查看更多