Business data analyst ii Interview Questions | Glassdoor

# Business data analyst ii Interview Questions

223

business data analyst ii interview questions shared by candidates

## Top Interview Questions

Sort: RelevancePopular Date

Apr 25, 2015
 Phone Interview #2 You are playing a game of baseball. There are two outs in the bottom of the ninth, and you are down by one run. You are currently a baserunner on first base. [Obviously, you must score or else the game ends]. A)You are trying to figure out if you should steal second base or not. What kind of information do you need to know to inform this decision? B) Every batter in your lineup has identical odds.They get a single 50% of the time and they strike out 50% of the time. If you are on first base, you cannot score on a single. If you are on second, you are guaranteed to score on a single. You successfully steal 75% of the time. Should you steal? [I may be missing some of the nonsense here, but this is all the relevant information] C) It turns out the pitcher acts a bit differently with a runner on second [regardless of who the batter is] and no other runners on base. Under these circumstances, he is 50% to strike them out, 40% to surrender a walk, and 10% to surrender a hit. How does this change things/ should you steal?3 AnswersA) Ultimately, you need to know the odds of you scoring without stealing, the odds of you scoring if you successfully steal, and the odds of successfully stealing. There are other factors, but this is what it all ultimately boils down to. B) Odds of you scoring when attempting to steal are .75*.5 = .325. Odds of you scoring waiting for two successful base hits [whats required] are .5*.5 =.25. You should steal. C) You're still .25 to score hoping for two hits in a row. Stealing now changes the equation to .75(.1+.4(.5)) because you need steal+hit or steal+walk+hit = .75(.3) = .225. You should not steal.(C) is not as straightforward as the previous answer suggests. After a hit, are you on 3rd or 2nd? How does that change the probability for the pitcher/hitter? All things considered, you should still steal. You have the following scenarios in which you score: Steal&Hit or Steal&Walk&Hit or Steal&Walk&Walk&Hit or Steal&Walk&Walk&Walk. In all of these scenarios, a runner reaches 2nd, so our new probabilities are used. The final prob should be %16.5. If you don't steal, you have these scenarios: Hit(.50 prob) &Hit(.10 prob assuming 2nd & 3rd baserunners have same impact) or Hit&Walk&Hit or Hit&Walk&Walk&Hit or Hit&Walk&Walk&Walk. This yields prob of %11, given that baserunners in scoring position are the cause of the new probability, not just on second. Again, these would be things to clarify in the interviewTo the more recent post: No the original answer is correct. If there's a hit the runner from 2nd scores, a runner on 1st goes to 2nd. There's no such thing as a Steal-Walk-Walk because this pitcher's oddity only applies when there's a runner on 2nd and nobody else on base.

Jul 9, 2015
 past experience, career objectives, skills2 Answersanswered all of questions in order.What specific SQL Qs did they ask?

Jul 9, 2016

Dec 10, 2019
 How many quarters at any given time are in a shopping mall how where are they located?2 Answersquarters = the places where someone or something lives quarters are directly related to the potential customers nearbyquarters = the places where someone or something lives , quarters are directly related to the potential customers nearby

Apr 5, 2019

Mar 4, 2011
 Describe your experience with databases?1 AnswerEvery database is unique in relation to its subject matter(data). I have found out that relational databases are more efficient to deal with than flat file based databases like excel. I have also experienced that the size of the database does not affect its input output performance. What really affect performance is how the database is modeled and the presence or absence of database objects like indexes, referential integrity, well tuned SQL queries and the number of database users. Transactional databases may be slower than reporting databases because of the constant input of data from different data sources. We can talk about normalization and online analytical processing( OLAP) or online transactional process(OLTP). How does normalization affect these two concepts? We can also talk about our experience with database users, DBMS, security, data sources and so on depending on what the interview wants to know.

Jan 19, 2016
 Do you have experience in Data Modeling?1 AnswerThey are building up the Manila team in order to save costs, which will lead to job losses in both the UK & US. They have already set up an actuarial processing centre in Cyprus.

Nov 4, 2009
 Write an SQL statement to join 2 tables together1 AnswerThe 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.