Impact Analytics logo

Impact Analytics Business Analyst Interview Questions
& Process

Real candidates share what happened, how many rounds they had,
and how the experience turned out.

Based on 32 interview experiences · FREE TO READ

2.9 Rounds average
Average Typical difficulty
68.8% Positive experience

Candidate interview experiences

First-hand accounts from people who interviewed at Impact Analytics.

Showing 3 of 32
Impact Analytics logo
Impact Analytics

Business Analyst

Analytics · a year ago

Senior Difficult Positive experience Decline offer 4 rounds
Interview process
Technical screen Technical screen Onsite Panel
Interview formats
Technical Case Behavioral

The interview process had four rounds. First, there was an aptitude test. Second, a technical interview focusing on Excel, SQL, and Python. Third, a case-based discussion with a senior manager for a Sr/Jr Business Analyst role, where the difficulty would be based on the role you applied for (Sr/Jr), covering Python & SQL. Fourth, a managerial round.

Confirmed questions2 questions
  • Can you tell me about your experience with your previous employer?
  • Could you share some responses to scenario-based questions?
Impact Analytics logo
Impact Analytics

Business Analyst

Analytics · more than a year ago

Entry Average Negative experience No offer 3 rounds
Interview process
Recruiter call Technical screen Technical screen Background check
Interview formats
Technical Behavioral

So I had a first call where I mentioned my 90-day notice period is firm. They were cool with it and we moved on. I did 2 technical rounds and passed both. They told me to hold on for the HR round for about a week. I emailed them a few times but got no response. When I finally reached out to HR, they said they have candidates with shorter notice periods (under 30 days) and need someone quickly. This completely contradicts what we initially discussed. It feels like a waste of everyone's time, and their internal communication is really poor.

Confirmed questions4 questions
  • Could you tell me about your experience with SQL?
  • What are your skills in Excel?
  • Do you have experience with Python?
Impact Analytics logo
Impact Analytics

Business Analyst

Analytics

Mid Average Negative experience Decline offer 4 rounds
Interview process
Technical screen Technical screen Group Recruiter call Offer
Interview formats
Technical Coding Case Behavioral Presentation

The interview process had four rounds and took about 7-8 weeks. The first two rounds were technical. The third round was a business fitment with a Project Manager. The last round was an in-person managerial interview in Bangalore. After the first three rounds, HR was unresponsive. She eventually said they were waiting on results from other candidates from a hiring drive. Two weeks later, she said the position was on hold. More than a month later, she called for an in-person HR round, stating they needed an immediate joiner and could only wait 30 days max. Since they made me wait so long, I lost interest and declined the offer.

Confirmed questions8 questions
  • In SQL, what is the order of query execution?
  • Could you explain GROUP BY and window functions in SQL?
  • How do you create a pivot table in Excel?

Impact Analytics Business Analyst Interview Questions

Quoted word for word from Impact Analytics interview reports.

What's the difference between RANK and DENSE_RANK functions?

Read reports

Given 25 horses and the constraint of racing only 5 at a time, determine the minimum number of races required to identify the top 3 fastest horses, knowing only their relative speeds from each race.

Read reports

Can you estimate the total sales of diapers or sanitary pads in India?

Read reports

How many taxis would you estimate are needed for a city of 1 million people?

Read reports

Write a query to find the highest salary within each department, using employee and department tables.

Read report

Explain the difference between the WHERE and HAVING clauses.

Read report

Given that 50% of people who get a first interview get a second, 95% of friends who got a second interview thought the first was good, and 75% of friends who did not get a second interview also thought the first was good, what is the probability you will get a second interview if you felt your first interview was good?

Read report

Formats, difficulty and experience

Across all 32 Impact Analytics interview reports.

Interview formats

Technical 42.7%
Coding 21.3%
Behavioral 19.1%
Case 13.5%
Other 2.2%

Interview difficulty

Easy 9.4%
Average 75%
Difficult 15.6%

Candidate experience

Negative 21.9%
Neutral 9.4%
Positive 68.8%