AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Blinkit Data Analyst Intern Interview Questions and Answers
Blinkit Data Analyst Intern Interview Experiences
1 interview found
Ronak Maru
I applied via LinkedIn and was interviewed in Sep 2023. There were 4 interview rounds.
Duration was of 1hour. Topics: SQL Basics, SQL Query, Case study related to Blinkit.
(3 Questions)
- Q1. - Guesstimate (No. of paper cups used in one day in an Office)
- Ans.
Approximately 500 paper cups may be used in a day in an average office.
Consider the number of employees in the office
Think about the average number of hot beverage drinkers
Factor in the number of meetings and events held in the office
Take into account the availability of reusable cups
Estimate based on personal experience or observation
- Q2. - Puzzle: Find out heavier one out of 9 ball
- Q3. - Situation based questions (KPIs used as manager of Dark Store)
(2 Questions)
- Q1. SQL Questions (Group by)
- Q2. Analytical Question related to Profit loss
Interview Preparation Tips
- SQL
Interview questions from similar companies
Anonymous
I applied via Recruitment Consultant and was interviewed in Jan 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Why do you want to leave your current organization
Snigdha Dhupal
I applied via Job Portal
SQL and Python data analysis questions
(1 Question)
- Q1. How do you match the data in different columns.
- Ans.
Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.
Use string matching techniques like exact match, partial match, or fuzzy matching.
Apply data cleaning and preprocessing techniques to standardize the data before matching.
Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.
Consider using database join...
I applied via Campus Placement and was interviewed in Nov 2024. There were 4 interview rounds.
Questions from arrays and strings and some aptitude questions
(2 Questions)
- Q1. How to merge 2 csv files
- Ans.
To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.
Open both CSV files in a software like Microsoft Excel.
Copy the data from one CSV file and paste it into the other CSV file.
Save the merged CSV file with a new name.
Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.
- Q2. Basic questions on arrays
(1 Question)
- Q1. 3 reasons why u choose this company
- Ans.
I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.
Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.
Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.
Company culture - I value a positive work environment and the...
(1 Question)
- Q1. Questions on python
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.
(3 Questions)
- Q1. Peevious Experience related questions
- Q2. Dashboard related questions
- Q3. Sql related questions
Interview Preparation Tips
I was informed by the HR team that my interview would be conducted in person, with all rounds taking place on the same day, and that I would receive the results the same day. As a result, I traveled a considerable distance to attend.for the interview the told me to wait for the 3 hrs.
- During the interview, it was disheartening to find that the interviewer seemed uninterested in my responses. I was asked to write queries on paper, and while I was explaining them, the interviewer was preoccupied with reading emails and all other work. Despite providing correct answers, the experience felt dismissive.
After the interview, I was asked to wait for feedback. After waiting for two hours, the HR team informed me that my review was still in process and that they would follow up. After three days and multiple follow-ups, I was eventually told that I did not clear the round.
While I am okay with the outcome, I have a few requests for companies conducting interviews:
1.Respect Candidates' Efforts and Time: Please be considerate of the efforts and time candidates invest, especially those who travel long distances.
2. Clear Communication: If face-to-face interviews are required, particularly for final rounds, please communicate this clearly to avoid unnecessary travel and inconvenience.
I hope these points help improve the interview process for future candidates.
I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. Project Related Questions
- Q2. Dashboard Question on charts
Interview Preparation Tips
So I travelled frm long distance
during interview , interviewer was not even interested in my answers he ans me to write queries on page and while i was writing and explain him the query he was not even listening and reading mails.
after giving all answers he ask he to wait and he will inform HR my review and luckily that answer paper was with me i check all the answers wore correct
i waited 2 hour after that HR informed my review is still in process so they will give me call
after 3 days and multiple call and mail HR infomed you have not cleared the round
I'm ok with this
but just request don't fool people who put efforts and time
and please if company ask for Face to face and you have to travel from other city ask them final round will be face to face.
Selected
I applied via Approached by Company and was interviewed before Aug 2023. There were 3 interview rounds.
It contains basic quantitive questions
SQL and Python coding questions were asked
(2 Questions)
- Q1. What and what not to be shown in dashboard?
- Ans.
Dashboards should show relevant and actionable data while avoiding clutter and unnecessary information.
Include key performance indicators (KPIs) that align with business goals
Avoid showing too much data that may overwhelm the viewer
Use visualizations that effectively communicate insights
Exclude irrelevant or outdated information
Consider the audience and their specific needs when designing the dashboard
- Q2. Logical Question
Skills evaluated in this interview
Abhilasa Barman
I was asked a medium-level SQL question that involved the RANK function.
(2 Questions)
- Q1. Create the pivot table, sort the data in ascending order
- Ans.
Create a pivot table and sort the data in ascending order.
To create a pivot table, select the data range and go to the 'Insert' tab in Excel.
Choose 'PivotTable' and select the location for the pivot table.
Drag the desired fields to the 'Rows' and 'Values' areas.
To sort the data in ascending order, click on the drop-down arrow next to the field name in the pivot table and select 'Sort A to Z'.
- Q2. Use lookup with the product based given data and find the needed data
- Ans.
Using lookup with product-based data to find the needed data.
Use a lookup function like VLOOKUP or INDEX/MATCH to search for the needed data
Identify the key or unique identifier to match the data
Specify the range or table where the data is located
Retrieve the desired data based on the lookup value
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Mar 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Output resukt number of rows basis the joins
- Ans.
The output result number of rows depends on the type of join used.
Inner join returns only the matching rows from both tables
Left join returns all rows from the left table and matching rows from the right table
Right join returns all rows from the right table and matching rows from the left table
Full outer join returns all rows from both tables
Cross join returns the Cartesian product of both tables
- Q2. Output result number of rows basis the joins
- Ans.
The question asks to output the number of rows based on joins.
The number of rows in the output depends on the type of join used.
Inner join only returns rows that have matching values in both tables.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and matching rows from the left table.
Full outer join returns all rows from both tables.
U...
Interview Preparation Tips
Skills evaluated in this interview
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
- Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Blinkit Data Analyst Intern Interview Process of Internships
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Store Manager
853
salaries
|  ₹3 L/yr - ₹7.6 L/yr |
|
Senior Executive
570
salaries
| ₹2 L/yr - ₹8.2 L/yr |
|
Assistant Manager
418
salaries
| ₹2.1 L/yr - ₹11 L/yr |
|
Assistant Store Manager
390
salaries
| ₹1.9 L/yr - ₹5 L/yr |
|
Team Lead
377
salaries
| ₹1.4 L/yr - ₹4.8 L/yr |
Zepto
BigBasket
Udaan
Swiggy
- Home >
- Interviews >
- Blinkit Interview Questions >
- Blinkit Data Analyst Intern Internship Interview Questions
