MakeMyTrip Data Analyst Interview Questions and Answers

Q1. Sql, advance Excel formulas
Add your answer

Q1. Explain Moving Average
Ans. 
Moving Average is a statistical technique used to analyze data points by creating a series of averages of different subsets of the full data set.
• Moving Average helps in smoothing out fluctuations in data to identify trends over time.

• It is calculated by taking the average of a specific number of data points within a defined window.

• For example, a 3-day moving average for stock prices would be the average of the stock pri...read more
Answered by AI
Add your answer
Q2. Explain Decorators
Ans. 
Decorators in Python are functions that modify the behavior of other functions.
• Decorators are denoted by the @ symbol followed by the decorator function name.

• They allow you to add functionality to an existing function without modifying its code.

• Common use cases include logging, timing, and authentication.

• Example: @decorator_function def function_to_decorate(): pass
Answered by AI
Add your answer
Q3. Explain Object Oriented Programming
Ans. 
Object Oriented Programming is a programming paradigm based on the concept of objects, which can contain data and code.
• OOP focuses on creating objects that interact with each other to solve complex problems.

• Objects have attributes (data) and methods (functions) that can manipulate the data.

• Encapsulation, inheritance, and polymorphism are key principles of OOP.

• Example: In a car simulation program, a 'Car' object can hav...read more
Answered by AI
Add your answer
Q4. Explain classes objects
Ans. 
Classes are blueprints for creating objects in object-oriented programming.
• Classes define the properties and behaviors of objects

• Objects are instances of classes

• Classes can inherit properties and behaviors from other classes

• Classes can have constructors to initialize objects

• Classes can have methods to perform actions
Answered by AI
Add your answer
Q5. Explain Functions
Ans. 
Functions are blocks of code that perform a specific task and can be reused multiple times in a program.
• Functions help in organizing code and making it more modular.

• They can take input parameters and return output values.

• Functions can be called multiple times from different parts of the program.

• Examples: summing two numbers, finding the maximum value in a list.
Answered by AI
Add your answer
Q6. Pandas and Numpy
Add your answer
Q7. Swap L1 and L5 in a list
Ans. 
Swap L1 and L5 in a list
• Create a temporary variable to store the value of L1

• Assign the value of L5 to L1

• Assign the value of the temporary variable to L5
Answered by AI
Add your answer

Duration - 1hr, Mostly questions are from Excel and SQL ( But a little knowledge of R and Python is very useful) .For me, it's knowing the concepts and answering no codes were ask to write.

Q1. Basic 1-on-1 round with your manager/ or any senior from the company
Add your answer

Q1. They will ask about your profile and past experience.
Add your answer

Q1. A peer level colleague will ask some basic knowledge check questions
Add your answer

This is literally a live coding test. For analytics expect SQL, python, R.

Q1. Interviewed by a manager of another team
Add your answer

Q1. Interviewed by dotted line reporting manager
Add your answer

Q1. Cross functional interview
Add your answer

Q1. Core Values Interview
Add your answer

Q1. How to sort ararat
Ans. 
Ararat can be sorted alphabetically or numerically.
• Sort alphabetically: Arrange in ascending order based on the letters in the word.

• Sort numerically: Arrange in ascending order based on the numerical value of each character.
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. About the industry
Add your answer

The test had 2 sql questions that you needed to solve and other general aptitude questions

Q1. Case Study round : How will you solve an issue with low number of likes received on a tech platform
Ans. 
To increase likes on a tech platform, I would focus on improving content quality, engaging with users, and utilizing data analytics.
• Analyze user engagement data to understand preferences and trends

• Create high-quality and relevant content to attract users

• Engage with users through interactive posts, contests, and polls

• Collaborate with influencers or partners to reach a wider audience

• Utilize targeted advertising to promot
Answered by AI
Add your answer

Q1. Case study round to understand how email marketing works
Add your answer