AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
MASAI School
Compare
Filter interviews by
MASAI School Data Analyst Interview Questions and Answers
MASAI School Data Analyst Interview Experiences
2 interviews found
Anonymous
(5 Questions)
- Q1. It is related to SQL, Python, and Excel
- Q2. Not Remember the interview questions exactly
- Q3. What is grouped by in SQL
- Ans.
In SQL, data is grouped by a specified column or expression using the GROUP BY clause.
Data is grouped based on the values in the specified column or expression
Aggregate functions like SUM, COUNT, AVG can be used with GROUP BY to perform calculations on each group
GROUP BY is often used in conjunction with the SELECT statement
Example: SELECT department, AVG(salary) FROM employees GROUP BY department
- Q4. List and dictionary differences
- Ans.
Lists are ordered collections of items, while dictionaries are unordered collections of key-value pairs.
Lists are accessed by index, dictionaries are accessed by key
Lists maintain the order of elements, dictionaries do not guarantee order
Lists use square brackets [], dictionaries use curly braces {}
Example: list - [1, 2, 3], dictionary - {'a': 1, 'b': 2}
- Q5. Lambda functions in python
- Ans.
Lambda functions are anonymous functions in Python that can have any number of arguments but only one expression.
Lambda functions are defined using the lambda keyword.
They are commonly used for small, one-time tasks.
Lambda functions can take any number of arguments, but can only have one expression.
Example: add = lambda x, y: x + y
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed before Oct 2023. There were 2 interview rounds.
Around sql/python and other da tools
Stats and probability with focus on puzzles
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.
(2 Questions)
- Q1. The first round of interviews was smooth; I had to visit their office in Andheri and then have a face-to-face conversation with Neeraj sir (Hr). The questions were to introduce yourself, what is big data, ...
- Q2. After answering, he seemed somehow satisfied, but later he was encouraging me to enroll in their course and enhance my skills. And I'm still getting their emails and promotional messages for the same.
(2 Questions)
- Q1. The second round was on the call, which was rescheduled thrice. Then finally I got a call where Ashish sir (Hr) asked me to introduce myself, what are T&Z testing, overfitting, K neighbour algorithm, can w...
- Q2. The job position was for a fresher Data analyst, but they were asking questions related to Data scientist position. Basically, they were looking for a candidate who has hands-on experience with real-time d...
Interview Preparation Tips
- Data Science
- R
- Python
- Excel
A general apti round
Data analysis assignment
(1 Question)
- Q1. Sql questions askes
(1 Question)
- Q1. Product sense round
(1 Question)
- Q1. Culture fit round
Interview Questionnaire
1 Question
- Q1. Any type of questions in data field
I applied via Naukri.com and was interviewed before Sep 2021. There were 2 interview rounds.
Question was moderate.based on logical reasoning and math.
Coding test question based on sql and python.
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Feb 2023. There was 1 interview round.
(2 Questions)
- Q1. What's your experience?
- Q2. Don't you have Data Science experience?
- Ans.
No, I don't have direct Data Science experience.
However, I have worked with data extensively in my previous roles as a Data Analyst.
I have experience in data cleaning, data visualization, and statistical analysis.
I am also familiar with programming languages such as Python and R, which are commonly used in Data Science.
I am willing to learn and expand my skills in Data Science if given the opportunity.
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed before Mar 2023. There were 3 interview rounds.
Average question where asked
Normal sql based assignment was there
(1 Question)
- Q1. Normal question where asked to me
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Dec 2023. There was 1 interview round.
(2 Questions)
- Q1. Asked about the Statistics concepts hypothesis,pvalue,mean,meadian.mode,normaldistrubution?
- Q2. Sql joins questions based on three tables, complex joins
Interview Preparation Tips
- Statistics
- SQL
- joins
Selected
I applied via Referral and was interviewed in May 2024. There were 5 interview rounds.
(2 Questions)
- Q1. Question based on Window Functions in sql
- Q2. Order of execution
- Ans.
Order of execution refers to the sequence in which operations are carried out in a program or system.
Execution starts from the top of the program and moves downwards.
Operations within parentheses are executed first.
Multiplication and division are executed before addition and subtraction.
Functions are executed when they are called.
Control structures like loops and conditionals affect the order of execution.
(2 Questions)
- Q1. Write a sql query to find out different routes for a airline. Table has two columns which are destination and source
- Ans.
Use a SQL query to find different routes for an airline based on source and destination columns in a table.
Use a SELECT statement to retrieve the distinct combinations of source and destination.
Use the DISTINCT keyword to ensure only unique routes are returned.
Order the results by source and destination for easier analysis.
- Q2. Situational questions based on Business KPI
(1 Question)
- Q1. Simple discussion on the role and company culture
(1 Question)
- Q1. Case study question
(1 Question)
- Q1. Basic Discussion on relocation and interest in joining the company.
Interview Preparation Tips
Skills evaluated in this interview
MASAI School Interview FAQs
Tell us how to improve this page.
MASAI School Interviews By Designations
- MASAI School Data Analyst Interview Questions
- MASAI School Software Developer Interview Questions
- MASAI School Associate Product Manager Interview Questions
- MASAI School Product Manager Interview Questions
- MASAI School Full Stack Software Developer Interview Questions
- MASAI School Marketing Executive Interview Questions
- MASAI School Front end Developer Interview Questions
- MASAI School Mentor Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
MASAI School Data Analyst Interview Process
based on 2 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
MASAI School Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Operations Manager
40
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Full Stack Web Developer
29
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Analyst
18
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Full Stack Developer
17
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
16
salaries
| ₹0 L/yr - ₹0 L/yr |
upGrad
Simplilearn
Great Learning
Imarticus Learning
- Home >
- Interviews >
- MASAI School Interview Questions >
- MASAI School Data Analyst Interview Questions
