BookMyShow Analyst Interview Questions and Answers

Q1. Sql questions mostly about windows function, aggregate, using having clause in group, union vs union all, mostly basics about sql.
Add your answer
Q2. Power Bi questions - measures in powerbi, calculate, dashboard, excel vs powerbi.
Add your answer
Q3. Assesment 5 question based on sql and excel. Easy questions like second highest salary, manager salary, count a's.
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. Attend face-to-face interview.
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. How many years of work experience do you have in call audits?
Add your answer
Q3. Would you be able to audit 35 calls per day?
Add your answer
Q4. Would you be able to work under pressure and hectic shift timings?
Add your answer

Q1. Tell me about youself?
Add your answer
Q2. Would you be able to work according to shift timings?
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

Q1. About work profile
Add your answer
Q2. Rules and responsibilities of previous job
Add your answer

Q1. Achievements in previous company
Add your answer

Sql based test.. question on python

Sql based coding test

Send assignment doings MS Excel

Q1. Asked about the previous project
Add your answer
Q2. What about your roles in previous company
Add your answer

1. Tell me about yourself
2. Estimate the number of hospitals in India

1. There has been a decrease in 20% of the users in the past 3 days in online pharmacy application, what will you do now?

Q1. Salary negotiation on what were last salary and related questions
Add your answer
Q2. How soon can you join?
Add your answer
Q3. Are you holding any other offer, in case you do..they will try to match it which ideally depends on your interview.
Add your answer
Q4. Are you comfortable relocating to the office location?
Add your answer

Q1. When I initially joined my job right after college there was a point where I was constantly
Add your answer
Q2. It's a great organisation and I've learner a lot here but it's such a small company that it's difficult to find ways to move up ask yourself what makes you feel passionate or happy when you work😊
Add your answer
Q3. Opportunity great time interest must
Add your answer

Group discussion can also provide feedback to instructors on participant comprehension.