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
Interview questions from similar companies
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 Recruitment Consulltant and was interviewed in Oct 2022. There were 4 interview rounds.
(4 Questions)
- Q1. Ask some questions about my self and previously what i did and some questions related to company...
- Q2. Tell me about your self
- Q3. What are the skills you have
- Q4. Why are you choose this company
They share some apptitude questions and communication related questions to answer them...
Take a one topic from my self to discuss with other to communicate....how easily
Interview Preparation Tips
- Python
- MySQL
- Machine Learning
- Tableau
- Excel
I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.
Verbal, logical, Quantative test
(1 Question)
- Q1. Self introduction
Interview Preparation Tips
SQL, Analytical, Maths
(2 Questions)
- Q1. SQL qsn on some data
- Q2. Qsn on LLMs in company
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
SQL two problem statements to be solved in 30 mins
Python two problem statements to be solved in 30 mins
Around 15 MCQ on stats and aptitude
(1 Question)
- Q1. Python, Excel, SQL and aptitude
Interview Questionnaire
2 Questions
- Q1. Google sheet
- Q2. Sql
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
- Data Science 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
394
salaries
|  ₹4 L/yr - ₹7.3 L/yr |
|
Inside Sales Specialist
385
salaries
| ₹4.3 L/yr - ₹7.5 L/yr |
|
Inside Sales Manager
374
salaries
| ₹3 L/yr - ₹7 L/yr |
|
Senior Inside Sales Specialist
304
salaries
| ₹4.5 L/yr - ₹8.5 L/yr |
|
Senior Associate Business Manager
111
salaries
| ₹7 L/yr - ₹14 L/yr |
upGrad
BYJU'S
Whitehat jr
Unacademy
- Home >
- Interviews >
- Simplilearn Interview Questions >
- Simplilearn Data Analyst Interview Questions
