Subway Data Analyst Interview Questions and Answers

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

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

1 dsa question 2 sql queries questions on data analysis

Q1. Sql query using window function
Ans. 
Using window functions in SQL to perform calculations within a specific subset of data.
• Window functions are used to perform calculations across a set of rows related to the current row.

• Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().

• Example: SELECT employee_id, salary, AVG(salary) OVER (PARTITION BY department_id) AS avg_salary FROM employees;
Answered by AI
Add your answer
Q2. Dsa question of string manipulation
Add your answer

Q1. Sql query advanced level
Add your answer
Q2. Guesstimate and resume questions
Add your answer

Q1. Basic common HR questions
Add your answer
Q2. Questions about educational background cultural fit
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

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. This interview is in person interview. Interview is usually conducted by Tech lead and manager. They mostly focus on you Tech Stack. Majority of SQL questions were basen on aggregate function. And data war...read more
Add your answer

Q1. This round is virtual and mainly focuses on basic technical questions along with HR discussion.
Add your answer

How to improve the customer experience in OYO and How to maximise the business impact for a hotel

Scrape data from booking.com for Bangalore hotels for 10th Dec’19 to 15th Dec’19 and create a dashboard for OYO Vs Non-OYO hotels comparison!!

Q1. Tell me about your Salary Expectations
Add your answer
Q2. When can I join OYO and what are the relocation help is needed
Add your answer

Q1. About the views
Add your answer
Q2. About dulplicaye in a table
Add your answer