Ihg Group Senior Analyst Interview Questions and Answers

Q1. How do we analyze road traffic?
Ans. 
Road traffic can be analyzed using various data sources and techniques to understand patterns, trends, and optimize traffic flow.
• Collecting data from traffic cameras, sensors, GPS devices, and mobile apps

• Analyzing traffic volume, speed, congestion, and accidents

• Using data visualization tools to create maps, charts, and dashboards for insights

• Implementing predictive modeling to forecast traffic patterns and optimize rou...read more
Answered by AI
Add your answer
Q2. Using graph network.
Add your answer

Hackerrank - SQL and Statistics

How to make a regression model

Q1. What was the definition of false positive and false negative
Ans. 
False positive and false negative are terms used in data analysis to describe errors in classification models.
• False positive refers to a situation where a test result incorrectly indicates the presence of a condition or attribute.

• False negative refers to a situation where a test result incorrectly indicates the absence of a condition or attribute.

• In medical field, false positive can occur when a healthy person is wrong...read more
Answered by AI
Add your answer

Q1. What are the use cases of self-join?
Ans. 
Self-join is used to join a table with itself to compare rows within the same table.
• Used to compare rows within the same table

• Helps in retrieving hierarchical data

• Can be used to find employees who report to the same manager
Answered by AI
Add your answer
Q2. How to extract nth highest salary?
Add your answer
Q3. What are the critical KPIs to be monitored after creating a new website?
Ans. 
Critical KPIs to monitor after creating a new website include traffic, conversion rate, bounce rate, and user engagement.
• Traffic: Monitor the number of visitors to the website to gauge its reach and popularity.

• Conversion Rate: Track the percentage of visitors who take a desired action, such as making a purchase or signing up for a newsletter.

• Bounce Rate: Measure the percentage of visitors who leave the website after vi...read more
Answered by AI
Add your answer
Q4. What would be the probability of getting at least one six after throwing 2 unbiased dice?
Ans. 
The probability of getting at least one six after throwing 2 unbiased dice is 11/36.
• The total number of outcomes when throwing 2 dice is 36 (6 sides on each die)

• The number of outcomes where at least one die shows a six is 11 (6 outcomes where one die shows a six, plus 1 outcome where both dice show sixes)
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

SQL questions and logical reasoning

Q1. Talked about resume, projects and general questions of maths and logical reasoning
Add your answer

A guesstimate and a case study on profitability

Guesstimate and behavioral question

Q1. Basic discussion around your experience
Add your answer
Q2. Last internship or college extra currics
Add your answer