DotPe Senior Business Consultant Interview Questions and Answers

Q1. Related to Role and CV
Add your answer

Q1. With the client. Current roles and responsibility and technical.
Add your answer

10 questions - 45minutes

Q1. SQL joins based questions
Add your answer
Q2. Excel VLOOKUP function
Add your answer

Q1. Asked different variety of puzzles
Add your answer

There were 10 questions and we were given 30 mins to solve them , questions were medium to hard level mcq

Question based on Probability , Logic (Puzzles) , Statistics

Q1. Question based on Logic(Puzzles) , mostly Statistics
Add your answer
Q2. Explain Anova Test with real time example
Ans. 
Anova Test is used to compare means of three or more groups.
• Anova stands for Analysis of Variance

• It is used to determine if there is a significant difference between the means of three or more groups

• It compares the variance within groups to the variance between groups

• Real-time example: An Anova test can be used to compare the average salaries of employees in different departments of a company
Answered by AI
View 1 more answer

We have given 12 puzzles on hackerearth based on probability and statistics and have to solve in 45 minutes

Q1. There is a biased dice with the probability of 1 and 2 is 25% each. Find the probability of even number.
Ans. 
The probability of rolling an even number on a biased dice with 25% chance for 1 and 2 is 50%.
• The biased dice has a 25% chance for rolling a 1 and a 25% chance for rolling a 2, totaling 50% for odd numbers.

• Since there are only two odd numbers on a dice (1 and 2), the probability of rolling an even number is 50%.

• The probability of rolling an even number on a standard dice is 50% as well, since there are 3 even numbers o
Answered by AI
Add your answer
Q2. What is the pdf and pmf?
Ans. 
PDF stands for Probability Density Function and PMF stands for Probability Mass Function.
• PDF is used for continuous random variables while PMF is used for discrete random variables.

• PDF represents the probability distribution of a continuous random variable.

• PMF represents the probability distribution of a discrete random variable.

• Example: PDF can be used to calculate the probability of a random variable falling within a...read more
Answered by AI
Add your answer

Logical Reasoning Puzzles, Guesstimates, Game Features

Q1. 1. How to calculate LTV? 2. How to improve game KPIs? 3. SQL questions
Ans. 
Calculating LTV involves determining the average revenue a customer will generate over their lifetime with the company.
• Calculate average revenue per customer per month

• Determine average customer lifespan

• Multiply average revenue per customer per month by average customer lifespan to get LTV
Answered by AI
Add your answer

Q1. Data fusion pipelines creation
Add your answer
Q2. Bigquery optimisation
Add your answer

Bigquery optimisation