AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Impact Guru
Compare
Filter interviews by
Clear (1)
Impact Guru Data Analyst Interview Questions, Process, and Tips
Top Impact Guru Data Analyst Interview Questions and Answers
- Q1. What do you know about analysis and logical reasoning
- Q2. How will merge multiple file in python
- Q3. Difference between rank and dense rank
Impact Guru Data Analyst Interview Experiences
3 interviews found
Anonymous
Selected
I was interviewed in Jan 2025.
(3 Questions)
- Q1. Sql questions mostly about windows function, aggregate, using having clause in group, union vs union all, mostly basics about sql.
- Q2. Power Bi questions - measures in powerbi, calculate, dashboard, excel vs powerbi.
- Q3. Assesment 5 question based on sql and excel. Easy questions like second highest salary, manager salary, count a's.
Interview Preparation Tips
(1 Question)
- Q1. Introduction of yourself
Assignment of Google sheets
(2 Questions)
- Q1. Self introduction
- Q2. What do you know about analysis and logical reasoning
- Ans.
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...
Interview Preparation Tips
Shubham Upadhyay
(3 Questions)
- Q1. Difference between rank and dense rank
- Ans.
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
- Q2. How will merge multiple file in python
- Ans.
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 ...
- Q3. Data frame explain in detail
- Ans.
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
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Selected
I applied via Referral and was interviewed before Aug 2022. There were 2 interview rounds.
(4 Questions)
- Q1. How do you setup a Dark Store?
- Ans.
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...
- Q2. How do joins work in the simplest manner?
- Ans.
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
- Q3. Write a basic query explaining the order of execution?
- Ans.
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...
- Q4. Difference between Group By and Distinct?
- Ans.
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.
Interview Preparation Tips
- SQL
- joins
- window functions
Skills evaluated in this interview
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.
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
sahithi reddy
Selected
I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.
(1 Question)
- Q1. What is the order of execution in sql
- Ans.
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
(1 Question)
- Q1. How to do conditional formatting in excel
- Ans.
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...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in Mar 2023. There were 3 interview rounds.
(1 Question)
- Q1. Detailed discussion on past experience and projects.
(2 Questions)
- Q1. 2 Hackerrank SQL Questions
- Q2. 1 Hackerrank Python Question
Interview Preparation Tips
- SQL
- Python
Impact Guru Interview FAQs
Recently Viewed
INTERVIEWS
Velnik India
No Interviews
LIST OF COMPANIES
Velnik India
Locations
DESIGNATION
SALARIES
E-Ring
INTERVIEWS
Velnik India
No Interviews
INTERVIEWS
Think41
No Interviews
LIST OF COMPANIES
Think41
Locations
INTERVIEWS
Clootrack Software Labs
No Interviews
INTERVIEWS
Oben Electric Vehicle
No Interviews
DESIGNATION
Tell us how to improve this page.
Impact Guru Interviews By Designations
- Impact Guru Business Development Associate Interview Questions
- Impact Guru Operations Associate Interview Questions
- Impact Guru Data Analyst Interview Questions
- Impact Guru Software Developer Interview Questions
- Impact Guru Product Manager Interview Questions
- Impact Guru QA Analyst Interview Questions
- Impact Guru Associate Product Manager Interview Questions
- Impact Guru Software Engineer 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
- Associate Data Analyst Interview Questions
- Show more
Impact Guru Data Analyst Interview Process
based on 3 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Impact Guru Data Analyst Reviews and Ratings
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
- Home >
- Interviews >
- Impact Guru Interview Questions >
- Impact Guru Data Analyst Interview Questions
