Premium Employer

i

This company page is being actively managed by BigBasket Team. If you also belong to the team, you can get access from here

BigBasket Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

BigBasket Data Analyst 2 Interview Questions and Answers

Updated 26 Feb 2022

BigBasket Data Analyst 2 Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in Aug 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Sql based queries like rank dense rank replacing bill values and some basic queries
  • Q2. CTE function, aggregate functions
Round 2 - Technical 

(2 Questions)

  • Q1. Running values third highest
  • Ans. 

    To find the third highest value in a dataset

    • Sort the dataset in descending order

    • Select the third value from the sorted dataset

    • If there are ties, consider the next highest value as the third highest

  • Answered by AI
  • Q2. And some manager level questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Bigbasket was hiring for a report developer position so they mostly required a person who had intermediate knowledge on sql so be prepared make strong foundation in sql all the best

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Pivot and excel questions
  • Q2. All about excel

Interview Preparation Tips

Interview preparation tips for other job seekers - It was very simple self intro and excel questions and basic macro

Analyst Interview Questions & Answers

Flipkart user image Pratyaksh Karan

posted on 28 Mar 2015

Interview Preparation Tips

Round: Group Discussion
Experience: Nicely organized GD, civilized and intellectual GD group, discussion rich topic
Tips: Allow others to speak when they have something to say. Do try to push your way in if someone is talking too long or talking gibberish. Do not push your point too much, however, present logical arguments in favor. Try to draw similarities from what others say. Try to include all.

Round: HR Interview
Experience: Friendly HR interviewer. Non-direct questions but not too difficult.
Tips: Answer all questions honestly but be polite. Don't present too strong views, you are too young for that. Don't repeat content with different words, but be elaborate enough to let the interviewer know you.

Round: Guesstimate Interview
Tips: Read up some guesstimates and case studies before placements, discuss some with friends too. Open up your mind while guesstimating. Speak all that comes to your head, and vocally sift through them to get the logical and pursue-able approaches. The interviewer should get a complete idea of your analytical approach.

College Name: IIT Kharagpur
Motivation: First foray into corporate structure. Lots of opportunities. Diversified experiences.

I applied via Referral and was interviewed before Dec 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(2 Questions)

  • Q1. Basic sql and joins ..
  • Q2. Advance excel is a must have
Round 3 - Case Study 

Price precision of riders, city wise calculation of cost per orders and earnings

Round 4 - HR 

(1 Question)

  • Q1. Salary expectations and all

Interview Preparation Tips

Interview preparation tips for other job seekers - plz prepare for business understanding like how businesses works and at the end how you values to the company
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Aug 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - One-on-one 

(4 Questions)

  • Q1. How do you setup a Dark Store?
  • Ans. 

    Setting up a Dark Store involves converting a retail store into a fulfillment center for online orders.

    • Select a suitable location for the Dark Store, preferably in a centralized area with good access to transportation.

    • Optimize the layout of the store for efficient picking, packing, and shipping of orders.

    • Implement inventory management systems to track stock levels accurately and prevent stockouts.

    • Train staff on order f...

  • Answered by AI
  • Q2. How do joins work in the simplest manner?
  • Ans. 

    Joins combine data from two or more tables based on a related column.

    • Joins are used to retrieve data from multiple tables based on a related column

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

  • Answered by AI
  • Q3. Write a basic query explaining the order of execution?
  • Ans. 

    The order of execution in a query determines the sequence in which operations are performed.

    • 1. The order of execution in a query typically follows the sequence: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

    • 2. The FROM clause specifies the tables involved in the query.

    • 3. The WHERE clause filters the rows based on specified conditions.

    • 4. The GROUP BY clause groups the rows that have the same values into summary rows.

    • 5...

  • Answered by AI
  • Q4. Difference between Group By and Distinct?
  • Ans. 

    Group By is used to aggregate data based on a specific column, while Distinct is used to remove duplicate rows from a result set.

    • Group By is used with aggregate functions like COUNT, SUM, AVG, etc.

    • Distinct is used to retrieve unique values from a column or set of columns.

    • Group By can be used to group data based on multiple columns, while Distinct operates on individual columns only.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Blinkit Data Analyst interview:
  • SQL
  • joins
  • window functions

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

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

Round 2 - Case Study 

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
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Coding Test 

SQL query optimisation

Round 2 - HR 

(1 Question)

  • Q1. Regular discussion, about job role, why swiggy

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare excel, and sql

I applied via Company Website and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Salary and designation

Interview Preparation Tips

Interview preparation tips for other job seekers - 1

I applied via Naukri.com and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Sql questions based on group by , windows functions , functions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident. Understand the role very clearly.

I was interviewed in Jan 2022.

Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(1 Question)

  • Q1. Questions are fully based on sql, excel, Python. Questions asked given by a case study.
Round 3 - Technical 

(1 Question)

  • Q1. Statistics, few asked related to regression, hypothesis, ttest, and also questions on sql, python

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't prepare too much, be patient, here what the question is. Learn not just mugging up, learn the concept properly.

BigBasket Interview FAQs

How many rounds are there in BigBasket Data Analyst 2 interview?
BigBasket interview process usually has 2 rounds. The most common rounds in the BigBasket interview process are Technical.
What are the top questions asked in BigBasket Data Analyst 2 interview?

Some of the top questions asked at the BigBasket Data Analyst 2 interview -

  1. Running values third high...read more
  2. Sql based queries like rank dense rank replacing bill values and some basic que...read more
  3. CTE function, aggregate functi...read more

Tell us how to improve this page.

Join BigBasket India's largest online supermarket

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 5k Interviews
Reliance Retail Interview Questions
3.9
 • 1.5k Interviews
Flipkart Interview Questions
4.0
 • 1.3k Interviews
Swiggy Interview Questions
3.8
 • 424 Interviews
DMart Interview Questions
3.9
 • 401 Interviews
PolicyBazaar Interview Questions
3.6
 • 345 Interviews
JustDial Interview Questions
3.5
 • 325 Interviews
Zomato Interview Questions
3.7
 • 308 Interviews
Blinkit Interview Questions
3.7
 • 178 Interviews
View all
Business Development Executive
654 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Inventory Executive
432 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Operations Controller
380 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Shift Incharge
371 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Customer Support Executive
326 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare BigBasket with

Milkbasket

3.9
Compare

Amazon

4.1
Compare

Blinkit

3.7
Compare

Nature's Basket

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview