AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
GoMechanic
Compare
Filter interviews by
GoMechanic Data Analyst Intern Interview Questions and Answers
GoMechanic Data Analyst Intern Interview Experiences
2 interviews found
Anonymous
I applied via Internshala and was interviewed in Dec 2024. There was 1 interview round.
(1 Question)
- Q1. What is Vlookup and Hlookup
- Ans.
Vlookup and Hlookup are Excel functions used to search for a value in a table and return a corresponding value.
Vlookup searches for a value in the first column of a table and returns a value in the same row from a specified column.
Hlookup searches for a value in the first row of a table and returns a value in the same column from a specified row.
Both functions are commonly used in Excel for data analysis and lookup ope
sharad hariom
(1 Question)
- Q1. What is difference between delete,drop and truncate. ?
- Ans.
Delete removes specific rows from a table, drop removes entire table structure, and truncate removes all rows from a table.
Delete is a DML command, drop is a DDL command, and truncate is a DDL command.
Delete can be rolled back, drop cannot be rolled back, and truncate cannot be rolled back.
Delete triggers delete triggers, drop triggers drop triggers, and truncate does not trigger any triggers.
Example: DELETE FROM table...
(1 Question)
- Q1. What are iterrators .?
- Ans.
Iterators are objects that allow sequential access to elements in a collection.
Iterators are used to loop through elements in a collection one at a time.
They provide a way to access elements without exposing the underlying data structure.
Iterators have methods like next() to retrieve the next element in the collection.
Examples of iterators include Python's iter() and Java's Iterator interface.
Skills evaluated in this interview
Interview questions from similar companies
I applied via LinkedIn and was interviewed in May 2023. There were 3 interview rounds.
Send assignment doings MS Excel
(2 Questions)
- Q1. Asked about the previous project
- Q2. What about your roles in previous company
Interview Preparation Tips
- Excel
Interview Questionnaire
2 Questions
- Q1. SQL and Excel were the key that helped me get this job.
- Q2. Puzzles
Hellbound test are not required to select 1 employee
(2 Questions)
- Q1. Why r u here
- Ans.
I am here because I am passionate about analyzing data and providing valuable insights to drive decision-making.
Passionate about data analysis
Enjoy providing valuable insights
Driven to help make informed decisions
- Q2. Tell me about something
- Ans.
I will tell you about my experience volunteering at a local animal shelter.
Volunteered at local animal shelter for 6 months
Assisted with feeding, cleaning, and socializing with animals
Helped organize adoption events and fundraisers
Jay Shankar Prasad
Selected
I applied via Naukri.com and was interviewed before Oct 2022. There were 3 interview rounds.
15 questions 30 Minuities
2 or 3 case study the will ask
(1 Question)
- Q1. Regarding CTC & Interests in the org.
Selected
I applied via Referral and was interviewed before Nov 2023. There was 1 interview round.
(2 Questions)
- Q1. Map implementation
- Q2. Oops questions, exception handling
shashwat sinha
Data structure and Algorithm problems.
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
GoMechanic Interview FAQs
Tell us how to improve this page.
GoMechanic Interviews By Designations
- GoMechanic Customer Relationship Manager Interview Questions
- GoMechanic Customer Relationship Executive Manager Interview Questions
- GoMechanic Data Analyst Intern Interview Questions
- GoMechanic Analytics Manager Interview Questions
- GoMechanic Production Manager Interview Questions
- GoMechanic Senior Business Development Manager Interview Questions
- GoMechanic Software Engineer Interview Questions
- GoMechanic Data Analyst 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
- Data Science Engineer Interview Questions
- Show more
GoMechanic Data Analyst Intern Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
|
Customer Relationship Manager
224
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Business Development Manager
63
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
57
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Executive
52
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Deputy Manager
45
salaries
| ₹0 L/yr - ₹0 L/yr |
Pitstop
Carcrew Technology
Bumper
Carpathy
- Home >
- Interviews >
- GoMechanic Interview Questions >
- GoMechanic Data Analyst Intern Interview Questions
