AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Simplilearn Data Analyst Interview Questions and Answers
Simplilearn Data Analyst Interview Experiences
4 interviews found
Anonymous
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
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
(1 Question)
- Q1. The first round was a basic telephonic interview. Then simple basic SQL questions and some question based on Normalisation and DBMS were asked.
(1 Question)
- Q1. This was the toughest Data Analyst Interview I have faced till now. Interview was of 1 hr. Required higher level of SQL understanding. Asked to share screen and then solve SQL queries. Question based on jo...
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 3 interview rounds.
(1 Question)
- Q1. Technical questions mostly around sql, project based and few theoretical questions on python
(1 Question)
- Q1. This was one of the most grilled interview i have given, require moderate level of sql understanding, was asked to share screen and solve it , also i had show how it is working then basic questions of py...
(1 Question)
- Q1. Was asked basic HR questions
Interview Preparation Tips
- SQL
- Python
- Excel
- Case Studies
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
Simplilearn interview questions for designations
Top trending discussions
Interview questions from similar companies
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
Interview Questionnaire
2 Questions
- Q1. Google sheet
- Q2. Sql
Interview Preparation Tips
Aashutosh Goyal
Selected
I applied via Referral and was interviewed before Oct 2022. There were 4 interview rounds.
(2 Questions)
- Q1. Basic Skillset questions
- Q2. Projects worked on
(1 Question)
- Q1. Knowledge on Marketing tools and case scenarios
(1 Question)
- Q1. SQl Queries, Previous projects
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
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
Simplilearn Interview FAQs
Tell us how to improve this page.
Simplilearn Interviews By Designations
- Simplilearn Inside Sales Manager Interview Questions
- Simplilearn Inside Sales Specialist Interview Questions
- Simplilearn Senior Manager - Inside Sales Interview Questions
- Simplilearn Data Analyst Interview Questions
- Simplilearn Product Manager Interview Questions
- Simplilearn Sales Manager Interview Questions
- Simplilearn Software Development Engineer Interview Questions
- Simplilearn Sales Specialist 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
Simplilearn Data Analyst Interview Process
based on 4 interviews
2 Interview rounds
- Technical Round - 1
- Technical Round - 2
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Simplilearn Data Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
|
Senior Manager - Inside Sales
399
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Inside Sales Specialist
388
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Inside Sales Manager
349
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Inside Sales Specialist
294
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate Business Manager
119
salaries
| ₹0 L/yr - ₹0 L/yr |
upGrad
Great Learning
Imarticus Learning
NIIT
- Home >
- Interviews >
- Simplilearn Interview Questions >
- Simplilearn Data Analyst Interview Questions
