AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Blinkit Data Analyst Interview Questions, Process, and Tips
Top Blinkit Data Analyst Interview Questions and Answers
- Q1. How do joins work in the simplest manner?
- Q2. Write a basic query explaining the order of execution?
- Q3. Difference between Group By and Distinct?
Blinkit Data Analyst Interview Experiences
2 interviews found
Anonymous
I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.
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
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
Selected
I applied via Referral and was interviewed before Aug 2022. There were 2 interview rounds.
(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...
- 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
- 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...
- 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.
Interview Preparation Tips
- SQL
- joins
- window functions
Skills evaluated in this interview
Interview questions from similar companies
I applied via Job Portal and was interviewed in Jun 2023. There were 3 interview rounds.
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.
(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
- Q2. What is your greatest strength? What are your strengths and weaknesses? What do you know about this company/organization?
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
(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
Selected
I applied via Referral and was interviewed in Aug 2023. There were 2 interview rounds.
SQL query optimisation
(1 Question)
- Q1. Regular discussion, about job role, why swiggy
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed in Jul 2023. There were 4 interview rounds.
Number sires, clock, logic, arithmetic, geometry
Code test basic, ans the basic knowledge, write code
(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
- 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)
- 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...
- 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
- 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']
Interview Preparation Tips
- Advanced Excel
- SQL Server
- Python
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. SQL and excel questions.
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before Jul 2023. There were 3 interview rounds.
(1 Question)
- Q1. Tell us about previous work experience
About groups and joins
(1 Question)
- Q1. Salary negotiation
I applied via Apna Jobs and was interviewed in Dec 2021. There were 3 interview rounds.
Practice realistic online tests.
(2 Questions)
- Q1. Tell me About your self
- Q2. What is coustomer service
- Ans.
Customer service is the provision of assistance and support to customers before, during, and after a purchase.
It involves addressing customer inquiries and complaints
Providing information about products or services
Resolving issues and ensuring customer satisfaction
Examples include phone support, email support, live chat, and in-person assistance
Interview Preparation Tips
- Stores
Apple with candidate
Schedule information interviews
Interview Questionnaire
1 Question
- Q1. Excel, Power BI, SQL questions
Interview Preparation Tips
Blinkit Interview FAQs
Tell us how to improve this page.
Blinkit Interviews By Designations
- Blinkit Store Manager Interview Questions
- Blinkit Senior Executive Interview Questions
- Blinkit Assistant Store Manager Interview Questions
- Blinkit Assistant Manager Interview Questions
- Blinkit Cluster Manager Interview Questions
- Blinkit Senior Assistant Interview Questions
- Blinkit Software Developer Interview Questions
- Blinkit Station Manager 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
- Associate Data Analyst Interview Questions
- Show more
Blinkit Data Analyst Interview Process
based on 2 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Blinkit Data Analyst Reviews and Ratings
based on 5 reviews
Rating in categories
|
Store Manager
827
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Executive
555
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
426
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Team Lead
421
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Store Manager
333
salaries
| ₹0 L/yr - ₹0 L/yr |
Zepto
BigBasket
Flipkart
Amazon
- Home >
- Interviews >
- Blinkit Interview Questions >
- Blinkit Data Analyst Interview Questions
