Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Login

Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

OYO Data Analyst Interview Questions

OYO Data Analyst Interview Questions

Target job roles – Business Analyst, Data Analyst, Data Scientist, Business Intelligence Engineer, Product Analyst, Machine Learning Engineer, Data Engineer

Target Companies – FAANG and only product-based companies

CTC offered –
12 to 20 LPA for Level 1 (0 to 4 YOE)
20 to 35 LPA for Level 2 (Senior level – 4 to 7 YOE )
35 to 50 LPA for Level 3 (Team Lead or Manager – 7 to 9 YOE)
50 to 80 LPA for Level 4 (Manager or Senior Manager – 9 to 12 YOE)


Tools and Technologies required
SQL – 9/10
Python – 7/10
Visualization tool (Power BI or Tableau) – Good to have
Machine Learning Algorithm – Expert in at least a couple of algorithms (if going for Data Science role)

OYO Data Analyst Interview Questions

Why The Data Monk?

We are a group of 30+ people with ~8 years of Analytics experience in product-based companies. We take interviews on a daily basis for our organization and we very well know what is asked in the interviews.
Other skill enhancer website charge 2lakh+ GST for courses ranging from 10 to 15 months.

We only focus on making you a clear interview with ease. We have released our Become a Full Stack Analytics Professional for anyone in 2nd year of graduation to 8-10 YOE. This book contains 23 topics and each topic is divided into 50/100/200/250 questions and answers. Pick the book and read it thrice, learn it, and appear in the interview.

We also have a complete Analytics interview package
2200 questions ebook (Rs.1999) + 23 ebook bundle for Data Science and Analyst role (Rs.1999)
4 one-hour mock interviews, every Saturday (top mate – Rs.1000 per interview)
4 career guidance sessions, 30 mins each on every Sunday (top mate – Rs.500 per session)
Resume review and improvement (Top mate – Rs.500 per review)

Total cost – Rs.10500
Discounted price – Rs. 9000


How to avail of this offer?
Send a mail to [email protected]

OYO Data Analyst Interview Questions
OYO Data Analyst Interview Questions

OYO Data Analyst Interview Questions

Company – OYO
Designation – Data Analyst

Year of Experience required – 0 to 4 years
Technical expertise – SQL, Python, Case Study, and Statistics
Salary offered – 10 to 18 LPA (no Stocks, 10% variable) – 80% hike

Number of Rounds – 4

OYO SQL Interview Questions

There were 10+ SQL questions, 6-7 easy/theoretical , a couple of medium problem and 1 hard problem.
The hard problem was picked directly from Hacker Rank, so practice all the problems.
The medium difficulty problems were like the one give below:

You have data on people have applied for a lottery ticket. The data consists of their name and ticket number. You have to choose winners by selecting the people present in the alternate rows (the first winner starting from row number 3). Write a query to make things easy to select the winners.

select *
from (select name, ROW_NUMBER() over (order by ticket_no) as srNo
from db) t
where (t.srNo % 2) = 1

Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).
Select name
From students
Where lower(gender) in (‘male’,’m’)
Or lower(address) = ‘%mumbai%’

Can you join two table without any common column?
Yes we can do cross join without any common column.
Eg: We have Roll Number, Name of Students in Table A and their Class (let’s say 5th) in Table B.
21
We will use cross join to append class against each student.

SELECT B.CLASS,A.ID,A.NAME
FROM A, B
WHERE 1=1


Select case when null=null then ‘Amit’ else ‘Rahul’ end from dual. What will be the output of the above query?
The Null value has a memory reference.2 Null values cannot have same memory Reference. So output will be ‘Rahul’.

List the different types of relationships in SQL.
There are different types of relations in the database:
One-to-One – This is a connection between two tables in which each record in one table corresponds to the maximum of one record in the other.
One-to-Many and Many-to-One – This is the most frequent connection, in which a record in one table is linked to several records in another.
Many-to-Many – This is used when defining a relationship that requires several instances on each sides.
Self-Referencing Relationships – When a table has to declare a connection with itself, this is the method to employ.

What are the differences between OLTP and OLAP?
OLTP stands for online transaction processing, whereas OLAP stands for online analytical processing. OLTP is an online database modification system, whereas OLAP is an online database query response system.

What is the usage of the NVL() function?
You may use the NVL function to replace null values with a default value. The function returns the value of the second parameter if the first parameter is null. If the first parameter is anything other than null, it is left alone.


We have put all the 250 most asked questions in our SQL Interview Questions e-book. Do check it out

OYO Case Study Questions

Case Study – Suggest as many important KPIs as possible that you want to put on the CXOs dashboard

Following were the suggested KPIs

  1. Average Daily Rate (ADR)
  2. Occupancy rate
  3. Revenue per Available Room (RevPAR)
  4. Gross Operating Profit per Available Room (GOPPAR)
  5. Average Length of Stay (ALOS)
  6. Customer Acquisition Cost (CAC)
  7. Customer Lifetime Value (CLV)
  8. Net Promoter Score (NPS)
  9. Online Reputation Score (ORS)
  10. Room Revenue Contribution by Channel
  11. Website Conversion Rate
  12. Direct Booking Ratio
  13. Repeat Guest Ratio
  14. Housekeeping Productivity Ratio
  15. Employee Turnover Rate
  16. Revenue per Employee (RPE)
  17. Cost per Occupied Room (CPOR)
  18. Cost per Available Room (CPAR)
  19. Total Revenue by Property
  20. Total Expenses by Property

