i
Impact Guru
Filter interviews by
I appeared for an interview 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
I applied via Walk-in and was interviewed before Feb 2021. There were 3 interview rounds.
I applied via Job Portal
SQL and Python data analysis questions
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 Referral and was interviewed in Aug 2023. There were 2 interview rounds.
SQL query optimisation
I applied via Referral and was interviewed before Sep 2023. There were 3 interview rounds.
Quant, LR, puzzles, cat based level 2 questions
Tuple is immutable and ordered, while list is mutable and ordered in Python.
Tuple is created using parentheses () while list is created using square brackets []
Tuple elements cannot be changed once assigned, while list elements can be modified
Tuple is faster than list for iteration and accessing elements
Example: tuple = (1, 2, 3) and list = [1, 2, 3]
I have a strong background in data analysis with experience in various industries.
Bachelor's degree in Statistics with a focus on data analysis
Proficient in SQL, Python, and data visualization tools like Tableau
Experience working with large datasets and conducting statistical analysis
Completed internships at XYZ Company and ABC Organization
Presented findings at industry conferences
I have learned to effectively analyze and interpret data to derive meaningful insights and make informed decisions.
Developed strong analytical skills through hands-on experience with various data analysis tools and techniques
Improved ability to identify trends, patterns, and outliers in data sets
Enhanced communication skills by presenting findings and recommendations to stakeholders
Learned to collaborate with team memb
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 in Apr 2024. There was 1 interview round.
HackerRank Test - Python, SQL
based on 3 interviews
Interview experience
based on 6 reviews
Rating in categories
Business Development Associate
56
salaries
| ₹2.6 L/yr - ₹7.2 L/yr |
Assistant Manager
54
salaries
| ₹3.4 L/yr - ₹10 L/yr |
Senior Business Development Associate
54
salaries
| ₹4 L/yr - ₹8 L/yr |
Senior Associate
31
salaries
| ₹2.5 L/yr - ₹6.5 L/yr |
Operations Associate
28
salaries
| ₹1.5 L/yr - ₹4.2 L/yr |
Milaap
Udaan
Swiggy
BlackBuck