Experienced data analyst Interview Questions

5

Experienced Data Analyst interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
Guidehouse
Data Scientist - Data Analyst - Experienced Associate was asked...24 October 2019

You have 8 marbles and a balance scale. One marble weighs more than the others, but you don’t know which one. How can you identify the heavier marble using only two weighs of the balance scale?

2 Answers

We put 3 marbles on each side of the scale for a total of 6 marbles that are being weighed. We leave 2 marbles off the scale. Then, we compare the 6 marbles… There are two possible outcomes: If one side is heavier than the other then we only have 3 marbles left. Then, in the second weighing, we can compare 2 of those 3 marbles to each other. If they are the same weight, then the 3rd is the heaviest. If one is heavier than the other, then we’ve succeeded in just two weighings. If, when comparing the 6 marbles, we find that both sides are equal, then we know that the heaviest marble has to be in the 2 marbles that are not on the scale. This means that we only have to compare on those 2 remaining marbles and we have the heaviest marble in only two weighings. Less

I wonder how they grade you if you use the simpler but slightly less effective method of going 4x4, then 2x2, then 1x1. Less

Guidehouse

How would you predict the number of shoes Nike will sell next month in New York?

1 Answers

Historical trends, break the question by customer group, etc.

Guidehouse

The average high temperature for x days is 70 degrees. the next day has a high temperature of 84 degrees, which raises the overall average to 72 degrees. what is the value of x

1 Answers

Setup problem: (70x + 84) / (x + 1) = 72 Solve for X -> 70x + 84 = 72x + 72 70x + 12 = 72x 12 = 2x 6 = x Less

Guidehouse

You're going to open up a coffee shop that produces nothing but cups of coffee. It will cost you $10,000 to set up the shop. It will then cost you $1 per cup to brew coffee, which includes operational costs for your shop. You will sell your cups of coffee for $1.50 per cup. and you can assume that every cup you brew will be sold. Ignoring the time-value of money, how many cups will you have to sell to break even?

1 Answers

$10,000 / ($1.50-$1) = 20,000 cups

PwC

difference between primary and unique key . clustered and non clustered index . how to avoid cursors. how will you optimize the query . While loop in sql

Viewing 1 - 5 of 5 Interview Questions