Mediamint Data Analyst Interview Questions and Answers

Q1. What are SQL Joins?
Ans. 
SQL Joins are used to combine rows from two or more tables based on a related column between them.
• SQL Joins are used to retrieve data from multiple tables based on a related column between them.

• Common types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Answered by AI
Add your answer
Q2. Different functions in Python numpy
Ans. 
Python numpy provides various functions for numerical operations on arrays.
• numpy.sum() - calculates the sum of array elements

• numpy.mean() - calculates the mean of array elements

• numpy.max() - returns the maximum value in an array

• numpy.min() - returns the minimum value in an array

• numpy.std() - calculates the standard deviation of array elements
Answered by AI
Add your answer

They gave me case study in interview based on that I had provide the solution.

Q1. They asked question regarding SQL, statistics and some project related questions
Add your answer

Q1. Tell me about Projects done during course
Add your answer

Q1. Talk about yourself
Add your answer
Q2. What is your professional experience
Add your answer

Simple SQL questions

Reasoning and logic base qus

Q1. About metrics like Cpc, cvr
Add your answer

Q1. Discuss about previous work
Add your answer

Q1. Basic questions about your previous experience
Add your answer

Q1. Excel and Data visualization questions. Depends on the role you are being hired for.
Add your answer

Q1. Profile Related
Add your answer
Q2. Product management
Add your answer

Q1. What are joins and how do you use it?
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

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

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. Processing speed of different scriting languages?
Ans. 
Processing speed of scripting languages varies based on factors like code complexity and optimization.
• Processing speed can vary based on the specific task being performed.

• Compiled languages like C++ tend to be faster than interpreted languages like Python.

• Optimizing code can improve processing speed.

• JavaScript can be faster than Python for certain tasks.

• Consider using libraries or frameworks optimized for performance.
Answered by AI
Add your answer