AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Expedia Group
Compare
Filter interviews by
Expedia Group Data Analyst Intern Interview Questions and Answers
Expedia Group Data Analyst Intern Interview Experiences
1 interview found
Anonymous
I applied via campus placement at Birla Institute of Technology and Science (BITS), Pilani and was interviewed in Dec 2023. There were 2 interview rounds.
The first round was a 45 min long aptitude and case study round which involved basic aptitude questions along with certain cases like "There has been a drop off in customers booking a hotel though the the total number of visits to the site has not dropped. How would you you design a system to analyze the problem and what kind of data will you collect." It was followed by a couple of HR questions
A mock data set of hotel bookings in different countries for last two years were given a week prior to the interview. We were to clean, prepare, derive insights and recommend actions. All of this needed to be documented as 15 page presentation. This presentation then needed to be presented in a 45 min meet.
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed in Aug 2023. There were 3 interview rounds.
Aptitude Test had questions on sql, analytic ques, case study ques on uber
(5 Questions)
- Q1. What are Sql joins, window functions
- Ans.
SQL joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.
SQL joins are used to retrieve data from multiple tables based on a related column between them (e.g. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN).
Window functions are used to perform calculations on a set of rows related...
- Q2. Write sql queries
- Ans.
Answering SQL queries in an interview for Data Analyst Intern position
Understand the database schema and tables involved
Use SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY clauses
Practice writing queries for common data analysis tasks like filtering, aggregating, and joining tables
- Q3. Given 5L and 3L jar. How will you make it 4L (Logical thinking)
- Q4. Questions on resume projects
- Q5. Questions on excel functions
Here they given three case study questions of uber where they would like to check you analytic behavior, they want to know how would you use the data to solve such a problem.
Interview Preparation Tips
- SQL
- MySQL
- Excel
Skills evaluated in this interview
(1 Question)
- Q1. How do you evaluate logistic regression model?
- Ans.
Logistic regression model evaluation involves assessing its performance using metrics like accuracy, precision, recall, and F1 score.
Evaluate model performance using metrics like accuracy, precision, recall, and F1 score.
Use confusion matrix to calculate true positives, true negatives, false positives, and false negatives.
Calculate accuracy as (TP + TN) / (TP + TN + FP + FN).
Calculate precision as TP / (TP + FP).
Calcul...
Using SQL to write a window function (Ranking).
Skills evaluated in this interview
Hazelwood
I was interviewed before Feb 2024.
(3 Questions)
- Q1. They asked me two das questions one is medium and second one is hard..
- Q2. They asked me about Sliding window techniqur and gave a problem to solve
- Q3. They ask u about ur projects
SQL - shared question on the screen and asked to code in SQL
(1 Question)
- Q1. Nth highes salary
I applied via LinkedIn and was interviewed before Jun 2023. There was 1 interview round.
SQL test on hackerrank
Interview Preparation Tips
I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed in Aug 2023. There were 3 interview rounds.
Aptitude Test had questions on sql, analytic ques, case study ques on uber
(5 Questions)
- Q1. What are Sql joins, window functions
- Ans.
SQL joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.
SQL joins are used to retrieve data from multiple tables based on a related column between them (e.g. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN).
Window functions are used to perform calculations on a set of rows related...
- Q2. Write sql queries
- Ans.
Answering SQL queries in an interview for Data Analyst Intern position
Understand the database schema and tables involved
Use SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY clauses
Practice writing queries for common data analysis tasks like filtering, aggregating, and joining tables
- Q3. Given 5L and 3L jar. How will you make it 4L (Logical thinking)
- Q4. Questions on resume projects
- Q5. Questions on excel functions
Here they given three case study questions of uber where they would like to check you analytic behavior, they want to know how would you use the data to solve such a problem.
Interview Preparation Tips
- SQL
- MySQL
- Excel
Skills evaluated in this interview
I applied via Job Portal and was interviewed in Nov 2024. There were 3 interview rounds.
SQL and Python coding test
(2 Questions)
- Q1. Bagging vs Boosting
- Q2. Overfitting and Underfitting in GBDT
(2 Questions)
- Q1. Questions on Recent project
- Q2. Deep Learning vs classical ML
Selected
I was interviewed in Dec 2023.
English, number system, grammar
Python , data science, machine learning
Python machine learning, natural language precossing
(4 Questions)
- Q1. Python , Data Science, SQL
- Q2. What is python basics, libraries
- Ans.
Python basics include syntax, data types, and control structures. Libraries like NumPy, Pandas, and Matplotlib enhance data analysis and visualization.
Python basics cover syntax, variables, data types, and control structures.
NumPy is a library for numerical computing, providing powerful array operations.
Pandas is a library for data manipulation and analysis, offering data structures like DataFrames.
Matplotlib is a libr...
- Q3. Data science algorithms , and theory
- Q4. Sql querys, cluases
Indian environment, village, college days
(1 Question)
- Q1. Python, data science
(1 Question)
- Q1. Write SQL to print the user with the highest restaurant order. There are couple of joins to be used.
- Ans.
Use SQL with joins to find user with highest restaurant order
Use JOIN to connect user table with order table
Group by user and sum the order amounts
Order by sum in descending order and limit to 1 result
Statistical Analysis related questions
Skills evaluated in this interview
Expedia Group Interview FAQs
Tell us how to improve this page.
Expedia Group Interviews By Designations
- Expedia Group Software Developer Intern Interview Questions
- Expedia Group Software Developer Interview Questions
- Expedia Group Senior Software Engineer Interview Questions
- Expedia Group Software Development Engineer II Interview Questions
- Expedia Group Software Engineer Interview Questions
- Expedia Group Software Engineer III Interview Questions
- Expedia Group Data Engineer Interview Questions
- Expedia Group Data Engineer 2 Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Data Science Engineer Interview Questions
- Show more
Expedia Group Data Analyst Intern Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Development Engineer II
191
salaries
|  ₹15.6 L/yr - ₹40 L/yr |
|
Software Development Engineer
91
salaries
| ₹12 L/yr - ₹36 L/yr |
|
Software Development Engineer 3
73
salaries
| ₹27 L/yr - ₹55 L/yr |
|
Software Developer
66
salaries
| ₹10 L/yr - ₹41.8 L/yr |
|
Software Engineer
56
salaries
| ₹12 L/yr - ₹37 L/yr |
MakeMyTrip
Yatra
Cleartrip
Goibibo
- Home >
- Interviews >
- Expedia Group Interview Questions >
- Expedia Group Data Analyst Intern Interview Questions
