Add office photos
Filter interviews by
17LIVE Data Analyst Interview Questions and Answers
Updated
26 Sep 2024
1 interview found
Sort by:
Popular
Anonymous
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via LinkedIn and was interviewed in Aug 2024.
1 Interview Round
1
Technical Round (5 Questions)
- Q1. Tell Me about Your Projects View Answers (1)
- Q2. Some technical question about projects View Answers (1)
- Q3. What is Central limit theorem View Answers (1)
- Q4. Questions on Statistic Add Answer
- Q5. You have 3L and 5L jar, how will you measure 4L water using this Jar. You have unlimited water. Add Answer
Top trending discussions
View All
Interview Tips & Stories
2w (edited)
a consultant
Alternate documents for Employee verification?
My new employer asked for my previous offer letters and salary slips. When I inquired, they said it was for background verification.
However, I feel that providing these documents might affect salary negotiations, and it feels a bit unethical too.
What alternative documents can I provide for employment verification?
Got a question about 17LIVE?
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
17LIVE Interview FAQs
How many rounds are there in 17LIVE Data Analyst interview?
17LIVE interview process usually has 1 rounds. The most common rounds in the 17LIVE interview process are Technical.
What are the top questions asked in 17LIVE Data Analyst interview?
Tell us how to improve this page.
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
People are getting interviews through
based on 1 17LIVE interview
Job Portal
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Data Analyst Interview Questions from Similar Companies
|
Senior Software Engineer
4
salaries
|  ₹13 L/yr - ₹20 L/yr |
|
Machine Learning Engineer
4
salaries
| ₹6.5 L/yr - ₹15 L/yr |
|
Product Marketing Analyst
4
salaries
| ₹8 L/yr - ₹8.6 L/yr |
|
Senior Director Operations
4
salaries
| ₹24 L/yr - ₹38.5 L/yr |
|
Software Engineer
3
salaries
| ₹8.5 L/yr - ₹9.2 L/yr |
Explore more salaries
Compare 17LIVE with
Bigo Live India
Compare
TikTok
Compare
Snapchat
Compare
Periscope
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 >
- 17LIVE Interview Questions >
- 17LIVE Data Analyst Interview Questions
Share an Interview