Business Data Analyst Interview Questions | Glassdoor

Business Data Analyst Interview Questions

97

Business data analyst interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

Write an SQL statement to join 2 tables together

1 Answer

The answer depends on the DB schema, but the gist of it is, if you have TableA with columns C1, C2, and C3 and TableB with columns C4, C5, and C6, and you want to make sure that your join returns only the rows where the values in TableA.C3 are equal to the values in TableB.C5, then the join will look like this: SELECT * FROM TableA JOIN TableB ON (TableA.C3 = TableB.C5); That's about as generic as it can be, There are several different kinds of joins and syntaxes, but this is the idea.

No real difficult questions although there are a few short videos to watch on the website during the interview process which will give some insight into the desired employee personality types.

1 Answer

Strengths and Weakness

1 Answer

During the interview, they asked about what I had done in previous positions and then, following that description, they asked about what was involved on a deeper level and about the background of the situation, requirements and challenges.

1 Answer

Q: What are some negative things that your current coworkers would say about you?

1 Answer

Q: Assuming that you get this job and like it, what would it take for another organization to poach you / hire you away from us in another few years?

1 Answer

An expected value problem. There was a bag with $1, $5, $10 or $20 bills inside of it. The question was four parts, each of which asked for the expected value of the bill you would pull out of the bag. Each part added a twist, such as if you had the option to pull a bill out, put it aside and try again would you, and when would you not? Relatively simple stuff.

Based on prior experience and SQL skills, Data Analyst might have more scope to grow here with this particular role.

110 of 97 Interview Questions