i
Impact Guru
Filter interviews by
Clear (1)
I was interviewed in Jan 2025.
Assignment of Google sheets
Analysis and logical reasoning involve examining data, identifying patterns, and drawing conclusions based on evidence.
Analysis involves breaking down complex information into smaller components for better understanding.
Logical reasoning is the process of using rational thinking to make sense of information and draw valid conclusions.
Analytical skills are essential for interpreting data accurately and making informed d...
Rank assigns unique ranks to each distinct value, while dense rank does not leave gaps between ranks.
Rank assigns unique ranks to each distinct value in a dataset
Dense rank does not leave gaps between ranks, assigning consecutive ranks to values with the same rank
For example, if values are 10, 20, 20, 30, then rank would be 1, 2, 2, 4 and dense rank would be 1, 2, 2, 3
Merge multiple files in Python using pandas.concat() or pd.merge() functions.
Use pandas.concat() function to merge multiple files vertically (row-wise).
Use pd.merge() function to merge multiple files horizontally (column-wise) based on a common column.
Ensure that the files have compatible column names and data types before merging.
Handle any missing or duplicate values appropriately during the merging process.
Consider ...
A data frame is a two-dimensional data structure in which data is stored in rows and columns.
Data frames are commonly used in programming languages like R and Python for data analysis.
Each column in a data frame represents a variable, while each row represents an observation.
Data frames can contain different types of data, such as numeric, character, and factor.
Data frames can be created from various sources like CSV f
Top trending discussions
I applied via Referral and was interviewed before Aug 2022. There were 2 interview rounds.
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...
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
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...
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.
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
I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.
It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.
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 LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.
The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
1. FROM: Specifies the tables involved in the query.
2. WHERE: Filters the rows based on specified conditions.
3. GROUP BY: Groups the rows that have the same values into summary rows.
4. HAVING: Filters groups based on specified conditions.
5. SELECT: Selects the columns to be included in the result set.
6. ORDER BY: Sorts the result set base
Conditional formatting in Excel allows users to format cells based on specified conditions.
Select the range of cells you want to apply conditional formatting to
Go to the 'Home' tab and click on 'Conditional Formatting'
Choose the desired formatting option, such as color scales, data bars, or icon sets
Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...
I applied via Company Website and was interviewed in Mar 2023. There were 3 interview rounds.
based on 3 interviews
Interview experience
based on 6 reviews
Rating in categories
Assistant Manager
54
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Development Associate
54
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Business Development Associate
52
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
33
salaries
| ₹0 L/yr - ₹0 L/yr |
Operations Associate
28
salaries
| ₹0 L/yr - ₹0 L/yr |
Milaap
Razorpay
Ketto
GiveIndia