Apollo 247 Senior Data Analyst Interview Questions and Answers

Q1. About your project
Add your answer
Q2. Basic of machine learning
Add your answer
Q3. Basics of python
Add your answer
Q4. Sql joins and write a query.
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• Use INNER JOIN to return rows when there is at least one match in both tables.

• Use LEFT JOIN to return all rows from the left table, and the matched rows from the right table.

• Use RIGHT JOIN to return all rows from the right table, and the matched rows from the left table.

• Use FULL JOIN to return rows when there is a match in...read more
Answered by AI
Add your answer

Q1. What is the number of tourist per day in jaipur
Ans. 
The number of tourists per day in Jaipur varies depending on the season and events happening in the city.
• Tourist numbers fluctuate based on time of year (peak season vs off-peak season)

• Events like festivals or cultural events can attract more tourists

• Historical sites like Amer Fort and Hawa Mahal are popular attractions

• Tourist numbers can be estimated based on hotel occupancy rates and ticket sales for attractions
Answered by AI
Add your answer

Questions were tough- DP Array

Different GPOs policy were discussed

Q1. Questions were regarding Behavior
Add your answer

Q1. Tell me about yourself.
Add your answer

Q1. General ml questions
Add your answer
Q2. Coding on dataframe from kaggle
Add your answer

Q1. What is your salary
Ans. 
My salary is competitive based on my experience and qualifications.
• My salary is based on my experience, qualifications, and the market rate for data analysts.

• I have received competitive offers from other companies in the past.

• I am open to discussing salary expectations during the negotiation process.
Answered by AI
Add your answer
Q2. Expectation is ok but
Add your answer