We have 100 case studies and guesstimate completely solved that are repeatedly asked in Analytics Interview. Do check out.

OYO Statistics and Python Interview Questions

I had a couple of projects on Machine Learning, so a few questions were asked on statistics

1.What is Skewness? 

  • Skewness is a measure of the asymmetry of a distribution. This value can be positive or  negative. 
  • A negative skew indicates that the tail is on the left side of the distribution, which extends  towards more negative values. 
  • A positive skew indicates that the tail is on the right side of the distribution, which extends  towards more positive values. 
  • A value of zero indicates that there is no skewness in the distribution at all, meaning the  distribution is perfectly symmetrical. 

2. What is Kurtosis? 

Kurtosis is a measure of whether or not a distribution is heavy-tailed or light-tailed relative to  a normal distribution.

• The kurtosis of a normal distribution is 3. 

• If a given distribution has a kurtosis less than 3, it is said to be platykurtic, which means it  tends to produce fewer and less extreme outliers than the normal distribution. 

• If a given distribution has a kurtosis greater than 3, it is said to be leptokurtic, which means it  tends to produce more outliers than the normal distribution. 

3.How are covariance and correlation different from one another? 

Covariance measures how two variables are related to each other and how one would vary  with respect to changes in the other variable. If the value is positive, it means there is a direct  relationship between the variables and one would increase or decrease with an increase or decrease  in the base variable respectively, given that all other conditions remain constant. 

Correlation quantifies the relationship between two random variables and has only three specific  values, i.e., 1, 0, and -1. 

1 denotes a positive relationship, -1 denotes a negative relationship, and 0 denotes that the two  variables are independent of each other. 

4.What is Multicollinearity ? 

Multicollinearity occurs when two or more independent variables are highly correlated with  one another in a regression model. This means that an independent variable can be predicted from  another independent variable in a regression model.

5.What is VIF? 

Variance inflation factor (VIF) is a measure of the amount of multicollinearity in a set of  multiple regression variables. In general, a VIF above 5 indicates high correlation and is cause for  concern. Some authors suggest a more conservative level of 2.5 or above and it depends on the  situation. 

6.What is a confusion matrix and why do you need it? 

Confusion matrix is a table that is frequently used to illustrate the performance of a  classification model i.e., classifier on a set of test data for which the true values are well-known. It  allows us to visualize the performance of an algorithm/model. It allows us to easily identify the  confusion between different classes. It is used as a performance measure of a model/algorithm. It is  summary of predictions on a classification model. 

7.What do you mean when you say “Strings are immutable”?

Strings in Python are immutable i.e you can not change the defined string.

You can not change a part of the string, as it is immutable.

8.Are lists mutable ?
Lists are mutable i.e. you can change the values already present in the list.

9.Is dictionary zero indexed? Can we pull something like Team[0] from the above example?

The whole purpose of having a dictionary is  that you can have your own index i.e. key. So, to answer the question, Dictionary is not zero indexed.

You can not use the basic index thing example, you can not use Team[0] to pull the first value because you have already specified an index to all the values

10.What is the function range() ?

Range(10) will get you numbers from 0 to 9. But you need to put this range in some data type. Suppose you want to put this in a list.

There were a 2-3 more questions on Python, mostly around for loop and pattern printing.

All the questions asked above and in 50+ Analytics companies are covered head to toe in our 2200 Interview Questions to become full stack Analytics Professional book. Do check out

The Data Monk Product and Services

  1. Youtube Channel covering all the interview-related important topics in SQL, Python, MS Excel, Machine Learning Algorithm, Statistics, and Direct Interview Questions
    Link – The Data Monk Youtube Channel
  2. Website – ~2000 completed solved Interview questions in SQL, Python, ML, and Case Study
    Link – The Data Monk website
  3. E-book shop – We have 70+ e-books available on our website and 3 bundles covering 2000+ solved interview questions
    Link – The Data E-shop Page
  4. Mock Interviews
    Book a slot on Top Mate
  5. Career Guidance/Mentorship
    Book a slot on Top Mate
  6. Resume-making and review
    Book a slot on Top Mate 

The Data Monk e-book Bundle 

1.For Fresher to 7 Years of Experience
2000+ interview questions on 12 ML Algorithm,AWS, PCA, Data Preprocessing, Python, Numpy, Pandas, and 100s of case studies

2. For Fresher to 1-3 Years of Experience
Crack any analytics or data science interview with our 1400+ interview questions which focus on multiple domains i.e. SQL, R, Python, Machine Learning, Statistics, and Visualization

3.For 2-5 Years of Experience
1200+ Interview Questions on all the important Machine Learning algorithms (including complete Python code) Ada Boost, CNN, ANN, Forecasting (ARIMA, SARIMA, ARIMAX), Clustering, LSTM, SVM, Linear Regression, Logistic Regression, Sentiment Analysis, NLP, K-M

About TheDataMonkGrand Master

I am the Co-Founder of The Data Monk. I have a total of 6+ years of analytics experience 3+ years at Mu Sigma 2 years at OYO 1 year and counting at The Data Monk I am an active trader and a logically sarcastic idiot :)

Follow Me