Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Impact Guru Team. If you also belong to the team, you can get access from here

Impact Guru Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Impact Guru Data Analyst Interview Questions, Process, and Tips

Updated 18 Feb 2025

Top Impact Guru Data Analyst Interview Questions and Answers

Impact Guru Data Analyst Interview Experiences

3 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 18 Feb 2025

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Jan 2025.

Round 1 - Technical 

(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

Interview preparation tips for other job seekers - Go through some questions for interview on data analyst role and read those, this thing will help you to understand many concepts. Not very hard interview also the interviewer is helpful.

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 23 Jul 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Introduction of yourself
Round 2 - Assignment 

Assignment of Google sheets

Round 3 - One-on-one 

(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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Hello guys this company provide good salary but not good appraisal

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Data Analyst Interview Questions & Answers

user image Shubham Upadhyay

posted on 19 Apr 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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

  • Answered by AI
  • 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 ...

  • Answered by AI
  • 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

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Aug 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - One-on-one 

(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...

  • Answered by AI
  • 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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Blinkit Data Analyst interview:
  • SQL
  • joins
  • window functions

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

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

Round 2 - Case Study 

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

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Aptitude Test 

It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Apr 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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.

  • Answered by AI
  • Q6. Normal excel statements like if, vlookup, xlookups etc.,

Interview Preparation Tips

Interview preparation tips for other job seekers - 1) Waste of time (never trust interviewer who explains about the role)
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

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Apr 2023. There were 6 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. Screening questions
  • Q2. Name, age, qualification, prior experience etc
Round 3 - Case Study 

Operation questions like vlookups, Hlookups, xlookups etc,.

Round 4 - Case Study 

Reporting questions like pivot tables, typing speed, power pivots, pricing sheet preparation

Round 5 - Case Study 

SQL queries like joins, aggregation functions, filters etc,.

Round 6 - One-on-one 

(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.

  • Answered by AI
  • 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

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(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

  • Answered by AI
Round 2 - Technical 

(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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be through with basics

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Mar 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. Detailed discussion on past experience and projects.
Round 3 - Technical 

(2 Questions)

  • Q1. 2 Hackerrank SQL Questions
  • Q2. 1 Hackerrank Python Question

Interview Preparation Tips

Topics to prepare for Razorpay Data Analyst interview:
  • SQL
  • Python
Interview preparation tips for other job seekers - Deep knowledge of SQL and Python is required along with Data Analysis fundamentals.
Contribute & help others!
anonymous
You can choose to be anonymous

Impact Guru Interview FAQs

How many rounds are there in Impact Guru Data Analyst interview?
Impact Guru interview process usually has 1-2 rounds. The most common rounds in the Impact Guru interview process are Technical, Assignment and One-on-one Round.
How to prepare for Impact Guru Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Impact Guru. The most common topics and skills that interviewers at Impact Guru expect are SQL, Data Analysis, Google Analytics, Tableau and R.
What are the top questions asked in Impact Guru Data Analyst interview?

Some of the top questions asked at the Impact Guru Data Analyst interview -

  1. What do you know about analysis and logical reason...read more
  2. How will merge multiple file in pyt...read more
  3. Difference between rank and dense r...read more

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 Data Analyst Interview Process

based on 3 interviews

Interview experience

3.3
  
Average
View more
Impact Guru Data Analyst Salary
based on 27 salaries
₹3.5 L/yr - ₹7.5 L/yr
15% less than the average Data Analyst Salary in India
View more details

Impact Guru Data Analyst Reviews and Ratings

based on 6 reviews

4.5/5

Rating in categories

4.7

Skill development

4.5

Work-life balance

4.5

Salary

4.5

Job security

4.5

Company culture

3.9

Promotions

4.5

Work satisfaction

Explore 6 Reviews and Ratings
Assistant Manager
54 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Associate
54 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Business Development Associate
52 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
33 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Operations Associate
28 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Impact Guru with

Milaap

3.8
Compare

Razorpay

3.6
Compare

Ketto

3.9
Compare

GiveIndia

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview