Most Asked Data Analytics Interview Questions

What are the challenges that you face as a data analyst?

by

There are various ways you can answer the question. It might be very badly formatted data when the data isn’t enough to work with, clients provide data they have supposedly cleaned it but it has been made worse, not getting updated data or there might be factual/data entry errors. When discussing challenges faced as a … Read more

What are the best practices for data cleaning?

by

There are 5 basic best practices for data cleaning: Make a data cleaning plan by understanding where the common errors take place and keep communications open. Standardise the data at the point of entry. This way it is less chaotic and you will be able to ensure that all information is standardised, leading to fewer … Read more

Two buses running towards each other on the same track are moving at a speed of 40km/hr and are separated by 80km. A bird takes it flight from the bus A and flies towards bus B at a constant speed of 100km/hr. Once it reaches bus Y, it turns and starts flying back towards bus X. The bird keeps flying to and forth till both the buses collide. Find the distance traveled by the bird

by

The solution to the above problem can be as follows: The velocity of the two buses approaching towards each other = (40 + 40)km/hr The time taken for the buses to collide = 80km/hr = 1 hour. The total distance traveled by the bird = 100km/hr * 1 hr = 100 km. To solve this … Read more

Consider 10 stacks of 10 coins each, where each coin weighs 10 grams. But, one of the 10 stacks is defective, and this defective stack contains the coins of 9 grams each. Find the minimum number of weights needed to identify the defective stack.

by

The solution to this puzzle is very simple. You just must pick 1 coin from the 1st stack, 2 coins from the 2nd stack, 3 coins from the 3rd stack and so on till 10 coins from the 10th stack. So, if you add the number of coins then it would be equal to 55. … Read more

Q3. There are 5 lanes on a race track. One needs to find out the 3 fastest horses among the total of 25. Determine the minimum number of races to be conducted in order to find the fastest three cars.

by

Now, you can start solving the problem by considering the number of cars racing. Since there are 25 cars racing with 5 lanes, there would be initially 5 races conducted, with each group having 5 cars. Next, a sixth race will be conducted between the winners of the first 5 races to determine the 3 … Read more