Add office photos
Filter interviews by
Simplotel Data Analyst Interview Questions and Answers
Updated
25 Sep 2024
1 interview found
Sort by:
Popular
Anonymous
Interview experience
Bad
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
One-on-one Round (1 Question)
- Q1. He asked how many luggages will be gone a day from airport without past data Add Answer
Top trending discussions
View All
Job/Referrals
2w
a data analyst
Referral Request : Serving notice period
Hi everyone,
I am a data analyst with 2.5 yeo currently serving notice period and looking for opportunities but unfortunately not getting much calls lately.
I am attaching my CV below any help is much appreciated.
Thanks for your time and consideration.
Skill set : SQL, Python, power Bi, data science.
Got a question about Simplotel?
Ask anonymously on communities.
Interview questions from similar companies
Gautham Reddy
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Interviewer asked me basic SQL questions Add Answer
- Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries) Add Answer
2
Coding Test Round
In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (5 Questions)
- Q1. Basic Excel Questions Add Answer
- Q2. Medium and Basic SQL Questions Add Answer
- Q3. Resume based Question Add Answer
- Q4. Case Study Questions Add Answer
- Q5. Questions on Project Add Answer
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via LinkedIn and was interviewed in Apr 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. SQL base Question Add Answer
- Q2. About your projects Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Instahyre and was interviewed in May 2024.
2 Interview Rounds
1
Coding Test Round
Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing
2
Case Study Round
1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via Company Website and was interviewed in Jul 2023.
4 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2
Aptitude Test Round
Number sires, clock, logic, arithmetic, geometry
3
Coding Test Round
Code test basic, ans the basic knowledge, write code
4
Technical Round (5 Questions)
- Q1. What is python? View Answers (2)
- Q2. What is python used for? View Answers (2)
- Q3. What type of language is python? View Answers (1)
- Q4. What is oops in python? View Answers (1)
- Q5. What is array in python? View Answers (1)
Interview Preparation Tips
Topics to prepare for Swiggy Data Analyst interview:
- Advanced Excel
- SQL Server
- Python
Skills evaluated in this interview
Interview experience
Bad
Difficulty level
Easy
Duration
2-4 weeks
Result
Selected
I applied via Approached by Company and was interviewed in Apr 2023.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2
Technical Round (6 Questions)
- Q1. Joins, operations questions not data analysis questions Add Answer
- Q2. Customer retention case study Add Answer
- Q3. Cumulative sum for given table View Answers (1)
- Q4. Do you have experience in operations/data entry role View Answers (1)
- Q5. As a data analyst can you do data entry work also? View Answers (1)
- Q6. Normal excel statements like if, vlookup, xlookups etc., Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - 1) Waste of time (never trust interviewer who explains about the role)
2) they are looking for candidates for data reporting operations guy from a tier 1 college
3) as discussed with the interviewer the profile will be like a data entry operations role so get clarification on the role properly.
4) if you get an offer letter try to make this company as least priority company as the JD is not clear and the way they explain the case study is truly confusing.
5) other than this central tendency, normal crunching, joins, etc,.
6) People from non - data analytics team took an interview I hope there is no data analyst in the company while checking in LinkedIn and even the interviewer mentioned the same.
7) Interview will get rescheduled several times because of the interviewer and will be more delay
8) as per their discussion it will be more about data reporting in google sheets, excel on a daily basis i guess and I hope there won't be any proper predictive or quantitative or qualitative analysis.
9) if you are looking for better learning, growth and advancement in your career then this is not a correct company for you(that's how I decided when comparing offers from other company).
10) try to communicate with employees of the company who are in current role or past role get a better understanding.
11) current company situtation might push you but take a better decision.
12)chhallaaang lagaane se pahale dekho.
2) they are looking for candidates for data reporting operations guy from a tier 1 college
3) as discussed with the interviewer the profile will be like a data entry operations role so get clarification on the role properly.
4) if you get an offer letter try to make this company as least priority company as the JD is not clear and the way they explain the case study is truly confusing.
5) other than this central tendency, normal crunching, joins, etc,.
6) People from non - data analytics team took an interview I hope there is no data analyst in the company while checking in LinkedIn and even the interviewer mentioned the same.
7) Interview will get rescheduled several times because of the interviewer and will be more delay
8) as per their discussion it will be more about data reporting in google sheets, excel on a daily basis i guess and I hope there won't be any proper predictive or quantitative or qualitative analysis.
9) if you are looking for better learning, growth and advancement in your career then this is not a correct company for you(that's how I decided when comparing offers from other company).
10) try to communicate with employees of the company who are in current role or past role get a better understanding.
11) current company situtation might push you but take a better decision.
12)chhallaaang lagaane se pahale dekho.
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. Joins and basics Add Answer
2
Case Study Round
Netflix user churn case study,
Uber booking number reduce
Snigdha Dhupal
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
I applied via Job Portal
2 Interview Rounds
1
Coding Test Round
SQL and Python data analysis questions
2
Technical Round (1 Question)
- Q1. How do you match the data in different columns. View Answers (1)
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Technical Round (1 Question)
- Q1. SQl questions what is rank in sql Add Answer
2
Case Study Round
Case study on fuel and diesel consumption
3
HR Round (1 Question)
- Q1. Why porter and how Add Answer
Simplotel Interview FAQs
How many rounds are there in Simplotel Data Analyst interview?
Simplotel interview process usually has 1 rounds. The most common rounds in the Simplotel interview process are One-on-one Round.
Tell us how to improve this page.
Simplotel Interviews By Designations
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
Data Analyst Interview Questions from Similar Companies
|
Front end Developer
9
salaries
|  ₹4.4 L/yr - ₹4.4 L/yr |
|
Business Development Manager
6
salaries
| ₹7 L/yr - ₹15 L/yr |
|
Customer Success Manager
6
salaries
| ₹7 L/yr - ₹8 L/yr |
|
Software Engineer
5
salaries
| ₹4.4 L/yr - ₹10.8 L/yr |
|
Senior Business Development Manager
4
salaries
| ₹16 L/yr - ₹18 L/yr |
Explore more salaries
Compare Simplotel with
Oyo Rooms
Compare
Treebo Hotels
Compare
FabHotels
Compare
Cleartrip
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Simplotel Interview Questions >
- Simplotel Data Analyst Interview Questions
Share an Interview