i
GoMechanic
Filter interviews by
Top trending discussions
I applied via Walk-in and was interviewed before Feb 2021. There were 3 interview rounds.
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 3 interview rounds.
Questions related to logical thinking
Common topics related to AI & other stuffs
I applied via LinkedIn and was interviewed in May 2023. There were 3 interview rounds.
Send assignment doings MS Excel
I applied via Approached by Company and was interviewed in Apr 2023. There were 2 interview rounds.
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
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...
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.
I applied via Approached by Company and was interviewed in Apr 2023. There were 6 interview rounds.
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,.
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.
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
I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.
Types of join in SQL include inner join, left join, right join, and full outer join.
Inner join returns only the matching records from both tables.
Left join returns all records from the left table and the matching records from the right table.
Right join returns all records from the right table and the matching records from the left table.
Full outer join returns all records when there is a match in either the left or rig
A left join is used to combine data from two tables based on a common column, including all records from the left table.
Left join returns all rows from the left table and the matching rows from the right table.
It is useful when you want to retrieve all records from the left table, even if there are no matches in the right table.
The result of a left join will have NULL values in the columns from the right table where th...
The number of rows after applying join operations depends on the type of join used and the data in the tables being joined.
Inner join retains only the rows that have matching values in both tables
Left join retains all rows from the left table and the matched rows from the right table
Right join retains all rows from the right table and the matched rows from the left table
Full outer join retains all rows when there is a
VLOOKUP in Excel is used to search for a value in a table and return a corresponding value, while SQL functions like JOIN and WHERE are used to retrieve data from multiple tables based on specified conditions.
VLOOKUP is specific to Excel and works on a single table, while SQL functions can work on multiple tables.
VLOOKUP requires the table to be sorted in ascending order, while SQL functions do not have this requiremen...
I applied via Company Website and was interviewed before Feb 2023. There were 2 interview rounds.
Simple SQL & Excel test
There are 2 coding challenges and 7 objective questions
based on 1 review
Rating in categories
Customer Relationship Manager
223
salaries
| ₹2.2 L/yr - ₹4.6 L/yr |
Business Development Manager
63
salaries
| ₹3 L/yr - ₹8.2 L/yr |
Assistant Manager
57
salaries
| ₹3.3 L/yr - ₹8 L/yr |
Senior Executive
52
salaries
| ₹2.4 L/yr - ₹5.3 L/yr |
Deputy Manager
45
salaries
| ₹4.3 L/yr - ₹11 L/yr |
Udaan
Swiggy
BlackBuck
Ninjacart