Mapup Junior Data Analyst Interview Questions and Answers

Q1. Calculate no of rows after join
Ans. 
Calculate the number of rows after joining two datasets.
• Count the number of rows in each dataset

• Perform the join operation

• Count the number of rows in the resulting dataset
Answered by AI
Add your answer
Q2. Split person name in excel
Ans. 
Use Excel's text to columns feature to split person names into separate columns.
• Select the column containing the full names

• Go to the Data tab and click on Text to Columns

• Choose 'Delimited' and select the delimiter that separates the names (e.g. space)

• Click Finish to split the names into separate columns
Answered by AI
Add your answer

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

The aptitude questions were bit easy and there were questions about SQL, and also excel sheets.

Q1. Questions about sql
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