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

Clear (1)

BigBasket Data Analyst Interview Questions and Answers

Updated 15 May 2024

BigBasket Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 15 May 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. About previous experience situation based questions excel problem solving
  • Q2. Tell me about yourself difference between data quality and data validity

Interview Preparation Tips

Interview preparation tips for other job seekers - excel skills and data analysis basics

Interview questions from similar companies

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 Resume 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 Resume 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.

I was interviewed in Apr 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 Resume tips
Round 2 - One-on-one 

(1 Question)

  • Q1. What attracted you to this company?

Interview Preparation Tips

Interview preparation tips for other job seekers - The best thing a job seeker can do is consider the new ways of networking, applying and interviewing for a job as opportunity rather than barriers.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jul 2023. 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 Resume tips
Round 2 - Aptitude Test 

Number sires, clock, logic, arithmetic, geometry

Round 3 - Coding Test 

Code test basic, ans the basic knowledge, write code

Round 4 - Technical 

(5 Questions)

  • Q1. What is python?
  • Ans. 

    Python is a high-level programming language known for its simplicity and readability.

    • Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.

    • It emphasizes code readability and uses indentation to define code blocks.

    • Python has a large standard library and a vibrant community of developers.

    • Example: print('Hello, World!')

    • Example: import pandas as pd

  • Answered by AI
  • Q2. What is python used for?
  • Ans. 

    Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.

    • Data analysis and visualization

    • Web development (Django, Flask)

    • Artificial intelligence and machine learning (TensorFlow, PyTorch)

    • Automation and scripting

    • Scientific computing (NumPy, SciPy)

  • Answered by AI
  • Q3. What type of language is python?
  • Ans. 

    Python is a high-level programming language known for its simplicity and readability.

    • Python is an interpreted language, meaning it does not need to be compiled before running.

    • It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.

    • Python has a large standard library and a thriving community, making it versatile and widely used.

    • Example: Python is used for web develop...

  • Answered by AI
  • Q4. What is oops in python?
  • Ans. 

    Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.

    • OOP allows for the organization of code into reusable components called classes.

    • Classes can have attributes (variables) and methods (functions) associated with them.

    • In Python, everything is an object, and classes can be defined using the 'class' keyword.

    • Encapsulation, inheritance, and polymorph

  • Answered by AI
  • Q5. What is array in python?
  • Ans. 

    An array in Python is a data structure that stores a collection of elements of the same type.

    • Arrays can store elements such as integers, floats, or strings.

    • Arrays are indexed starting from 0, with elements accessed using their index.

    • Example: arr = ['apple', 'banana', 'cherry']

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Swiggy Data Analyst interview:
  • Advanced Excel
  • SQL Server
  • Python
Interview preparation tips for other job seekers - online interview

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Job Portal and was interviewed in Jun 2023. There were 3 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 Resume tips
Round 2 - Aptitude Test 

Aptitude test is a way for employers to assess a candidate's abilities through a variety of different testing formats. Aptitude tests will test your ability to perform tasks and react to situations at work. This includes: problem-solving.

Round 3 - One-on-one 

(2 Questions)

  • Q1. Tell me something about yourself. How did you hear about this position? Why do you want to work here?
  • Ans. Hi thank you for giving me this opportunity to introduce my self lakshmi r am basically from doddballapur i graduate in b. Com from banglore north university
  • Answered Anonymously
  • Q2. What is your greatest strength? What are your strengths and weaknesses? What do you know about this company/organization?
Contribute & help others!
anonymous
You can choose to be anonymous

BigBasket Interview FAQs

How many rounds are there in BigBasket Data Analyst interview?
BigBasket interview process usually has 1 rounds. The most common rounds in the BigBasket interview process are One-on-one Round.
How to prepare for BigBasket Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at BigBasket. The most common topics and skills that interviewers at BigBasket expect are AWS, Power BI, Python, Quicksight and RDBMS.

Recently Viewed

INTERVIEWS

Ninjacart

No Interviews

SALARIES

Shriram Automall

JOBS

Upstep Academy

No Jobs

JOBS

Maruti Suzuki

No Jobs

SALARIES

OxfordCaps India

JOBS

JAY JAY MILLS

No Jobs

COMPANY BENEFITS

Jungleworks

No Benefits

SALARIES

Jungleworks

JOBS

The Talent Keepers

No Jobs

JOBS

VMS Ventures Delhi

No Jobs

Tell us how to improve this page.

BigBasket Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
Join BigBasket India's largest online supermarket
BigBasket Data Analyst Salary
based on 23 salaries
₹3.2 L/yr - ₹7 L/yr
17% less than the average Data Analyst Salary in India
View more details

BigBasket Data Analyst Reviews and Ratings

based on 3 reviews

4.5/5

Rating in categories

4.2

Skill development

4.2

Work-life balance

3.5

Salary

3.4

Job security

3.7

Company culture

3.5

Promotions

3.7

Work satisfaction

Explore 3 Reviews and Ratings
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