Rapido Data Analyst Interview Questions and Answers

Approx 30 questions which are to be solved in 1 hour. Questions include logical and mathematical questions along with basic ML and stats questions

Q1. Basic questions related to Python and SQL
Add your answer

Q1. Advance SQL questions and 1 case study
Add your answer

Q1. Basic ML questions and Business acumen questions
Add your answer

Basic Apititude Questions

Q1. Difference between WHERE and HAVING??
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before data is grouped, HAVING is applied after data is grouped

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP B
Answered by AI
Add your answer
Q2. Where- Row Level Filters Having-Aggregate Filters
Ans. 
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
• Row level filters are used to filter individual rows of data before any aggregations are performed.

• Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

• Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...read more
Answered by AI
Add your answer

Q1. Why do you wanna join Uber?
Add your answer
Q2. Best Company Ever
Add your answer

It was basic MCQ related to Javascript

Q1. Asked basic questions related to array and SQL
Add your answer

Q1. Asked question to test the business context
Add your answer

It was easy consisting of sql and excel questions

Q1. How do you setup a Dark Store?
Ans. 
Setting up a Dark Store involves converting a retail store into a fulfillment center for online orders.
• Select a suitable location for the Dark Store, preferably in a centralized area with good access to transportation.

• Optimize the layout of the store for efficient picking, packing, and shipping of orders.

• Implement inventory management systems to track stock levels accurately and prevent stockouts.

• Train staff on order f...read more
Answered by AI
Add your answer
Q2. How do joins work in the simplest manner?
Ans. 
Joins combine data from two or more tables based on a related column.
• Joins are used to retrieve data from multiple tables based on a related column

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer
Q3. Write a basic query explaining the order of execution?
Ans. 
The order of execution in a query determines the sequence in which operations are performed.
• 1. The order of execution in a query typically follows the sequence: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

• 2. The FROM clause specifies the tables involved in the query.

• 3. The WHERE clause filters the rows based on specified conditions.

• 4. The GROUP BY clause groups the rows that have the same values into summary rows.

• 5...read more
Answered by AI
Add your answer
Q4. Difference between Group By and Distinct?
Ans. 
Group By is used to aggregate data based on a specific column, while Distinct is used to remove duplicate rows from a result set.
• Group By is used with aggregate functions like COUNT, SUM, AVG, etc.

• Distinct is used to retrieve unique values from a column or set of columns.

• Group By can be used to group data based on multiple columns, while Distinct operates on individual columns only.
Answered by AI
Add your answer

Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing

1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day

Q1. About previous experience situation based questions excel problem solving
Add your answer
Q2. Tell me about yourself difference between data quality and data validity
Add your answer