AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Zepto
Compare
Filter interviews by
Zepto Data Analyst Interview Questions, Process, and Tips
Top Zepto Data Analyst Interview Questions and Answers
- Q1. As a data analyst can you do data entry work also?
- Q2. how fast can you prepare a bar chart with product operations data
- Q3. how can I do merge multiple excel files together
Zepto Data Analyst Interview Experiences
2 interviews found
Anonymous
Selected
I applied via Approached by Company and was interviewed in Apr 2023. There were 2 interview rounds.
(6 Questions)
- Q1. Joins, operations questions not data analysis questions
- Q2. Customer retention case study
- Q3. Cumulative sum for given table
- Ans.
To calculate cumulative sum for a given table
Sort the table in ascending order based on the column you want to calculate the cumulative sum for
Add a new column to the table to store the cumulative sum
Iterate through each row of the table and calculate the cumulative sum by adding the current row's value to the previous row's cumulative sum
Store the cumulative sum in the new column for each row
- Q4. Do you have experience in operations/data entry role
- Ans.
Yes, I have experience in both operations and data entry roles.
I have worked as a data entry operator for a pharmaceutical company where I was responsible for entering patient data into the system.
In my previous role as an operations analyst, I was responsible for analyzing data and creating reports for the management team.
I have experience using various data entry software such as Microsoft Excel and Google Sheets.
I a...
- Q5. As a data analyst can you do data entry work also?
- Ans.
Yes, I can do data entry work as a data analyst.
Data entry work is a part of data analysis process.
I have experience in data entry work and can perform it efficiently.
Data entry work includes entering data into spreadsheets, databases, or other software.
I understand the importance of accurate data entry for effective analysis.
- Q6. Normal excel statements like if, vlookup, xlookups etc.,
Interview Preparation Tips
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
Selected
I applied via Approached by Company and was interviewed in Apr 2023. There were 6 interview rounds.
(2 Questions)
- Q1. Screening questions
- Q2. Name, age, qualification, prior experience etc
Operation questions like vlookups, Hlookups, xlookups etc,.
Reporting questions like pivot tables, typing speed, power pivots, pricing sheet preparation
SQL queries like joins, aggregation functions, filters etc,.
(3 Questions)
- Q1. Advanced analytics and finding trends and patterns with MH - operations data
- Q2. How fast can you prepare a bar chart with product operations data
- Ans.
I can prepare a bar chart with product operations data within a few minutes.
I have experience using data visualization tools like Tableau, Power BI, or Excel to quickly create bar charts.
I am proficient in organizing and cleaning data to ensure accurate representation in the chart.
I can customize the chart with relevant labels, colors, and titles to make it visually appealing and easy to understand.
- Q3. How can I do merge multiple excel files together
- Ans.
You can merge multiple Excel files together using the 'Consolidate' feature in Excel.
Open Excel and go to the 'Data' tab
Click on 'Consolidate' in the 'Data Tools' group
Select the files you want to merge and choose the desired options
Click 'OK' to merge the files together
Skills evaluated in this interview
Interview questions from similar companies
I applied via campus placement at Nitte Meenakshi Institute of Technology, Bangalore 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
Gautham Reddy
(2 Questions)
- Q1. Interviewer asked me basic SQL questions
- Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.
(5 Questions)
- Q1. Basic Excel Questions
- Q2. Medium and Basic SQL Questions
- Q3. Resume based Question
- Q4. Case Study Questions
- Q5. Questions on Project
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
SQL based questions wer asked on joins , rank function,
Selected
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. SQL base Question
- Q2. About your projects
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 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
(1 Question)
- Q1. Joins and basics
Netflix user churn case study,
Uber booking number reduce
Zepto Interview FAQs
Tell us how to improve this page.
Zepto Interviews By Designations
- Zepto Shift Incharge Interview Questions
- Zepto Senior Software Engineer Interview Questions
- Zepto Software Development Engineer 3 Interview Questions
- Zepto Store Manager Interview Questions
- Zepto Operations Manager Interview Questions
- Zepto Software Developer Interview Questions
- Zepto MIS Executive Interview Questions
- Zepto Product 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
- Data Science Analyst Interview Questions
- Show more
Zepto Data Analyst Interview Process
based on 2 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Zepto Data Analyst Reviews and Ratings
based on 4 reviews
Rating in categories
|
Shift Incharge
396
salaries
|  ₹2.2 L/yr - ₹5 L/yr |
|
Team Lead
136
salaries
| ₹2 L/yr - ₹8.4 L/yr |
|
Store Manager
134
salaries
| ₹2.2 L/yr - ₹8.2 L/yr |
|
Senior Manager
129
salaries
| ₹10 L/yr - ₹30 L/yr |
|
Store Incharge
95
salaries
| ₹2.3 L/yr - ₹4.5 L/yr |
Blinkit
Dunzo
BigBasket
Swiggy
- Home >
- Interviews >
- Zepto Interview Questions >
- Zepto Data Analyst Interview Questions
