Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by MakeMyTrip Team. If you also belong to the team, you can get access from here

MakeMyTrip Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 824 Reviews

Filter interviews by

MakeMyTrip Data Analyst Interview Questions and Answers

Updated 19 Sep 2024

MakeMyTrip Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 19 Sep 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
No response

I was interviewed in Aug 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Calculate no of rows after join
  • Ans. 

    Calculate the number of rows after joining two datasets.

    • Count the number of rows in each dataset

    • Perform the join operation

    • Count the number of rows in the resulting dataset

  • Answered by AI
  • Q2. Split person name in excel
  • Ans. 

    Use Excel's text to columns feature to split person names into separate columns.

    • Select the column containing the full names

    • Go to the Data tab and click on Text to Columns

    • Choose 'Delimited' and select the delimiter that separates the names (e.g. space)

    • Click Finish to split the names into separate columns

  • Answered by AI

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 10 Sep 2020

I applied via LinkedIn and was interviewed in Sep 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. How your work will increase our revenue? By sharing the data we can improve our services.
  • Ans. 

    Sharing data insights can help improve services and identify revenue opportunities.

    • Analyzing customer behavior can help identify areas for improvement

    • Identifying trends in sales data can help optimize pricing strategies

    • Using data to personalize marketing efforts can increase customer engagement

    • Predictive modeling can help identify potential revenue opportunities

    • Tracking key performance indicators can help optimize busi

  • Answered by AI
  • Q2. Do you believe in the overtime if yes then why? I don believe in the rare cases we should help our team mates

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay cool and be optimistic.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate ProblemGiven an array/list of integer numbers 'CHOCOLAT ... read more
asked in Wipro
Q3. Ninja and substringsNinja has been given a string 'STR' containin ... read more
Q4. Maximum In Sliding Windows Of Size KGiven an array/list of intege ... read more
asked in Tredence
Q5. First Repeated CharacterYou are given a string 'STR' of lowercase ... read more

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Dec 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Tell me about your self?
  • Ans. 

    Experienced data analyst with a background in statistics and programming.

    • Over 5 years of experience in analyzing and interpreting complex data sets

    • Proficient in statistical software such as R and Python

    • Strong background in data visualization and reporting

    • Excellent communication and problem-solving skills

    • Previously worked on projects involving predictive modeling and machine learning

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. Do you know about BI?
  • Ans. 

    BI stands for Business Intelligence, which involves analyzing data to help organizations make informed decisions.

    • BI involves collecting, analyzing, and presenting data to help organizations make strategic decisions.

    • It includes tools like dashboards, data visualization, and reporting.

    • BI can help identify trends, patterns, and opportunities for improvement.

    • Examples of BI tools include Tableau, Power BI, and QlikView.

  • Answered by AI
  • Q2. Do you know power Query?
  • Ans. 

    Yes, Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources.

    • Power Query is a tool in Microsoft Excel used for data transformation and manipulation.

    • It allows users to import data from various sources, clean and transform it, and load it into Excel for analysis.

    • Power Query can be used to merge, append, and reshape data from different so...

  • Answered by AI

MakeMyTrip Interview FAQs

How many rounds are there in MakeMyTrip Data Analyst interview?
MakeMyTrip interview process usually has 1 rounds. The most common rounds in the MakeMyTrip interview process are Technical.
How to prepare for MakeMyTrip Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at MakeMyTrip. The most common topics and skills that interviewers at MakeMyTrip expect are Access, Data Analysis, Data Analytics, Data Management and Excel.
What are the top questions asked in MakeMyTrip Data Analyst interview?

Some of the top questions asked at the MakeMyTrip Data Analyst interview -

  1. How your work will increase our revenue? By sharing the data we can improve our...read more
  2. calculate no of rows after j...read more
  3. split person name in ex...read more

Tell us how to improve this page.

MakeMyTrip Data Analyst Salary
based on 19 salaries
₹3 L/yr - ₹10 L/yr
At par with the average Data Analyst Salary in India
View more details

MakeMyTrip Data Analyst Reviews and Ratings

based on 5 reviews

3.5/5

Rating in categories

2.3

Skill development

3.8

Work-life balance

2.8

Salary

4.1

Job security

3.7

Company culture

2.5

Promotions

2.8

Work satisfaction

Explore 5 Reviews and Ratings
Senior Software Engineer
312 salaries
unlock blur

₹13 L/yr - ₹33 L/yr

Assistant Manager
275 salaries
unlock blur

₹4.8 L/yr - ₹20 L/yr

Holiday Expert
229 salaries
unlock blur

₹0.6 L/yr - ₹6.7 L/yr

Senior Business Development Manager
219 salaries
unlock blur

₹4.5 L/yr - ₹12 L/yr

Deputy Manager
172 salaries
unlock blur

₹7 L/yr - ₹24.5 L/yr

Explore more salaries
Compare MakeMyTrip with

Cleartrip

3.4
Compare

Yatra

3.4
Compare

Goibibo

4.3
Compare

Oyo Rooms

3.3
Compare
Did you find this page helpful?
Yes No
write
Share an Interview